|
utilizzazione di un db
inserimento: parte 1 - form
<![CDATA[
<form action="inserisci.asp" method="post">
Name: <input type="text" name="Name">
City: <input type="text" name="City">
State:<input type="text" name="State">
Country:<input type="text" name="Country">
<input type="submit" value="Submit">
<input type="button" value="Clear"></form>
]]>
inserimento: parte 2 - sql
<![CDATA[
' controllo delle variabili, ove obbligatorie
If IsEmpty(request.form("Name")) or request.form("Name")="" then
response.write "<center><b>You must enter a name."
response.write "<form>"
response.write "<input type='button' value='Retry' onclick=history.back()>"
response.write "</form>"
response.end
Else
Name = request.form("Name")
End If
If IsEmpty(request.form("City")) or request.form("City")="" then
response.write "<center>You must enter a City."
response.write "<form>"
response.write "<input type='button' value='Retry' onclick=history.back()>"
response.write "</form>"
response.endElse
City = request.form("City")
End If
' variabili NON obbligatorie
State = request.form("State")
' costruzione sql INSERT
SQLstmt = "INSERT INTO Sample (Name,City,State,Country)"
SQLstmt = SQLstmt & " VALUES (" SQLstmt = SQLstmt & "'" & Name & "',"
SQLstmt = SQLstmt & "'" & City & "',"SQLstmt = SQLstmt & "'" & State & "',"
SQLstmt = SQLstmt & "'" & Country & "'"SQLstmt = SQLstmt & ")"
' esecuzione
set conn = server.createobject("adodb.connection")
conn.open "kathi"
Set RS = conn.execute(SQLstmt)
Conn.Close
]]>
è bene verificare gli errori
|