Re: Values in a loop

An unchecked checkbox doesn't exist in the subsequent form scope. Move your CFIF up above your CFSET's: cfloop index=pmt from = 1 to = #form.numrows# cfif isDefined(form.paid_#pmt#) and Trim(pd) eq Confirmed cfset pd=form['paid_' pmt] cfset rid=form['regid_' pmt] cfquery datasource=#dsn#

RE: Values in a loop

Hey Jason, Thanks! It worked after I moved it like you suggested. Rick -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: April-30-09 8:17 AM To: cf-talk Subject: Re: Values in a loop An unchecked checkbox doesn't exist in the subsequent form scope. Move your

Values in a loop

referencing the values in a loop correctly? Thank you for your help. Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk

reseting querys values in a loop

Hello, I am running a loop and in it I have eight querys the are conditional and I was wondering if there is a way to reset them to null after each loop.What is happening is that I pick the first record it runs fine then I pick the second record and if one of the querys is not processed

RE: reseting querys values in a loop

Jim, What does your loop look like? Also, what do the where clauses in your 8 queries look like? Could you post some code? Mike -Original Message- From: Jim Louis [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 8:45 AM To: CF-Talk Subject: reseting querys values

RE: reseting querys values in a loop

Code cfloop index=recordid From = 46 To = 1811 step =1 cfoutput #recordID#br /cfoutput cfset rmtotal=1 cfset EBRMTOTAL=1 cfquery Name=NameInfo datasource=lifew05 select * From tblNam where Nam_ID=#recordid# /cfquery CFIF NameInfo.Nam_HOTROOMMATEFNAME1 IS NOT '' CFQUERY DATASOURCE=DB

RE: reseting querys values in a loop

-Talk Subject: RE: reseting querys values in a loop Code cfloop index=recordid From = 46 To = 1811 step =1 cfoutput #recordID#br /cfoutput cfset rmtotal=1 cfset EBRMTOTAL=1 cfquery Name=NameInfo datasource=lifew05 select * From tblNam where Nam_ID=#recordid# /cfquery CFIF

RE: reseting querys values in a loop

Ok This is what I did cfif Getroommate1.Nam_BadgeName eq NameInfo.Nam_HOTROOMMATEFNAME1 and Getroommate1.Nam_Lname eq NameInfo.Nam_HOTROOMMATELNAME1 and GetRoommate1.Nam_EmployeeCode eq NameInfo.Nam_HOTROOMMATETCODE1 cfset RM1BN = GetRoommate1.Nam_BadgeName cfset RM1LN = GetRoommate1.Nam_LName

RE: reseting querys values in a loop

be able to help you better. Mike -Original Message- From: Jim Louis [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 10:10 AM To: CF-Talk Subject: RE: reseting querys values in a loop Ok This is what I did cfif Getroommate1.Nam_BadgeName eq NameInfo.Nam_HOTROOMMATEFNAME1