Jump to content

fetch query


salman.pirani
 Share

Recommended Posts

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...