insert blank date into mssql database 3

[brianpercival]

Hi,

I have a date field which if user inputs a date should be inserted into the table, and a blank value if not. I do a cfif cfelse with the else part as default ''(empty). and the date being stored in the db is 1/1/1900 in case of empty. So when I retrieve it, it brings 1/1/1900 which I don't want. How do I store a blank date???

regards,
Brian

 

[ecobb]

Try NULL instead of ''


Hope This Helps!

ECAR
ECAR Technologies, LLC

http://www.ecartech.com

"My work is a game, a very serious game." - M.C. Escher

 

[brianpercival]

ECAR,

I know but I Don't want the field to be null. Is there any way around?

regards,
Brian

 

[r937]

why don't you want it to be NULL?

note that a "blank" date is impossible

what dbms is this?



r937.com | rudy.ca

 

[brianpercival]

this is mssql. I guess I will have to make them allow null then..

regards,
Brian

 

[TruthInSatire]

what's wrong with NULL? when it comes back to CF it is "" but when you check a db you use null.

where dateField <> NULL

if queryName.dateField neq ""

We've heard that a million monkeys at a million keyboards could produce the complete works of Shakespeare; now, thanks to the Internet, we know that is not true.

 

[r937]

where dateField <> NULL ???

um, no



r937.com | rudy.ca

 

[TruthInSatire]

holy cow wth was i thinking??

WHERE dateField IS NOT NULL

thanks rudy

We've heard that a million monkeys at a million keyboards could produce the complete works of Shakespeare; now, thanks to the Internet, we know that is not true.