datetime problems - 01/01/1900

[cfdeveloper]

Hello,

I'm assuming this one should be an easy one. I'm running an insert query and one of the fields is date/time. When I DO NOT send a value to it, I want to insert is as <NULL>, but instead, it's going in as "1/1/1900".

How should I do my query where I can send a NULL Value?

Thanks,

cfcoder

 

[cfdeveloper]

I figured it out. Here is the code

<cfqueryparam cfsqltype="cf_sql_timestamp" value="" null="1">

Regards,
cfcoder

 

[webmigit]

Thanks for the tip

ALFII.com

http://www.alfii.com

---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.