<% club=request.querystring("club") offer=request.querystring("offer") fn=request.querystring("fn") sn=request.querystring("sn") am=request.querystring("am") dd=request.querystring("dd") mm=request.querystring("mm") yy=request.querystring("yy") sal=request.querystring("sal") pci=request.querystring("pci") pco=request.querystring("pco") tc=request.querystring("tc") ea=request.querystring("ea") gscase=request.querystring("gscase") benefits=request.querystring("benefits") campaign=request.querystring("campaign") campaign_id=request.querystring("campaign_id") am=request.form("e_mail") if club=2 then clubcss="gardeners" end if if club=3 then clubcss="homeowners" end if if club=7 then clubcss="travellers" end if sql="" sql=sql &"select * from tblRegClub" & " " sql=sql &"inner join tblRegBenefits on RegBenefitsClub = RegClubID" & " " sql=sql &"where RegClubID="& club&"" & " " set rs = adodbConn.Execute(sql) while not rs.EOF rs_RegClubName=rs("RegClubName") rs_RegClubBanner=rs("RegClubBanner") rs_RegClubUpperText=rs("RegClubUpperText") rs_RegClubTakenText=rs("RegClubTakenText") rs_RegClubLowerText=rs("RegClubLowerText") rs_RegClubCSSPath=rs("RegClubCSSPath") rs_RegClubNarrowCSSPath=rs("RegClubNarrowCSSPath") rs_RegBenefitsPostItPath=rs("RegBenefitsPostItPath") %> <% border=0 strReg08="" strReg08=strReg08 & "" strReg08=strReg08 & "" strReg08=strReg08 & "Registration Form" strReg08=strReg08 & " " strReg08=strReg08 & " " strReg08=strReg08 & "
" strReg08=strReg08 & "" strReg08=strReg08 & "
" strReg08=strReg08 & "
" strReg08=strReg08 & "
" if campaign <> "" then sql="" sql=sql &"select * from tblRegCampaign" & " " sql=sql &"where RegCampaignPsum='"&campaign_id&"' " & " " set rst = adodbConn.Execute(sql) rs_RegCampaignBanner=rst("RegCampaignBanner") rs_RegCampaignUpperText=rst("RegCampaignUpperText") rs_RegCampaignSource=rst("RegCampaignSource") rs_RegCampaignSourceFile=rst("RegCampaignSourceFile") rs_RegCampaignAction=rst("RegCampaignAction") strReg08=strReg08 & "" else strReg08=strReg08&"" strReg08=strReg08&"" sql="" sql=sql &"select * from tblRegImage" & " " sql=sql &"where RegImageClub="&club&" " & " " set rst = adodbConn.Execute(sql) strReg08=strReg08&"
" strReg08=strReg08&"" i=1 Do until rst.EOF rs_RegImageClub=rst("RegImageClub") rs_RegImagePath=rst("RegImagePath") rs_RegImageDesc=rst("RegImageDesc") cellstring="" cellString=cellString&"" if not i mod 2=0 then strReg08=strReg08&""&cellString&"" else strReg08=strReg08&""&cellString&"" strReg08=strReg08&"" end if i=i+1 rst.movenext loop strReg08=strReg08&"
" cellString=cellString&"" cellString=cellString&"" cellString=cellString&"" cellString=cellString&"" cellString=cellString&"
" cellString=cellString&"
" cellString=cellString&"
" end if if benefits = "yes" then strReg08=strReg08 & "
" if club = 2 then strReg08=strReg08 & strBenefits2 end if if club = 3 then strReg08=strReg08 & strBenefits3 end if if club = 7 then strReg08=strReg08 & strBenefits7 end if if club = 8 then strReg08=strReg08 & strBenefits8 end if strReg08=strReg08 & "
" end if strReg08=strReg08 & "
" strReg08=strReg08 & "
" strReg08=strReg08 & "
" strReg08=strReg08 & "
" strReg08=strReg08 & "
" if ea <> "taken" then if campaign <> "" then strReg08=strReg08 & ""&rs_RegCampaignUpperText&"" else strReg08=strReg08 & ""&rs_RegClubUpperText&"" end if else strReg08=strReg08 & ""&rs_RegClubTakenText&"" end if strReg08=strReg08 & "
" strReg08=strReg08 & "
" strReg08=strReg08 & "
" strReg08=strReg08 & " " strReg08=strReg08 & " " strReg08=strReg08 & " " if tc<>"rq" then strReg08=strReg08 & " " else strReg08=strReg08 & " " end if strReg08=strReg08 & " " strReg08=strReg08 & " " strReg08=strReg08 & " " strReg08=strReg08 & " " strReg08=strReg08 & " " strReg08=strReg08 & " " strReg08=strReg08 & " " strReg08=strReg08 & " " strReg08=strReg08 & " " strReg08=strReg08 & " " strReg08=strReg08 & " " strReg08=strReg08 & " " strReg08=strReg08 & " " strReg08=strReg08 & " " strReg08=strReg08 & " " strReg08=strReg08 & " " strReg08=strReg08 & " " strReg08=strReg08 & " " strReg08=strReg08 & " " if tc<>"rq" then strReg08=strReg08 & " " else strReg08=strReg08 & " " end if strReg08=strReg08 & " " strReg08=strReg08 & " " strReg08=strReg08 & " " strReg08=strReg08 & " " strReg08=strReg08 & " " strReg08=strReg08 & " " strReg08=strReg08 & " " strReg08=strReg08 & " " strReg08=strReg08 & " " strReg08=strReg08 & " " strReg08=strReg08 & " " strReg08=strReg08 & " " strReg08=strReg08 & "
" strReg08=strReg08 & "" strReg08=strReg08 & " " sql = "" sql = sql &" SELECT * FROM tblSalutation " & " " set rst = adodbConn.Execute(sql) strReg08 = strReg08 & "" strReg08=strReg08 & " " sql = "" sql = sql &" SELECT * FROM tblSalutation " & " " set rst = adodbConn.Execute(sql) strReg08 = strReg08 & "" strReg08=strReg08 & "
" strReg08=strReg08 & "" strReg08=strReg08 & " " strReg08=strReg08 &"" strReg08=strReg08 & "" strReg08=strReg08 & "
" strReg08=strReg08 & "" strReg08=strReg08 & " " strReg08=strReg08 & "" strReg08=strReg08 & "" strReg08=strReg08 & "
" strReg08=strReg08 & "" strReg08=strReg08 & " " strReg08=strReg08 & " " & vbCrLf strReg08=strReg08 & " " strReg08=strReg08 & " " strReg08=strReg08 & "
" strReg08=strReg08 & "" strReg08=strReg08 & " " strReg08=strReg08 & " " strReg08=strReg08 & " " strReg08=strReg08 & "
" strReg08=strReg08 & "" strReg08=strReg08 & " " strReg08=strReg08 & createCalendar strReg08=strReg08 & " " strReg08=strReg08 & "  /" strReg08=strReg08 & "  /" strReg08=strReg08 & " " strReg08=strReg08 & "
" strReg08=strReg08 & "" strReg08=strReg08 & " " strReg08=strReg08 & " " strReg08=strReg08 & " " strReg08=strReg08 & "  " strReg08=strReg08 & " " strReg08=strReg08 & " " strReg08=strReg08 & "
" strReg08=strReg08 & " Click here to read terms & conditions." strReg08=strReg08 & " " if tc<>"rq" then if ea<>"taken" then strReg08=strReg08 & "" else strReg08=strReg08 & "" end if else if ea="taken" then strReg08=strReg08 & "" else strReg08=strReg08 & "" end if end if strReg08=strReg08 & "" strReg08=strReg08 & "
" strReg08=strReg08 & "" strReg08=strReg08 & "
" strReg08=strReg08 & "
" strReg08=strReg08 & "
" strReg08=strReg08 & ""&rs_RegClubLowerText&"" strReg08=strReg08 & "
" strReg08=strReg08 & "
" strReg08=strReg08 & "
" strReg08=strReg08 & " " strReg08=strReg08 & " " strReg08=strReg08 & " " rs.MoveNext wend response.write strReg08 %>