<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" NAME="GetRoommate1">
SELECT *
FROM tblNam
WHERE Nam_BadgeName = '#NameInfo.Nam_HOTROOMMATEFNAME1#' and
Nam_Lname = '#NameInfo.Nam_HOTROOMMATELNAME1#' and Nam_EmployeeCode =
'#NameInfo.Nam_HOTROOMMATETCODE1#'
</CFQUERY>
<CFIF GETROOMMATE1.RECORDCOUNT IS 0>
<CFELSE>
<CFQUERY DATASOURCE="lifew05" NAME="GetRoommate1a">
SELECT *
FROM tblHotel
WHERE HotUser_ID = #Getroommate1.Nam_ID#
</CFQUERY>
<CFSET RMTOTAL= #RMTOTAL# + #GETROOMMATE1.RECORDCOUNT#>
</CFIF>
</CFIF>
The other seven are similar to the one above.
--
Jim Louis
Best Meetings, Inc.
Phone: 952-858-8875
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
