Thankyou i know how to do that bit, that is they only part i know. when i have a query done on my database will i use this code to bring up the clients who have not paid after30 days.
I
This is code below was another exercise i had to do.
<%Response.Buffer=True%>
<html>
<head>
<title>Claire Harkin's ASP Exercises</title>
</head>
<body>
<b>Claire Harkin's Phone Book</b><p>
<%
Dim rs, conn
set conn=Server.CreateObject("ADODB.connection")
set rs=Server.CreateObject("ADODB.recordset")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("phonebook.mdb"))
fln=request("find_Last_Name")
sqlstr="select *from entries where Last_Name='"& fln &"'"
rs.Open sqlstr,conn
Response.Write"<table border><tr>"
while not rs.EOF
Response.Write"<td>"& rs("ID")&"</td>"
Response.Write"<td>"& rs("Last_Name")&"</td>"
Response.Write"<td>"& rs("First_Name")& "</td>"
Response.Write"<td>"& rs("Tel_Number")&"</td>"
Response.Write"</tr>"
rs.MoveNext
wend
Response.Write"</table>"
rs.Close
set rs=Nothing
%>
i am going to use code like that to bring up my table on the webpage. would that be right.
Just not sure how i get clients details up if they are overdue to be displayed on the webpage.
Claire
A good place to start would be with a brief tutorial. ASP likes to use "ADO" to connect to databases. This tutorial is good if a bit basic.
here is an example of an asp script that opens a db table and writes a webpage:
- <%
-
dim conn, rs
-
set conn=Server.CreateObject("ADODB.Connection")
-
conn.Provider="Microsoft.Jet.OLEDB.4.0"
-
conn.Open "c:/inetpub/myDataBase.mdb"
-
set rs=Server.CreateObject("ADODB.recordset")
-
rs.Open "SELECT * FROM myTable", conn
-
response.write "<table border=1><tr>" & vbNewLine
-
do until rs.eof
-
for each x in rs.fields
-
response.write "<td>" & rs(x) & "</td>" & vbNewLine
-
-
next
-
-
rs.movenext
-
response.write "</tr><tr>"
-
loop
-
response.write "</table>"
-
%>
Jared