Writing records, best approach???

[aolb]

For the first time I have to take the data entered on a screen and write it to a record. I can think of a few ways of doing this but what is the best approach?

I am using ASP and SQL Server and I have VB if needed.

 

[Palooka]

There are, as always, several ways to accomplish this. One way is to create a stored procedure on your SQL Server, and pass it your data from the web-page. Another is to create and populate a recordset in your ASP, and then update your database with it.

I guess it all comes down to preference. Personally, I prefer the latter.

Here's an example on how to build the recordset. It's not ASP, but it's generally the same:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q193331

Palooka

 

[aolb]

Basically whatever way I do this I will need a second ASP page to take the data from screen produced by the first ASP page and then write the data to a record.

 

[Palooka]

Not necessarely. That tends to give you a whole lot of files to manage.

To avoid that, you can have the page post to itself:

<form name=&quot;myForm&quot; action=&quot;<%= Request.ServerVariables(&quot;SCRIPT_NAME&quot;)%>&quot; method=&quot;post&quot;>

Thus you can have your ASP to check wether it should build your web-page as usual, or process the form and build a recordset:

if Request.ServerVariables("Request_Method") = "POST" Then
   'Request data from form
   'Build recordset
   'Update database
else
   'Build web page
end if

Palooka

 

[Tarwn]

I wrote a (very) commented example of doing something similar in the FAQs. The page submits back to itselkf for all DB submissions (Insert, Update, And delete) using flags to control what action to tak and whether to just list the results or do another transaction, like add a record, and then list the results.
The code is downloadable for the commented and uncommented version, the db is access (yuck) but the same logic will work for any database. ASP 102 FAQ
-Tarwn ------------ My Little Dictionary ---------
Reverse Engineering - The expensive solution to not paying for proper documentation