are you sure your query is returning records? do a
<cfoutput>#get_people.recordcount#</cfoutput> after your </cfquery> to
make sure.
On Mon, 31 Jan 2005 19:07:13 +0000, Chris Kavanagh <[EMAIL PROTECTED]> wrote:
> 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:192386
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
