Error Executing Database Query.
[MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Syntax error in INSERT INTO statement.
The error occurred in D:\websites\clients.cfm: line 34
32 : <CFUPDATE datasource="#application.db#"
tablename="clients">
33 : <CFELSE>
34 : <CFINSERT datasource="#application.db#"
tablename="clients">
35 : </CFIF>
36 : </CFIF>
SQL insert into clients (COMPANY,DATE) values ( (param 1) , (param 2) )
DATASOURCE devchat
VENDORERRORCODE -3502
SQLSTATE 42000
Please try the following:
At 10:36 AM 2/24/2004, you wrote:
>Marlon Moyer said:
> > Has anyone else noticed how handy cfinsert would be if you could get
> > the inserted identity back?
>
>That might be a future possibility once we move to JDBC 3:
><http://www.macromedia.com/go/wish/>http://www.macromedia.com/go/wish/
>
>Jochem
>
>----------
>[
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
