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]
