|
|
|
Here is the results of your query.
| State | City | Store Name |
|---|
<%
dim objConn
dim objRec
dim strConn
StoreSQL = "Select * from stores order by state, city, stor_name;"
Set objConn = Server.CreateObject("ADODB.Connection")
Set objRec = Server.CreateObject("ADODB.Recordset")
objConn.Open strConnect
%>
<%
objRec.Open storeSQL, objConn
%>
<%
While Not objRec.EOF
Response.write ("")
Response.write "| " &"" & objRec("state") & " | "&"" & objRec("city")&" | "&""& objRec("stor_name")&" | "&""
Response.write (" ")
objRec.MoveNext
Wend
objRec.Close
objConn.Close
set objRec = Nothing
%>
|
