Solved

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

Posted on 2014-09-30
5
143 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
  • 3
  • 2
5 Comments
 
LVL 48

Accepted Solution

by:
PortletPaul earned 500 total points
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Apologies a series of errors on my part but thank you for pointing out the obvious, sighs. Thank you!
0
 
LVL 48

Expert Comment

by:PortletPaul
Comment Utility
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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

772 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now