RC — Wed, 26 Apr 2000 15:43:00 +0000

Hehe, I had almost forgotten how tedious ASP could be. The following Coldfusion lines accomplish the same task

<cfquery name="whatever" datasource="YourDB">
INSERT INTO YourTable (Name, Age)
VALUES ('#Form.txtName#', '#Form.txtAge#')
</cfquery>

Validation would be coded at the source like so:

Anyway, I used to use ASP and it is really good for some things, but I am glad my job moved me onto CF.

Peter J. Boettcher — Wed, 26 Apr 2000 12:50:00 +0000

JW,

First you should decide what platform you want to use/are familiar with. Some popular ones are ASP,PHP, and Cold Fusion. Then you should decide which db platform you want to use, Access, mySQL, SQL7, etc.

Once you've decided that, the routine for saving data from a form into a db is pretty universal. You simply take the values from the form and insert them into your db.

I'll give you a quick example using ASP & SQL7.

Here's our form.htm

<HTML>
<HEAD>
<TITLE>Form Example</TITLE>
</HEAD>
<BODY>
<form method=post action=save_info.asp>
<p>Name: <input type=text name=txtName></p><br>
<p>Age: <input type=text name=txtAge></p>
</BODY>
</HTML>

Ok, here's the form handler save_info.asp, you could make the form and the form handler the same page using ASP but I've split them up to keep it simple:

<% SaveName = Trim(Request.Form("txtName")
SaveAge = Trim(Request.Form("txtAge")
'A simple check for blank entries
If SaveName <> "" Then
If SaveAge <> "" Then
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DSN=YourDSN;UID=YourID;PWD=YourPW"

Set RSUpdate = Server.CreateObject("ADODB.Recordset")

RSUpdate.ActiveConnection = Conn
RSUpdate.CursorType = 3 'adOpenKeyset
RSUpdate.LockType = 2 'adLockOptimistic
RSUpdate.Source = "YourTable"
RSUpdate.Open
RSUpdate.AddNew

RSUpdate.Fields("Name") = SaveName
RSUpdate.Fields("Age") = SaveAge

RSUpdate.Update
RSUpdate.MoveFirst
RSUpdate.Close

Set RSUpdate = nothing
Conn.Close
Set Conn = nothing
Response.Write "Done!"
Else
Response.Write "No Age!"
End If
Else
Response.Write "No Name!"
End If
%>

That's just a very basic example of saving new records.

Regards,
Peter J. Boettcher