On Oct 30, 2007 6:04 AM, Peter Tanswell <[EMAIL PROTECTED]> wrote: > OK - that made a difference > I'm now getting the following: > > Variable GIRLS is undefined. The error occurred in *C:\Program > Files\Apache Software Foundation\Apache2.2\htdocs\gkpro\act_checkin.cfm: > line 55* > > 53 : </CFQUERY> > 54 : *55 : <cfloop list="#girls#" index="q"> * > 56 : <cfquery name="qinsertrecs" datasource="#request.db_dsn#" > username="#request.db_login#" password="#request.db_pwd#"> > 57 : INSERT INTO tbl_onshift (girlid, girlwname) > > Any ideas?
That one's pretty straightforward, no? I mean, it sounds to me like you need to define the variable (list) 'girls' before looping over it. -- Charlie Griefer ================================================ "...All the world shall be your enemy, Prince with a Thousand Enemies, and whenever they catch you, they will kill you. But first they must catch you, digger, listener, runner, prince with a swift warning. Be cunning and full of tricks and your people shall never be destroyed." ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292337 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

