Beginner CFer with an easy question. The situation: the user selects the rows to query based upon ticking checkboxes. So, this is the first page:
<form action="tally.cfm" method="post"> <input type="checkbox" name="id" value="180"> <input type="checkbox" name="id" value="192"> <input type="checkbox" name="id" value="204"> <input type="checkbox" name="id" value="307"> <input type="submit" value="go"> </form> Using a list and a cfloop to return multiple columns in only the rows the user selects, what would the tally.cfm page look like? I'm looking at something like this, but I know it's wrong: <cfloop index="ListIndex" list="#FORM.id#" delimiters=","> <cfquery name="listsQuery" datasource="xxx"> SELECT this, that, theotherthing FROM tblName WHERE ID = #id# </cfquery> <cfoutput query="listsQuery">#this#<br>#that#<br>#theotherthing#<br><br></cfoutput> </cfloop> Thanks for your help. ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
