Re: Database problems
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) > > > > > > > > > There was an error. > > -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Database problems
Try This.
insert into LINKS
(APPROVE,
TYPE_DESC,
MAIN_NBR,
LINK)
values
('#form.APPROVE#',
'#form.TYPE_DESC#',
'#form.MAIN_NBR#',
'#form.LINK#')
select 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
Chapman To: [EMAIL PROTECTED]
Subject: RE: Database problems
08/11/2000
11:45 AM
Please
respond to
cf-talk
Can we see some code? You may be nesting your tags incorrectly.
--K
Katrina,
I think the code's fine, but here is the action template, anyway.
Thanks,
--John
insert into LINKS
(APPROVE,
TYPE_DESC,
MAIN_NBR,
LINK)
values
('#form.APPROVE#',
'#form.TYPE_DESC#',
'#form.MAIN_NBR#',
'#form.LINK#')
select max(record) as newrecord
from links
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Database problems
You most likely want the outside the . CF is
probably never hitting the closing tag and therefore is
doing a rollback of the insert.
Just a guess, but makes sense. I think. :)
Dan
-Original Message-
From: John Allred [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 11, 2000 10:57 AM
To: [EMAIL PROTECTED]
Subject: RE: Database problems
Katrina
Chapman To: [EMAIL PROTECTED]
Subject: RE: Database problems
08/11/2000
11:45 AM
Please
respond to
cf-talk
Can we see some code? You may be nesting your tags incorrectly.
--K
Katrina,
I think the code's fine, but here is the action template, anyway.
Thanks,
--John
insert into LINKS
(APPROVE,
TYPE_DESC,
MAIN_NBR,
LINK)
values
('#form.APPROVE#',
'#form.TYPE_DESC#',
'#form.MAIN_NBR#',
'#form.LINK#')
select max(record) as newrecord
from links
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Database problems
Katrina
Chapman To: [EMAIL PROTECTED]
Subject: RE: Database problems
08/11/2000
11:45 AM
Please
respond to
cf-talk
Can we see some code? You may be nesting your tags incorrectly.
--K
Katrina,
I think the code's fine, but here is the action template, anyway.
Thanks,
--John
insert into LINKS
(APPROVE,
TYPE_DESC,
MAIN_NBR,
LINK)
values
('#form.APPROVE#',
'#form.TYPE_DESC#',
'#form.MAIN_NBR#',
'#form.LINK#')
select max(record) as newrecord
from links
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Database problems
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 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 record just inserted and CFLOCATION to the entry form, all I do is increment the database ID, but don't insert any data. Can anyone hazard a guess what's causing this? I've read everything I can get my hands on, and I can't seem to figure it out. Thanks, --John -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Database problems
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 record just inserted and CFLOCATION to the entry form, all I do is increment the database ID, but don't insert any data. Can anyone hazard a guess what's causing this? I've read everything I can get my hands on, and I can't seem to figure it out. Thanks, --John -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
