You most likely want the <cflocation> outside the <cftransaction>. CF is
probably never hitting the closing <cftransaction> 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]
<kchapman@vol cc:
t.com> 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
<cftransaction>
<cfquery datasource="county">
insert into LINKS
(APPROVE,
TYPE_DESC,
MAIN_NBR,
LINK)
values
('#form.APPROVE#',
'#form.TYPE_DESC#',
'#form.MAIN_NBR#',
'#form.LINK#')
</cfquery>
<cfquery name="getid" datasource="county">
select max(record) as newrecord
from links
</cfquery>
<cfset record = #getid.newrecord#>
<cflocation url="link_add.cfm">
</cftransaction>
----------------------------------------------------------------------------
--
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.