This is a pretty urgent question.
I have a set of pages I am trying to input form filter data, pass it thru a cfgrid page (which uses it as a filter criteria to get the query data), and pass it to a third page, which will end up using the variable as a form variable.
User selects optionA and optionB.
Both are passed to cfgrid where I display the grid data based on query output that matches optionA, and where optionB (which is one of 6 fields in the table) = Yes.
<cfif #form.OptionB# eq 'Arrangements'>
<cfquery name="LookupTask" datasource="#session.datasource#" >
Select RecNum,OptionA,fld2, fld3, fld4, fld5, Authorization, Reconciliation, Payment, Administration, Accountability
WHERE fld5 = 'Yes' and OptionA = '#form.OptionA#' and Arrangements = 'Yes';
<cfoutput><input type=hidden name="tempOptionB" value="Arrangements"></cfoutput>
<cfif #LookupTask.RecordCount# eq 0 >
<Script>alert("There are no Records ready at this time.");
show cfgrid (select record number to get to next page)
When I get to the 3rd page, I am getting errors that the tempOptionB does not exist. I have even tried setting it as a cfparam and a session variable. The value just won't pass thru the grid page to the next page.
Thanks in advance!
Any ideas as to how I can accomplish this in the next 24 hours would be greatly appreciated!