%@ Language=JScript %> <% Response.Expires = 0; Response.CacheControl = "private" Response.ContentType="text/html" Response.Charset="Big-5" var imageID=Request.QueryString("imageID"); var dbConn = InitDBConnection(); var updateStr = "Select * from menstandings where imageid="+imageID+" order by seq asc"; var dbComm = InitDBCommand( dbConn, updateStr ); var recSet = GetRecordSet( dbComm ); var updateStr = "Select *, datename(d,updatedate)+' '+datename(mm,updatedate)+' '+datename(yyyy,updatedate) lastupdate from menstandingsdesc where imageid="+imageID; var dbComm = InitDBCommand( dbConn, updateStr ); var recSet2 = GetRecordSet( dbComm ); var description=""; var subdescription=""; var lastupdate=""; var col1=""; var col2=""; var col3=""; var col4=""; var col5=""; var col6=""; var col7=""; var col8=""; var col9=""; if (!recSet2.EOF){ description=of_trim(recSet2("description")); subdescription=recSet2("subdescription"); lastupdate=recSet2("lastupdate"); col1=of_trim(recSet2("col1Heading")); if (col1=="null") col1=""; col2=of_trim(recSet2("col2Heading")); if (col2=="null") col2=""; col3=of_trim(recSet2("col3Heading")); if (col3=="null") col3=""; col4=of_trim(recSet2("col4Heading")); if (col4=="null") col4=""; col5=of_trim(recSet2("col5Heading")); if (col5=="null") col5=""; col6=of_trim(recSet2("col6Heading")); if (col6=="null") col6=""; col7=of_trim(recSet2("col7Heading")); if (col7=="null") col7=""; col8=of_trim(recSet2("col8Heading")); if (col8=="null") col8=""; col9=of_trim(recSet2("col9Heading")); if (col9=="null") col9=""; } %>