<%
Set rsMenu = adoConn.Execute("SELECT ecat_id, ecat_name, ecat_pgn FROM eCats WHERE ecat_live = '1' ORDER BY ecat_do ASC")
Do While NOT rsMenu.EOF
%>
<%
IF rsFind.Fields("k_pic1") <> "" THEN
IF rsFind.Fields("k_pic1alt") <> "" THEN
myalt = Replace(rsFind.Fields("k_pic1alt"),"'","")
ELSE
myalt = clientNm
END IF
picstring = ""
IF rsFind.Fields("k_link1") <> "" THEN
picstring = "" & picstring & ""
END IF
Response.Write vbcrlf & "
"
Response.Write vbcrlf & "
"
Response.Write vbcrlf & "
" & picstring & "
"
' picture 2
IF rsFind.Fields("k_pic2") <> "" THEN
IF rsFind.Fields("k_pic2alt") <> "" THEN
myalt = Replace(rsFind.Fields("k_pic2alt"),"'","")
ELSE
myalt = clientNm
END IF
picstring = ""
IF rsFind.Fields("k_link2") <> "" THEN
picstring = "" & picstring & ""
END IF
Response.Write vbcrlf & "
" & picstring & "
"
END IF
' picture 3
IF rsFind.Fields("k_pic3") <> "" THEN
IF rsFind.Fields("k_pic3alt") <> "" THEN
myalt = Replace(rsFind.Fields("k_pic3alt"),"'","")
ELSE
myalt = clientNm
END IF
picstring = ""
IF rsFind.Fields("k_link3") <> "" THEN
picstring = "" & picstring & ""
END IF
Response.Write vbcrlf & "
" & picstring & "
"
END IF
Response.Write vbcrlf & "
"
Response.Write vbcrlf & "
"
END IF
rsFind.Close
Set rsFind = Nothing
Set rsFind = adoConn.Execute("SELECT * FROM KeyPage WHERE k_ref = '10'")
' picture 1
IF rsFind.Fields("k_pic1") <> "" THEN
IF rsFind.Fields("k_pic1alt") <> "" THEN
myalt = Replace(rsFind.Fields("k_pic1alt"),"'","")
ELSE
myalt = clientNm
END IF
picstring = ""
IF rsFind.Fields("k_link1") <> "" THEN
picstring = "" & picstring & ""
END IF
Response.Write vbcrlf & "
"
Response.Write vbcrlf & "
"
Response.Write vbcrlf & "
" & picstring & "
"
' picture 2
IF rsFind.Fields("k_pic2") <> "" THEN
IF rsFind.Fields("k_pic2alt") <> "" THEN
myalt = Replace(rsFind.Fields("k_pic2alt"),"'","")
ELSE
myalt = clientNm
END IF
picstring = ""
IF rsFind.Fields("k_link2") <> "" THEN
picstring = "" & picstring & ""
END IF
Response.Write vbcrlf & "
" & picstring & "
"
END IF
' picture 3
IF rsFind.Fields("k_pic3") <> "" THEN
IF rsFind.Fields("k_pic3alt") <> "" THEN
myalt = Replace(rsFind.Fields("k_pic3alt"),"'","")
ELSE
myalt = clientNm
END IF
picstring = ""
IF rsFind.Fields("k_link3") <> "" THEN
picstring = "" & picstring & ""
END IF
Response.Write vbcrlf & "
" & picstring & "
"
END IF
Response.Write vbcrlf & "
"
Response.Write vbcrlf & "
"
END IF
IF rsFind.Fields("k_title") <> "" THEN
Response.Write vbcrlf & "