What I'm trying to do is on the result page to dynamically pull only the items that were checked or radio or possibly an input textbox. And not pull the ones that were not chosen. With the The form result page however when I use the variables it only shows the last entry in the input. How do I dynamically pull the data?
Example of data Entry1,key,size Entry2,key,size Entry3,key,size Entry4,key,size So if I only want the 1st and 3rd entry on the result page can it be done dynamically so I don't have to modify the page every time I add a new entry in the database? Date: Mon, 21 Jan 2002 15:54:43 -0500 From: "Steve Oliver" <[EMAIL PROTECTED]> Subject: RE: Query output in a form question Message-ID: <004501c1a2bd$da3b69d0$[EMAIL PROTECTED]> I'm not sure what you mean, do you just want to pass the Item ID of an item with a radio input next to it? If so just do something like this. <input type="Radio" name="ItemID" value="#ItemID#"> #ItemName# Then the value of FORM.Item on the next page will be your itemID. ______________________ steve oliver cresco technologies, inc. http://www.crescotech.com -----Original Message----- From: Schwartz, Paul [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 2:44 PM To: CF-Talk Subject: Query output in a form question Hello, I have a db table that im querying into an html form table. I would like have an input field linked to each entry in the database. So that on submit it will only show the choices that were checked with a radio button or something. Is this possible? Here is the information that Im wanting to carry over to the second form page. Where the number of items in the database is about 25 items. So that if they only click on the radio button for say item 21 on the second page it will pull all of the inputs from the top table and only item number 21 from the second table. Thanks in Advance. Paul Schwartz <!---code---> <form name="form1" method="post" action="FORM2.cfm"> <table><tr><td> <tr> <td>Name:</td><td><input type="text" name="name"></td> <td>Manager:</td><td><input type="text" name="manager"></td> </tr> <tr> <td>Employee ID:</td><td><input type="text" name="empid"></td> <td>Department:</td><td><input type="text" name="dept"></td> </tr> <tr> <td>Phone Number:</td><td><input type="text" name="phone"></td> <td>Location:</td><td><input type="text" name="location"></td> </tr> <tr> <td>Extension:</td><td><input type="text" name="extension"></td> </TR> <table align=center> <TR> <TD>ITEM1</TD> <TD>ITEM2</TD> <TD>ITEM3</TD> <TD>ITEM4</TD> <TD>KEY</TD></TR> <CFOUTPUT query="ITEMS"><tr> <td width="45%">#ENTRY1#</a></td> <td>#ENTRY2#</td> <td>#ENTRY3#</td> <td>#ENTRY4#</td> <td><input type="RADIO" name="#key#"></td></tr> </CFOUTPUT> <!---code ends---> IMPORTANT NOTICE: This message is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you have received this message in error, you are hereby notified that we do not consent to any reading, dissemination, distribution or copying of this message. If you have received this communication in error, please notify the sender immediately and destroy the transmitted information. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
