We can use SQL to create the query so that we can specify that only the selected records and fields can be viewed. We want to show only records that begin with An in the “Companyname” fieldof the “Customers” table: Display “Companyname” records greater than E How to display only records greater than E in the Companyname field of the Customers table. ` Only display customers in Spain < https://www.runoob.com/try/showasp.php?filename=demo_query_3 >`__How to display only Spanish customers in the “Customers” table. Allow users to choose filtering criteria Let users select customers according to their country
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. Show selected data ¶
<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
WHERE CompanyName LIKE 'A%'"
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