helps if you paste the exact error message and/or code.
in this case, since cfinsert is fairly straightforward, what's the exact
error?
- Original Message -
From: Steven Sharko [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, February 24, 2004 8:13 AM
Subject: CFINSERT on
Has anyone else noticed how handy cfinsert would be if you could get the
inserted identity back?
Marlon
-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 24, 2004 9:24 AM
To: CF-Talk
Subject: Re: CFINSERT on CFMX (newbe question)
helps
Can you give us a code example?I can think of lots of reasons.
Is one of your field names a reserved keyword?Like date?
Are your field names named like Address, Address2, Address3?See
http://www.macromedia.com/support/coldfusion/ts/documents/cfinsert_hotfi
x.htm
.
Mark W. Breneman
-Cold Fusion
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/
Jochem
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
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#
, 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
From: Marlon Moyer
Has anyone else noticed how handy cfinsert would be if you
could get the inserted identity back?
Well, if you want to do something like that, don't use CFINSERT - use a
regular CFQUERY and you have complete control over what you want to do
I've not used CFINSERT or
From: Mark W. Breneman
I believe that date is reserved keyword. Try changing that
field name.
Or switch to CFQUERY and put square brackets around the field names
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
-Original Message-
From: Philip Arnold [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 24, 2004 10:05 AM
To: CF-Talk
Subject: RE: CFINSERT on CFMX (newbe question)
From: Mark W. Breneman
I believe that date is reserved keyword. Try changing that
field name.
Or switch to CFQUERY
DATE is a reserved word. Either change the column name in the db or
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
Mark W. Breneman said:
Will that fieldname date come back to bite him later?
It will probably continue to cause inconvenience, but nothing major.
It is just not something you would want a prospective employer to see.
Ha, It must be the masochist in me but I still use Cfupdate and
insert even
-Talk
Subject: RE: CFINSERT on CFMX (newbe question)
Mark W. Breneman said:
Will that fieldname date come back to bite him later?
It will probably continue to cause inconvenience, but nothing major.
It is just not something you would want a prospective employer to see.
Ha, It must
12 matches
Mail list logo