CFTRANSACTION & passing parameters via URL

[Sheng, Joseph Y [AMSTA-AR-CI]]

   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.  

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.

3.  Is there a way to check the status of <CFTRANSACTION> whether it ran or
rolled back?

   TIA.

...Joe Sheng
------------------------------------------------------------------------------
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.