<% dim objConn dim objRec authorsql = "SELECT * FROM authors ORDER BY state;" 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

Author's Names - Ordered by State

<% objRec.open authorsql,objConn newstate = "" %>

Author's Search Results

<% while not objRec.EOF if newstate <> objRec("state") then newstate = objRec("state")%>

<% response.write "STATE " &" "& objRec("state")%>


<% else if newstate = objRec("state") then response.write objRec("au_lname") & "," & objRec("au_fname")& " " & objRec("city") &"
" objRec.MoveNext end if end if wend set objRec= Nothing %>
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