<%if sid<>empty then%>
<% Set conn = Server.CreateObject("ADODB.Connection")
DBPath = Server.MapPath("/database/fate.mdb")
conn.Open "driver={Driver do Microsoft Access (*.mdb)};dbq=" & DBPath
Set rs2 = Server.CreateObject("ADODB.Recordset")
rs2.Open "select * from dream where s2 like '%" & sid & "%' ", conn,1,3
%>
<%if rs2.recordcount=1 then%>
搜尋結果:<%=rs2("S2")%>
<%=rs2("S3")%>
<%elseif rs2.recordcount>=2 then%>
<%do until rs2.EOF%>
搜尋結果:<%=rs2("S2")%>
<%=rs2("S3")%>
<%rs2.MoveNext
loop %>
<%elseif rs2.recordcount=0 then%>
很抱歉,目前搜尋不到你要的解夢名稱!!
<%end if%>
<%end if%>
|