Improve company productivity with a Business Account.Sign Up

x
?
Solved

ColdFusion - How to pass form variables from a form thru a CFGrid page to a 3rd data display page

Posted on 2004-08-09
2
Medium Priority
?
676 Views
Last Modified: 2013-12-16
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.

I.E.:

<cfif #form.OptionB# eq 'Arrangements'>

<cfquery name="LookupTask" datasource="#session.datasource#" >
Select RecNum,OptionA,fld2, fld3, fld4, fld5, Authorization, Reconciliation, Payment, Administration, Accountability
FROM TableA
WHERE fld5 = 'Yes' and OptionA = '#form.OptionA#' and Arrangements = 'Yes';
</cfquery>
      <cfoutput><input type=hidden name="tempOptionB" value="Arrangements"></cfoutput>
      <cfif #LookupTask.RecordCount# eq 0 >
            <Script>alert("There are no Records ready at this time.");
             location.href="first form";
             </script>
      <cfelse>
                       show cfgrid   (select record number to get to next page)

                </cfif>

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!

ptslv

Any ideas as to how I can accomplish this in the next 24 hours would be greatly appreciated!
0
Comment
Question by:ptslv
2 Comments
 
LVL 4

Accepted Solution

by:
Ike23 earned 2000 total points
ID: 11758335
I'm not sure if you are using a form but you could try passing the values as hidden form fields.  This is a tag by Ben Forta that is easy to use and automatically takes any form fields and creates hidden fields to pass to the next page...

http://www.macromedia.com/cfusion/exchange/index.cfm?view=sn131&extID=1000001

The tag is called cf_embedfields  The link to the tag is also here:

http://www.forta.com/cf/tags/

Hope that helps.

Ike
0
 

Author Comment

by:ptslv
ID: 11772457
Thanks for the response, Ike.  I relooked at my code.  I was using a hidden field at one point, which didn't work.  The hidden variable would pass to the second page, which was the grid page, but then it would drop out.  So I changed it to a session variable, which I could update.  I found that I had set the session variable in the wrong place.  

I haven't tried the cf_embedfields, but I will take a look at it for future reference.  Again, thanks for the help.

ptslv
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Preface This is the third article about the EE Collaborative Login Project. A Better Website Login System (http://www.experts-exchange.com/A_2902.html) introduces the Login System and shows how to implement a login page. The EE Collaborative Logi…
This article covers the basics of the Sass, which is a CSS extension language. You will learn about variables, mixins, and nesting.
The purpose of this video is to demonstrate how to set up the permalinks on a WordPress Website. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Go t…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

595 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question