<%
VARCURR = REQUEST("VARID2")
'RESPONSE.WRITE VARCURR
VARSORT = REQUEST("SORT")
'RESPONSE.WRITE (VARSORT)
IF VARSORT = 1 THEN
set info1 = conn.execute ("select * from songs1 where SETLIST_ = 'YES' AND CHRISTMAS_ = 'NO' ORDER BY ID3, TITLE_ ASC")
ELSEIF VARSORT = 2 THEN
set info1 = conn.execute ("select * from songs1 where SETLIST_ = 'YES' AND CHRISTMAS_ = 'NO' ORDER BY ID3, TITLE_ ASC ")
ELSEIF VARSORT = 3 THEN
set info1 = conn.execute ("select * from songs1 where SETLIST_ = 'YES' AND CHRISTMAS_ = 'NO' ORDER BY ID3, TITLE_ ASC ")
ELSEIF VARSORT = 4 THEN
set info1 = conn.execute ("select * from songs1 where SETLIST_ = 'YES' AND CHRISTMAS_ = 'NO' ORDER BY ID3, TITLE_ ASC ")
ELSEIF VARSORT = 5 THEN
set info1 = conn.execute ("select * from songs1 where SETLIST_ = 'YES' AND CHRISTMAS_ = 'NO' ORDER BY ID3, TITLE_ ASC ")
ELSE
set info1 = conn.execute ("select * from songs1 ORDER BY ID3, TITLE_ ASC ")
END IF
pos=1
DO WHILE NOT INFO1.EOF
VAR1 = INFO1.FIELDS.ITEM("ID")
VAR2 = INFO1.FIELDS.ITEM("TITLE3_")
IF Len(INFO1("TITLE3_")) > 40 THEN
VAR2B = InStr(VAR2,"-")
IF VAR2B >0 THEN
VAR2C = RIGHT(REPLACE(VAR2,"_"," "),4)
ELSE
VAR2C = ""
END IF
VAR2A = LEFT(REPLACE(VAR2,"_"," "),40)&VAR2C
ELSE
VAR2A = REPLACE(VAR2,"_"," ")
END IF
VAR3 = INFO1.FIELDS.ITEM("practiced_3")
VAR4 = INFO1.FIELDS.ITEM("played_3")
VAR5 = INFO1.FIELDS.ITEM("ID3")
VAR5aa = INFO1.FIELDS.ITEM("pos3_")
VAR888 = INFO1.FIELDS.ITEM("MEMMUSIC_")
VAR999 = INFO1.FIELDS.ITEM("MEMVOX_")
VAR010 = INFO1.FIELDS.ITEM("CURRENT_SET")
VARYT = INFO1.FIELDS.ITEM("YOUTUBE_")
VARYT2 = Mid(VARYT, 33,11)
VCLASS1 = INFO1.FIELDS.ITEM("CLASS_")
IF VCLASS1 = "A" THEN
VCLASS = "ALL"
ELSEIF VCLASS1 = "F" THEN
VCLASS = "FOLK"
ELSEIF VCLASS1 = "G" THEN
VCLASS = "FOLK"
ELSEIF VCLASS1 = "C" THEN
VCLASS = "FOLK"
ELSEIF VCLASS1 = "K" THEN
VCLASS = "FOLK"
ELSEIF VCLASS1 = "P" THEN
VCLASS = "FOLK"
ELSEIF VCLASS1 = "R" THEN
VCLASS = "FOLK"
ELSEIF VCLASS1 = "M" THEN
VCLASS = "FOLK"
END IF
IF VAR010 = 1 THEN
VAR010A = "X"
ELSE
VAR010A = ""
END IF
VAR777 = INFO1.FIELDS.ITEM("MEM3_")
IF VAR777 = 1 THEN
VAR777A = "X"
ELSE
VAR777A = ""
END IF
IF VAR888 = 1 THEN
VAR888A = "X"
ELSE
VAR888A = ""
END IF
IF VAR999 = 1 THEN
VAR999A = "X"
ELSE
VAR999A = ""
END IF
VAR6 = INFO1.FIELDS.ITEM("FIRST_")
IF VAR5 = 9999 THEN
VAR5 = ""
ELSE
VAR5 = VAR5
END IF
VAR7 = INFO1.FIELDS.ITEM("id3")
VAR8 = INFO1.FIELDS.ITEM("OPENSPACE_3")
'IF VAR8 = "X"
if var5 > 0 and var5 < 28 then
varclass = "auto-style100"
elseif var5 > 28 and var5 < 58 then
varclass = "auto-style110"
elseif var5 > 58 and var5 < 88 then
varclass = "auto-style120"
elseif var5 > 88 and var5 < 118 then
varclass = "auto-style130"
elseif var5 > 118 and var5 < 148 then
varclass = "auto-style140"
elseif var5 > 148 and var5 < 178 then
varclass = "auto-style150"
elseif var5 > 178 and var5 < 208 then
varclass = "auto-style160"
elseif var5 > 208 and var5 < 238 then
varclass = "auto-style170"
elseif var5 > 238 and var5 < 268 then
varclass = "auto-style180"
elseif var5 > 268 and var5 < 298 then
varclass = "auto-style190"
elseif var5 > 298 and var5 < 328 then
varclass = "auto-style200"
elseif var5 > 328 and var5 < 358 then
varclass = "auto-style221"
elseif var5 > 358 and var5 < 388 then
varclass = "auto-style220"
elseif var5 > 388 and var5 < 418 then
varclass = "auto-style230"
elseif var5 > 418 and var5 < 448 then
varclass = "auto-style240"
elseif var5 > 448 and var5 < 478 then
varclass = "auto-style250"
elseif var5 > 478 and var5 < 508 then
varclass = "auto-style260"
elseif var5 > 508 and var5 < 538 then
varclass = "auto-style270"
elseif var5 > 538 and var5 < 568 then
varclass = "auto-style280"
elseif var5 > 568 and var5 < 598 then
varclass = "auto-style290"
elseif var5 > 598 and var5 < 628 then
varclass = "auto-style300"
end if
SQL = " UPDATE SONGS1 SET POS3_ = "&POS&" WHERE ID = "&VAR1&""
CONN.EXECUTE (SQL)
%>
<%=POS%>
<%
pos=pos+1
INFO1.MOVENEXT
LOOP
Conn.Close
Set Conn = Nothing
%>