 |
 |
|
|
 |
|
|
<%
var oConn;
var oRs;
var recset;
var curDir;
var Index;
// Create ADO Connection Component to connect
// with sample database
oConn = Server.CreateObject("ADODB.Connection");
//****---- Path on Pc----*****
//***--- Map fordsburg database to physical path ----****
// curDir = Server.MapPath("fordsburg.mdb");
// oConn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+curDir);
//****---- Path on FTP Server----*****
oConn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:/Inetpub/wwwroot/fordsburg.com/database/fordsburg.mdb");
// Create ADO Recordset Component
oRs = Server.CreateObject("ADODB.Recordset");
oRs.ActiveConnection = oConn;
// Get recordset
var status="Yes";
if(Request.QueryString("id") > 0){
oRs.Source = "SELECT article_comments.name, article_comments.comments FROM article_comments where article_id="+Request.QueryString("id")+" and article_comments.status='"+status+"'";
//oRs.CursorType = adOpenStatic;
oRs.Open();
while (!oRs.eof) { %>
| Name: |
<% = oRs(0)%> |
| Comments: |
<% = oRs(1)%> |
| |
<%
oRs.MoveNext();
}
oRs.Close();
}
%>
|
|
|
This site is the property of Fordsburg.com . 2007. |
|
|
|