cheers...
i will upgrade when i hav resolved this issue...
i have done the tutorial understood it and got the following page to read the db:
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="common.asp" -->
<html>
<head>
<title>testCookieFilter</title>
</head>
<body bgcolor="white" text="black">
<%
'Dimension variables
Dim rsMembers 'Holds the recordset for the records in the database
'Create an ADO recordset object
Set rsMembers = Server.CreateObject("ADODB.Recordset")
'Initialise the strSQL variable with an SQL statement to query the database
strSQL = "SELECT tblAuthor.Username, tblAuthor.User_code FROM tblAuthor;"
'Open the recordset with the SQL query
rsMembers.Open strSQL, adoCon
'Loop through the recordset
Do While not rsMembers.EOF
'Write the HTML to display the current record in the recordset
Response.Write ("<br>")
Response.Write (rsMembers("Username"))
Response.Write ("<br>")
Response.Write (rsMembers("User_code"))
Response.Write ("<br>")
'Move to the next record in the recordset
rsMembers.MoveNext
Loop
'Reset server objects
rsMembers.Close
Set rsMembers = Nothing
Set adoCon = Nothing
%>
</body>
</html>
so from here... how would i get filter the rs with the user_code...?
any help gratefully accepted...ta...
Topic Options
Post Options
Thanks(0)
