Jump to content

fetch query


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 post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...