|
|
|
|
|
| | |
| |
Active Server Pages what is asp programming how to sample asp example code scripts software asp forum mail sessions applications global.asa CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
listing out in alphabetic order |
|
From: |
Brandon |
|
Date: |
9/10/2001 9:28:38 PM |
|
IP: |
128.250.6.245 |
I have the following code which get data from database and listing out in a table. What can I do to list it out in alphabetic order according to the Surname?
thank you.
<%DIM dataRS, SQLtext
Set dataRS = Server.CreateObjec("ADODB.Recordset")
SQLtext ="SELECT * from Researcher where FirstName = '" & Request.Form("search_name") & "' OR Surname = '" & Request.Form("search_name") & "' OR State ='" & Request.Form("search_state")& "'"
set dataRS = mydb.Execute(SQLtext)%>
<center><table border=1 cellpadding=6></center>
<tr>
<th>Title</th>
<th>Name</th>
</tr>
<% do while not dataRS.EOF
response.write"<td>" & dataRS("Title") & "</td>"
response.write"<td>" & dataRS("FirstName") & " " & dataRS("Surname") & "</td>"
dataRS.movenext
loop %> |
Follow Up - Re: listing out in alphabetic order - Elija 9/11/2001 3:54:33 AM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
