<% 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+1 INFO1.MOVENEXT LOOP Conn.Close Set Conn = Nothing %>
                 
             
ROW   ID3 BOLD/
DEL
  MOVE
DOWN
MOVE
UP
POS   CUR
SET
 
TITLE
PRACTICE PLAYED SPACE MEM
ALL
MEM
MUSIC
MEM
VOX
<%=POS%>
 





TOP
<%=VAR5aa%>
<%=VAR2A%>  

BOTTOM