salman.pirani 0 Posted October 3, 2012 Report Share Posted October 3, 2012 i have tried this code previously now am trying it on another datbase but now its not workingplease confirm the error am doing <%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>Untitled Document</title></head><body><%set conn=Server.CreateObject("ADODB.Connection")conn.Provider="Microsoft.Jet.OLEDB.4.0"conn.Open "c:/webdata/sxsheet.mdb"set rs = Server.CreateObject("ADODB.recordset")cid=Request.Form("pn")sql="SELECT * FROM info WHERE position_num=" & cid & "" %><table border="1" width="100%"> <tr class="b"><td align="center" valign="middle">Position #</td><td align="center" valign="middle">Status</td><td align="center" valign="middle">Department</td><td align="center" valign="middle">Division</td> <td align="center" valign="middle">Ad Date</td><td align="center" valign="middle">Deadline</td><td align="center" valign="middle">Cv to Dep head</td><td align="center" valign="middle">Interview Date</td> <td align="center" valign="middle">Final candidiate</td><td align="center" valign="middle">Comment</td><td align="center" valign="middle">Forms</td><td align="center" valign="middle">Medical sent</td><td align="center" valign="middle">Medical received</td><td align="center" valign="middle">Medical received comments</td><td align="center" valign="middle">Document Verification</td><td align="center" valign="middle">Document Verification comments</td><td align="center" valign="middle">PS verification</td><td align="center" valign="middle">PS verification comments</td><td align="center" valign="middle">TD card request</td><td align="center" valign="middle">TD card request comments</td><td align="center" valign="middle">FLU </td><td align="center" valign="middle">FLU comments </td><td align="center" valign="middle">doc recved</td> <td align="center" valign="middle">doc recved comments</td> </tr> <%do until rs.EOF%> <tr> <%for each x in rs.Fields%> <td><%Response.Write(x.value)%></td> <%next rs.MoveNext%> </tr> <%loop rs.close conn.close %></table></body></html> thanks Quote Link to post Share on other sites
justsomeguy 1,135 Posted October 3, 2012 Report Share Posted October 3, 2012 Compare it with the working code, you're not actually sending a query to the database. Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.