<% Dim objConn Dim objRec Dim strConn L7SQL = "SELECT * FROM authors order by au_lname, au_fname;" Set objConn = Server.CreateObject("ADODB.Connection") Set objRec = Server.CreateObject("ADODB.Recordset") objConn.Open strConnect %>
Search :     
Simple Query
Ordering Column Data
Author Loops
Stores Loops
Simple Dbase Query
Complex Dbase Query
Sales in Stores
Current Server Time
Master Detail
HotList Project
Publishers&Titles Hot List
PlayList Using File
PlayList Using DBase


Main Link Page

Authors Information

<% objRec.open L7SQL, objConn %>
<% while Not objRec.EOF response.write("") response.write("") response.write("") response.write("") response.write("") objRec.MoveNext Wend 'objRec.close set objRec = Nothing %>
Last NameFirst NamePhone Number
" & objRec ("au_lname") & "" & objRec ("au_fname") & "" & objRec ("phone") & "
C++ Tutorial ASP Tutorial Java Tutorial XML Tutorial
Visual Basic And More Javascript doc Flash Tutorial
DeVry University Bronx Community College My Library
Send comments to Support@rrasaq.com