Re: ASP SQL Insert NULL Date Value
From: Aaron Bertrand - MVP (aaron_at_TRASHaspfaq.com)
Date: 02/19/04
- Next message: Jeremy: "Re: Calling from db gives unwanted 'null' response"
- Previous message: newbie: "Re: Newbie - Stored Procedures/ASP Question"
- In reply to: Chad S: "ASP SQL Insert NULL Date Value"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 19 Feb 2004 12:10:12 -0500
<%
If Request.Form("sProcedureDate1") = "0" OR
Request.Form("sProcedureDate2") = "0" OR Request.Form("sProcedureDate3")
= "0" Then
sProcedureDate = "NULL"
Else
sProcedureDate = "'" & Request.Form("sProcedureDate1") & "/" &
Request.Form("sProcedureDate2") & "/" & Request.Form("sProcedureDate3") &
"'"
End If
%>
Then remove the single quotes:
"', " & sProcedureDate &_
", '" & sStartTime &_
In addition, I *STRONGLY* urge you to use YYYYMMDD format instead of this
confusing and ambiguous m/d/y or d/m/y format.
-- Aaron Bertrand SQL Server MVP http://www.aspfaq.com/
- Next message: Jeremy: "Re: Calling from db gives unwanted 'null' response"
- Previous message: newbie: "Re: Newbie - Stored Procedures/ASP Question"
- In reply to: Chad S: "ASP SQL Insert NULL Date Value"
- Messages sorted by: [ date ] [ thread ]
