switch to <cfquery>
> -----Original Message-----
> From: Steven Sharko [mailto:[EMAIL PROTECTED]
> Sent: dinsdag 24 februari 2004 16:46
> 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]
