Bad External Date Representation

2003-02-14 Thread Jillian Carroll
I'm getting this error: ODBC Error Code = 0 () Error while executing the query (non-fatal); ERROR: Bad boolean external representation '' From this code: cfquery name=update datasource=#DSN# UPDATEattendee SET cfif IsDate(Trim(Form[regreceived Indx]))

Re: Bad External Date Representation

2003-02-14 Thread Jochem van Dieten
Jillian Carroll wrote: cfquery name=update datasource=#DSN# UPDATEattendee SET cfif IsDate(Trim(Form[regreceived Indx])) regreceived = #CreateODBCDate(ParseDateTime(Trim(Form[regreceived Indx])))#, cfelse regreceived = NULL,