Like I said, use an input type of radio or checkbox with the name of
ItemID
If you use checkboxes, then it will send a list of values to your action
page.
<input type="checkbox" name="ItemID" value="#qryname.ItemID#">
Say item 1 and 3 were checked, on your action page Form.ItemID would be
1,3
Using this you can do something like this
<cfquery ...>
SELECT contents
FROM table
WHERE 1=0
<cfloop list="#FORM.ItemID#" index="I">
OR itemID = #i#
</cfloop>
</cfquery>
______________________
steve oliver
cresco technologies, inc.
http://www.crescotech.com
-----Original Message-----
From: Schwartz, Paul [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 22, 2002 11:54 AM
To: CF-Talk
Subject: RE: RE: Query output in a form question
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
______________________________________________________________________
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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
