I must not be writing this correctly:

<cfif FORM.transactionType LTE 5><cfqueryparam cfsqltype="cf_sql_date"
value="#CreateODBCDate(FORM.paidThru)#">,  <cfelse><cfqueryparam
cfsqltype="cf_sql_date" null="yes"></cfif>

Because I get this error thrown:

The system has attempted to use an undefined value, which usually indicates
a programming error, either in your code or some system code. Null Pointers
are another name for undefined values.

What's the correct way to write a null to a date/time field in SQL 2000?

Thanks,
Mark
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to