RE: [plum] Insert Record error

Tue, 01 Feb 2005 09:29:05 -0500

This appears to be fixed.

 

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marwan Saidi
Sent: Saturday, January 15, 2005 11:15 AM
To: [email protected]
Subject: [plum] Insert Record error

 

When submitting an insert form that includes a chooser, I am getting an error where it looks like the insert custom tag is formatting the lookup key as a date, which is causing a fail on the lookup. Here is the error message (from CF Admin):

 

(Database 241) Error Executing Database Query.: [Macromedia][SQLServer JDBC Driver][SQLServer]Syntax error converting datetime from character string. SQL: SELECT iUnitTypeID FROM tblUnitTypes WHERE strUnitType = {ts '1899-12-30 06:00:00'}

 

I can zip and send the files from this module to the support address if you want.

 

Marwan Saidi

American Eagle Information Systems

321.779.2577 - p

321.779.2576 - f

 

 

Reply via email to