Dave Watts wrote:
>
> > In one of my pages I have a few insert queries that I run
> > inside of a cftransaction. Depending on the results I did
> > have a cflocation tag to redirect them to a outcome page.
> > They would get redirected fine, but the insert queries
> > would not run properly, as in they wouldn't write to the
> > table. Is this because the cflocation has the ability to
> > break a cftransaction block????
>
> Yes, when CFLOCATION is processed, nothing else in that page following the
> CFLOCATION is processed.
>
Dave,
I've been struggling with the same problem. I want to perform an update
or an insert, then redirect the user to another page. Can you outline a
strategy for accomplishing this? Should I just remove the
<cftransaction>? Although this seems like it would work, I wouldn't be
able to get the result I want. That is, I don't want to move the user
forward UNLESS the insert or update has been successful.
One other thing. With this setup, I increment my autonumber field for
inserts, but there is no record created in the table.
Thanks,
John
--
John Allred / Jackson, Mississippi
Mississippi Counties
http://www.mscounties.com/
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
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.
