% Response.Buffer = False %> <% ' // FOR NEW BILLABONG SITE If Trim(Request.QueryString("regid")) = "NA" Then Response.Redirect "http://na.billabong.com" If Trim(Request.QueryString("regid")) = "ZA" Then Response.Redirect "http://www.billabong.com.au" If Trim(Request.QueryString("x")) = "1" Then Response.Cookies("regid") = Trim(Request.QueryString("regid")) End If %> <% Call start_oconn() %> <% SQL = "SELECT * FROM [home_page] WHERE id = '"& regid &"'" 'Response.Write(SQL &"
") Dim rs Set rs = oConn.Execute(SQL) If Not rs.EOF Then For n = 0 To 9 If Trim(rs("active_"& n)) <> "" And Trim(rs("image_"& n )) <> "" Then If Trim(rs("url_"& n )) <> "" Then output = output & "new Array("""& rs("url_"& n ) &""", """& rs("caption_"& n ) &""", """& rs("image_"& n ) &""", """& rs("active_"& n ) &""", """& rs("checked_"& n ) &""")," & vbNewLine Else output = output & "new Array("""", """& rs("caption_"& n ) &""", """& rs("image_"& n ) &""", """& rs("checked_"& n ) &""")," & vbNewLine End If i=i+1 End If Next End If %>