Id have to see the code in its entirety. What I was hinting towards was the
fact that you can just use some temp variables that get set and reset on
each iteration of the loop...
Also... in your cfsets, you only need #s when you have "".
Email me off list, ill 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 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>
<cfset RM1TC = GetRoommate1.Nam_EmployeeCode>
<cfset RM1AD = GetRoommate1.Nam_HOTArrivalDate>
<cfset RM1DD = GetRoommate1.NAM_HOTDEPARTUREDATE>
<cfset RM1ID = GetRoommate1.Nam_ID>
<cfset RM1HOTDAY1=#GETROOMMATE1a.HOT_DAY1#>
<cfset RM1HOTDAY2=#GETROOMMATE1a.HOT_DAY2#>
<cfset RM1HOTDAY3=#GETROOMMATE1a.HOT_DAY3#>
<cfset RM1HOTDAY4=#GETROOMMATE1a.HOT_DAY4#>
<cfset RM1HOTDAY5=#GETROOMMATE1a.HOT_DAY5#>
<cfset RM1HOTDAY6=#GETROOMMATE1a.HOT_DAY6#>
<cfset RM1HOTDAY7=#GETROOMMATE1a.HOT_DAY7#>
<cfset RM1HOTDAY8=#GETROOMMATE1a.HOT_DAY8#>
<cfset RM1HOTDAY9=#GETROOMMATE1a.HOT_DAY9#>
<cfset RM1HOTDAY10=#GETROOMMATE1a.HOT_DAY10#>
<cfset RM1HOTDAY11=#GETROOMMATE1a.HOT_DAY11#>
<cfset RM1HOTDAY12=#GETROOMMATE1a.HOT_DAY12#>
<cfset RM1HOTDAY13=#GETROOMMATE1a.HOT_DAY13#>
<cfset RM1HOTDAY14=#GETROOMMATE1a.HOT_DAY14#>
<cfset RM1HOTDAY15=#GETROOMMATE1a.HOT_DAY15#>
<cfset RM1HOTDAY16=#GETROOMMATE1a.HOT_DAY16#>
<cfset RM1HOTDAY17=#GETROOMMATE1a.HOT_DAY17#>
<cfset RM1HOTDAY18=#GETROOMMATE1a.HOT_DAY18#>
<cfset RM1HOTDAY19=#GETROOMMATE1a.HOT_DAY19#>
<cfset RM1HOTDAY20=#GETROOMMATE1a.HOT_DAY20#>
<cfelse>
<cfset RM1BN = ''>
<cfset RM1LN = ''>
<cfset RM1TC = ''>
<cfset RM1AD = ''>
<cfset RM1DD = ''>
<cfset RM1ID = ''>
<cfset RM1HOTDAY1='0'>
<cfset RM1HOTDAY2='0'>
<cfset RM1HOTDAY3='0'>
<cfset RM1HOTDAY4='0'>
<cfset RM1HOTDAY5='0'>
<cfset RM1HOTDAY6='0'>
<cfset RM1HOTDAY7='0'>
<cfset RM1HOTDAY8='0'>
<cfset RM1HOTDAY9='0'>
<cfset RM1HOTDAY10='0'>
<cfset RM1HOTDAY11='0'>
<cfset RM1HOTDAY12='0'>
<cfset RM1HOTDAY13='0'>
<cfset RM1HOTDAY14='0'>
<cfset RM1HOTDAY15='0'>
<cfset RM1HOTDAY16='0'>
<cfset RM1HOTDAY17='0'>
<cfset RM1HOTDAY18='0'>
<cfset RM1HOTDAY19='0'>
<cfset RM1HOTDAY20='0'>
</cfif>
Will that work or should I change it to the len thing.
--
Jim Louis
Best Meetings, Inc.
Phone: 952-858-8875
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
