Login    Forum    Search    FAQ   Blog

Board index » Server Side Development » SQL




 Page 1 of 1 [ 4 posts ] 



Author Message
 Post subject: String is nt at all recognisd as a valid Date Time
 Post Posted: Thu Nov 19, 2009 6:49 am 
Offline

Joined: Sat Feb 21, 2009 1:03 pm
Posts: 47
Hi m havin a web application writtn in the asp.net nd
c# but i am gettin dis kinda error when i run ma web app on a diff
laptop to da one i develop on nd i could not figure out why 1
pc gives da exception n one doesnt, I guess it was sum '
SQL Server settin dat differs on both the pcs however i dont know how 2
find it. Any suggstion would really be really appreciated
Thanks in advance


Top 
 Post subject: Re: String is nt at all recognisd as a valid Date Time
 Post Posted: Thu Nov 19, 2009 6:49 am 
Offline

Joined: Sat Feb 21, 2009 11:06 am
Posts: 1794
Make sure dat the parameters in da stored procedure are DATETIMES,
and you would be on da safe side bcoz you then could validate da
entered dates on da client side instead.


Top 
 Post subject: Re: String is nt at all recognisd as a valid Date Time
 Post Posted: Thu Nov 19, 2009 6:50 am 
Offline

Joined: Sat Feb 21, 2009 1:03 pm
Posts: 47
thanks 4 ur reply
yes the values on da stored procedure are ok howevr i need 2 change
sumthin in ma app 2 avoid probs wid the diff date formats


Top 
 Post subject: Re: String is nt at all recognisd as a valid Date Time
 Post Posted: Thu Nov 19, 2009 6:50 am 
Offline

Joined: Sat Feb 21, 2009 11:06 am
Posts: 1794
In ur client application , provide info 2 user 2 always enter the
date in a specific format.Then verify format of date enterd 2 see if
it follows new rules. Then do verify for the ISDATE function.
And last send 2 the database.


Top 
Display posts from previous:  Sort by  
 
 Page 1 of 1 [ 4 posts ] 




Board index » Server Side Development » SQL


Who is online

Users browsing this forum: No registered users and 1 guest

 
 

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron