<CFIF Query.DATE EQ #Query2.DATE1#>
<CFSET A1=1>
<CFLOOP INDEX="Date1" FROM="#Starting#" TO="#Ending#">
<!--- No Roommates --->
<cfif (EVALUATE("RM1DAY" &A1) is '0') and (EVALUATE("RM2DAY" &A1) is '0') and (EVALUATE("RM3DAY" &A1) is '0')>
<CFQUERY DATASOURCE="#db#" NAME="Update">
UPDATE table
SET Day#a1# = 1
WHERE ID = #query3.New_ID#
</CFQUERY>
<CFSET NEW_TOTAL = EVALUATE("query1.DAY" &A1) + 1>
<CFQUERY DATASOURCE="#db#" NAME="UpdateHotel">
UPDATE table2
SET day#a1# = #new_total#
WHERE ID = #query.H_ID#
</CFQUERY>
</cfif>
More code
<CFSET A1=A1+1>
</cfloop>
Is there any what to get rid of all of these evaluate tags.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
