|
|
|
|
|
| | |
| |
Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
