lulu50
asked on
date "1900-01-01 00:00:00.000"
hi,
When the date textbox is empty. It will insert into my table DateResolved like this
"1900-01-01 00:00:00.000"
I don't want to insert anthing if there is no date.
here's my code
When the date textbox is empty. It will insert into my table DateResolved like this
"1900-01-01 00:00:00.000"
I don't want to insert anthing if there is no date.
here's my code
<cfif IsDefined('FORM.DateResolvedtxt') && #form.DateIdentifiedtxt# neq ''>
<cfqueryparam value="#form.DateResolvedtxt#" cfsqltype="cf_sql_timestamp"> ,
<cfelse>
NULL ,
</cfif>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excellent!!!!
ASKER
wow, I don't know what to say.
I have tried everything but it didn't work, nothing works with me.
Great!!
Thank you it works great now!!!
hmmm, maybe I should change my profession.
lol
Thanks again,
Lulu