salman.pirani Posted October 3, 2012 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 Link to comment Share on other sites More sharing options...
justsomeguy Posted October 3, 2012 Share Posted October 3, 2012 Compare it with the working code, you're not actually sending a query to the database. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now