?
Solved

insert time from asp:textbox to time(0) column in sql 2008

Posted on 2014-09-30
5
Medium Priority
?
149 Views
Last Modified: 2014-09-30
hi Experts,

I am inserting a time value e.g. 10:00 from a web form, this has been working fine but since making some changes to the sproc I am getting a syntax error on the time value. It seems that the web form is sending the time as 10:00, but sql is expecting '10:00', can anyone advise how to overcome this problem?

I am using a control parameter on the web form:

<asp:ControlParameter Name="StartTime" ControlID="TxtStart" PropertyName="Text"  ConvertEmptyStringToNull="true" />

many thanks in advance
0
Comment
Question by:forsters
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 49

Accepted Solution

by:
PortletPaul earned 2000 total points
ID: 40351812
SQL has not changed its mind on how time should be expressed, it has always needed the single quotes.

But if the change is in the sproc then comparing before and after sproc code would help.
0
 

Author Comment

by:forsters
ID: 40351846
hi, thanks for your comment, the sproc has changed but the time columns were in the original and haven't been altered. Prior to this change we migrated the db over from sql 2008 to sql 2012, although this error has only come to light now that I have made some amends to the sproc - all I have done is add some additional parameters so I am a little confused.
0
 

Author Comment

by:forsters
ID: 40351873
hmm I've rolled back to the original sproc and webform and resolved the error so I will re-add each new param individually and see what happens.
0
 

Author Closing Comment

by:forsters
ID: 40351964
Apologies a series of errors on my part but thank you for pointing out the obvious, sighs. Thank you!
0
 
LVL 49

Expert Comment

by:PortletPaul
ID: 40351978
if it ain't broke don't fix it...
or,
always look where the changes have been made...

I get it. sigh. best of luck. we all been there.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

IntroductionWhile developing web applications, a single page might contain many regions and each region might contain many number of controls with the capability to perform  postback. Many times you might need to perform some action on an ASP.NET po…
Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question