We can use SQL’s We hope to offer When the user presses the confirm button, the form is sent to a file named “demo_add.asp”. The file “demo_add.asp” contains files that can be directed to Before you use the If the table contains a primary key, make sure that the value added to the primary key field is unique and not empty (otherwise If the table contains an auto-numbered field, do not use the In the MS Access database, if you set the Note: not all databases support zero-length strings, so errors may occur when adding records with blank fields. Therefore, it is important to check the data types supported by the database you are using.
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. INSERT INTO command to add records to the table in thedatabase.Add records to tables in the database ¶
Northwind in the database Customers table to add a new record. We start by creating a form that contains the input fields from which we need to collect data:<html>
<body>
<form method="post" action="demo_add.asp">
<table>
<tr>
<td>CustomerID:td>
<td><input name="custid">td>
tr><tr>
<td>Company Name:td>
<td><input name="compname">td>
tr><tr>
<td>Contact Name:td>
<td><input name="contname">td>
tr><tr>
<td>Address:td>
<td><input name="address">td>
tr><tr>
<td>City:td>
<td><input name="city">td>
tr><tr>
<td>Postal Code:td>
<td><input name="postcode">td>
tr><tr>
<td>Country:td>
<td><input name="country">td>
tr>
table>
<br><br>
<input type="submit" value="Add New">
<input type="reset" value="Cancel">
form>
body>
html>
Customers the table adds the code for a new record: <html>
<body>
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"
sql="INSERT INTO customers (customerID,companyname,"
sql=sql & "contactname,address,city,postalcode,country)"
sql=sql & " VALUES "
sql=sql & "('" & Request.Form("custid") & "',"
sql=sql & "'" & Request.Form("compname") & "',"
sql=sql & "'" & Request.Form("contname") & "',"
sql=sql & "'" & Request.Form("address") & "',"
sql=sql & "'" & Request.Form("city") & "',"
sql=sql & "'" & Request.Form("postcode") & "',"
sql=sql & "'" & Request.Form("country") & "')"
on error resume next
conn.Execute sql,recaffected
if err<>0 then
Response.Write("No update permissions!")
else
Response.Write("
" & recaffected & " record added")
end if
conn.close
%>
body>
html>
Important matters ¶
INSERT command when using the command, please note the following:
provider this record will not be appended, or an error will occur) INSERT . This field is involved in the command (the value of this field is determinedby the provider responsible) About No data Field ¶
AllowZeroLength property is set to “Yes”, and you can enter zero-length strings (“”) in text, hyperlinks, and memo fields.
Principles, Technologies, and Methods of Geographic Information Systems
102