<CFQUERY NAME="get_people" DATASOURCE="taskomatic"> SELECT person_id FROM people WHERE person_id = '#Form.person_id#' </CFQUERY>
This query is only going to return one record, assuming person_id is an unique key. I suspect what you may be wanting is a IN clause <CFQUERY NAME="get_people" DATASOURCE="taskomatic"> SELECT person_id FROM people WHERE person_id IN (<cfqueryparam value="#Form.person_id#" list="yes" cfsqltype="cf_sql_varchar">) </CFQUERY> HTH, otherwise we need to know more about #form.person_ID# and the people table. -------------- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning ...-----Original Message----- ...From: Chris Kavanagh [mailto:[EMAIL PROTECTED] ...Sent: Monday, January 31, 2005 11:07 AM ...To: CF-Talk ...Subject: CFLOOP not looping ... ...Dear list, ... ...My CFLOOP doesn't seem to be looping my INSERTS. ... ...A form passes the variables #person_id# & #project_id# to this page: ... ...<head> ...<CFQUERY NAME="get_people" DATASOURCE="taskomatic"> ... SELECT person_id FROM people ... WHERE person_id = '#Form.person_id#' ...</CFQUERY> ...</head> ... ...<body> ...<CFLOOP QUERY="get_people"> ... <CFQUERY NAME="insert_records" DATASOURCE="taskomatic"> ... INSERT INTO people_project (person_id, project_id) ... VALUES ('#Form.person_id#', '#Form.project_id#') ... </CFQUERY> ...</CFLOOP> ...</body> ... ...-- ... ...When there are multiple #person_id#s, I was hoping the CFLOOP would ...create multiple rows in the table. But it doesn't. :/ What am I ...doing wrong this time? ... ...Many thanks, ...CK. ... ... ... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192395 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54