Script ASP - Database: OrderBy - Morpheusweb.it - Webmaster resources: programming, asp script, using asp, file asp, asp, asp post, database asp, asp login, vb asp, asp access, asp download, asp script, formmail, area riservata, paginazione, scripts asp, mailform, asp script download

ABOUT >
WORKS >
CONTACT ME >
>

Home Page
> Script ASP
> Script ASP Database
> OrderBy

OrderBy

To order the tuples of a database table.



					
					<form action="ricerca.asp"> 

					<input type="text" name="testo"> 

					<br/> 

					<select name="order"> 

					<option>Data 

					<option>ID 

					<option>Nome 

					</select> 

					<input type="submit"> 

					</form> 

					<% 

					' ... apri db 

					SQL = "SELECT * FROM articoli WHERE " &_ 

					" testo LIKE '%" & request("testo") &"%' " &_ 

					" ORDER BY " & request("order") 

					' ... shows results 

					%>