We can use SQL to specify how to sort the data in the recordset. We want to display the “Companyname” and “Contactname” fields in the “Customers” table and sort them by “Companyname” (please remember to usethe Sort records in descending order based on the specified field name How to sort data according to a specified field name Allow users to choose which column to sort based on Let the user choose which column to sort
In recent years, Geographic Information Systems (GIS) have undergone rapid development in both theoretical and practical dimensions. GIS has been widely applied for modeling and decision-making support across various fields such as urban management, regional planning, and environmental remediation, establishing geographic information as a vital component of the information era. The introduction of the “Digital Earth” concept has further accelerated the advancement of GIS, which serves as its technical foundation. Concurrently, scholars have been dedicated to theoretical research in areas like spatial cognition, spatial data uncertainty, and the formalization of spatial relationships. This reflects the dual nature of GIS as both an applied technology and an academic discipline, with the two aspects forming a mutually reinforcing cycle of progress. Sort the data ¶
.asp save for suffix):Example ¶
<html>
<body>
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Companyname, Contactname FROM
Customers ORDER BY CompanyName"
rs.Open sql, conn
%>
<table border="1" width="100%">
<tr>
<%for each x in rs.Fields
response.write("
" & x.name & "")
next%>
tr>
<%do until rs.EOF%>
<tr>
<%for each x in rs.Fields%>
<td><%Response.Write(x.value)%>td>
<%next
rs.MoveNext%>
tr>
<%loop
rs.close
conn.close%>
table>
body>
html>
More Instance ¶
Principles, Technologies, and Methods of Geographic Information Systems
102