Re: Bad External Date Representation

2003-02-14 Thread Jochem van Dieten 
Jillian Carroll wrote:
>  
> 
> UPDATEattendee
> SET
> 
> regreceived =
> #CreateODBCDate(ParseDateTime(Trim(Form["regreceived" & Indx])))#,
> 
> regreceived = NULL,
> 
> 
>  
> I can't find what's wrong... ideas?

The comma. But I would use:


   UPDATEattendee
   SET
 regreceived = 


Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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:
 

UPDATEattendee
SET

regreceived =
#CreateODBCDate(ParseDateTime(Trim(Form["regreceived" & Indx])))#,

regreceived = NULL,


 
I can't find what's wrong... ideas?
 
--
Jillian

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4