% STORY_ID = Request("id") Randomize FLYCAST = CStr(Session.SessionId) & CStr(Int((1000000) * Rnd)) ANCHOR_END = "" HUNDRED = false if Request("h") = "t" then HUNDRED = true ANCHOR_END = "&h=t" end if Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open CONNSTRING STORY_BODY = "" STORY_TELLER = "" STORY_HOMETOWN = "" if IsNumeric(STORY_ID) and STORY_ID > 0 then Set RS = Conn.Execute("select * from best_date where fk_id = " & STORY_ID) if RS.EOF then ErrorOut "Database error. Hit back and retry." end if STORY_BODY = RS("fk_story") STORY_TELLER = RS("fk_name") STORY_HOMETOWN = RS("fk_hometown") RS.Close Set RS = Nothing end if sql = "select fk_id, fk_name, fk_age, fk_story, fk_hometown from best_date " & _ "where fk_valid = 1 order by fk_entrydate desc" Set RS = Conn.Execute(sql) if RS.EOF then RS.Close Set RS = Nothing Conn.Close Set Conn = Nothing ErrorOut "Sorry, there is a database problem at this time. Please try again later" end if if HUNDRED = true then for cnt = 1 to 20 RS.MoveNext next end if %>
|
|
|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||