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:192384
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=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
