Re: [plum] Insert Record error

[David Churvis]

Marwan,   What's the value of the primary key being inserted?   Dave ----- Original Message ----- From: Marwan Saidi To: plum@mail.productivityenhancement.com Sent: Saturday, January 15, 2005 11:15 AM 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