> I am using <CFTRANSACTION> to group 3 <CFQUERY>.
>
> <CFTRANSACTION>
> <CFQUERY NAME="Q1" DATASOURCE="...">
> SELECT RFPNum Form SolNum
> </CFQUERY>
>
> <CFQUERY NAME="Q2" DATASOURCE="...">
> INSERT INTO RFPNumAssigned(SolNum, ACGroup, SpecialistCode)
> VALUES(#GetSolNum.RFPNum#, #URL.ACGroup#, #URL.SpecialistCode#)
> </CFQUERY>
>
> <CFQUERY NAME="Q3" DATASOURCE="...">
> ...............
> </CFQUERY>
> </CFTRANSACTION>
>
> Following are my questions.
>
> 1. I need to reference to the RFPNum that was retrieved
> from the 1st Query in the 2nd <CFQUERY>. I have tried
> #GetSolNum.RFPNum# and that does not seem to be correct.
> I have also enclosed entire 2nd <CFQUERY> in <CFOUTPUT
> QUERY="Q1">, and that does not seem to work either.
You need to reference the query name, not the name of the table from which
the field was retrieved:
VALUES(#Q1.RFPNum#, ...
> 2. I am passing ACGroup and SpecialistCode parameters on
> an URL to this CF template. However, when I reference #URL.ACGroup#
> or #URL.SpecialistCode# in the template, I get error message
> indicating that these parameters doesn't seem to exist.
Without seeing the URL, I can only guess that it isn't formed correctly. It
should look something like this:
http://www.myserver.com/myfile.cfm?acgroup=5&specialistcode=12
> 3. Is there a way to check the status of <CFTRANSACTION>
> whether it ran or rolled back?
If you didn't get an error, it ran successfully.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
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.
