Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
Vivid Media
[EMAIL PROTECTED]
www.vividmedia.com
608.270.9770
-----Original Message-----
From: Steven Sharko [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 24, 2004 9:46 AM
To: CF-Talk
Subject: RE: CFINSERT on CFMX (newbe question)
Error Occurred While Processing Request
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]