<%
If BOOK_CODE<>"" then
Select Case (BOOK_CODE)
Case "TP0005"
code2="ADVANCED2"
Case "TP0004"
code2="ADVANCED1"
Case "TP0003"
code2="INTERMEDIATE2"
Case "TP0002"
code2="INTERMEDIATE1"
Case "TP0009"
code2="BASIC"
Case "TP0008"
code2="PRIMARY"
Case "TP0025"
code2="PRIMARY"
Case Else :
code2="FLUENT"
End Select
Else
code2="FLUENT"
End If
Response.write code2
%>
<%
qq = "SELECT * FROM T_TB_TEXTBOOK where BOOK_CODE='" & BOOK_CODE &"'"
'Response.write qq
Set book = Server.CreateObject("ADODB.Recordset")
book.Open qq, dbConnect, 1
BOOK_MON = book("BOOK_MON")
BOOK_TUE = book("BOOK_TUE")
BOOK_WED = book("BOOK_WED")
BOOK_THU = book("BOOK_THU")
BOOK_FRI = book("BOOK_FRI")
%>