Posted: 14 November 2009 at 4:27pm | IP Logged

Hi Guys

In previous web sites, I've used FP webbot to get data from an ASP form to an Access Database. But this has one serious disadvantage, it ability to use the data in subsequent pages is halted.

Therefore I've been looking at another solution, and I've come up with the following:-

1. Form

<form name="myform" method="post" action="insert.asp">

Firstname:<br><input name="firstname" maxlength="25" > <BR>
Lastname:<br><input name="lastname" maxlength="25" > <BR>        
Age:<br><input name="age" maxlength="3" > <BR>
Gender:<br><input name="gender" maxlength="6" > <BR><BR>

<input type="submit" value="submit" name="s_button">
<input type="reset" value="reset" name="r_button">

</form>

2. The insert Page

<%@ Language="VBScript" %>

<!-- #include file="connectionstring.asp" -->

<%
dim Conn, Connstring, Sql
dim strfirstname, strlastname, strage, strgender

Set Conn = Server.CreateObject("ADODB.Connection")

strfirstname = request.form("firstname")
strlastname = request.form("lastname")
strage = request.form("age")
strgender = request.form("gender")
         
Conn.provider = provider
Conn.ConnectionString = dbasepath
Conn.Open

Sql="INSERT INTO mytable (firstname, lastname, age, gender) VALUES ('" _
 & strfirstname & "','" & strlastname & "','" _
 & strage & "','" & strgender & "')"

Conn.Execute(Sql)

Response.Write "Data successfully inserted!"
%>

But I've got a question, can I use this script to get the data to be used in further pages within the site?

Or am I missing something here