Katrina,
You and Dan removed a huge weight that had made lots of stuff difficult.
Moving the CFLOCATION outside the CFTRANSACTION did the trick.
Thanks so much,
--John
"Chapman, Katrina" wrote:
>
> Try This.
>
>
>
> (insert query)
>
>
>
> (get last entered record)
>
>
>
>
max(record) as newrecord
from links
There was an error.
-Original Message-
From: John Allred [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 11, 2000 10:57 AM
To: [EMAIL PROTECTED]
Subject: RE: Database problems
Katrina
Chapm
AM
To: [EMAIL PROTECTED]
Subject: RE: Database problems
Katrina
Chapman To: [EMAIL PROTECTED]
Subject: RE: Database problems
08/11/2000
11:45 AM
]
Subject: RE: Database problems
08/11/2000
Can we see some code? You may be nesting your tags incorrectly.
--K
-Original Message-
From: John Allred [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 11, 2000 5:00 AM
To: CF-Talk
Subject: Database problems
I have a strange problem with inserts in an Access table. I can't se
I have a strange problem with inserts in an Access table. I can't seem
to wrap either a CFINSERT or an SQL insert within a CFTRANSACTION.
Either method, without a CFTRANSACTION, will successfully insert a
record in my table. But as soon as I try to use CFTRANSACTION, so I can
get the ID of the rec
6 matches
Mail list logo