I am inserting 12 datafields in a database with a form in an asp page (12 form objects). After inserting the data via a Submit button, the user is token to another page, and I need to receive only TWO fields from the first page in my second page. How can I send them? I am using Dreamweaver-Ultradev.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Sending data between pages
- Thread starter gcastillo
- Start date
Here you go gcastillo,
Here's a sample of a page I have on my intranet. The following code is from my post page (after user submits page).
***************** This inserts into my table **************
<%
SQL="INSERT INTO input_table (name, date, department, suggestion) Values ("&_
"'"& request.form("name"
& "', " &_
"'"& request.form("date1"& "', " &_
"'"& request.form("department"& "', " &_
"'"& request.form("suggestion"& "')"
Dim myRS
set myRS=server.createobject("ADODB.recordset"
myRS.open SQL, "dsn=Suggestions"
%>
***************** This inserts into my table **************
****************** and sets my Record Set *****************
Then on this table withing the same page, I post only what I want to see from the user input.
QUOTE OF THE DAY
I will prepare, and some day my chance will come.
Abraham Lincoln
<%
Jr_Clown
)
%>
Here's a sample of a page I have on my intranet. The following code is from my post page (after user submits page).
***************** This inserts into my table **************
<%
SQL="INSERT INTO input_table (name, date, department, suggestion) Values ("&_
"'"& request.form("name"
& "', " &_ "'"& request.form("date1"
& "', " &_ "'"& request.form("department"
& "', " &_ "'"& request.form("suggestion"
& "')"Dim myRS
set myRS=server.createobject("ADODB.recordset"
myRS.open SQL, "dsn=Suggestions"
%>
***************** This inserts into my table **************
****************** and sets my Record Set *****************
Then on this table withing the same page, I post only what I want to see from the user input.
Code:
<table>
<tr>
<td width="36%" align="right"><font color="#000080" size="3">Name:</font></td>
<td width="64%"><%=request.form("Name")%></td>
</tr>
<tr>
<td width="36%" align="right"><font color="#000080" size="3">Date
Suggested:</font></td>
<td width="64%"><%=request.form("Date1")%></td>
</tr>
<tr>
</table>QUOTE OF THE DAY
I will prepare, and some day my chance will come.
Abraham Lincoln
<%
Jr_Clown
)%>
- Thread starter
- #3
Thank you for your answer, but the browser displays this message:
"Microsoft VBScript runtime error '800a01b6'
Object doesn't support this property or method: 'form' "
Of course, form is the name of the form I'm using... any help will be greatly appreciated...
"Microsoft VBScript runtime error '800a01b6'
Object doesn't support this property or method: 'form' "
Of course, form is the name of the form I'm using... any help will be greatly appreciated...
May I suggest to display your code below so that I and others that are more familiar with VBScript can help your obstacle?. QUOTE OF THE DAY
Don't waste time telling people what you are doing or what you are going to do. Results have a way of informing the world.
<%
Jr Clown
)%>
- Thread starter
- #5
I use Dreamweaver-Ultradev, so the code for the insert is pretty long. It works fine. The rest is very simple in my example:
<html>
<head>
<title>Example</title>
</head>
<body >
<form name="form1" method="post" action="<%=MM_editAction%>">
<input type="text" name="Name" value="Name">
<input type="submit" name="Submit" value="Submit">
<input type="hidden" name="MM_insert" value="true">
</form>
<html>
<head>
<title>Example</title>
</head>
<body >
<form name="form1" method="post" action="<%=MM_editAction%>">
<input type="text" name="Name" value="Name">
<input type="submit" name="Submit" value="Submit">
<input type="hidden" name="MM_insert" value="true">
</form>
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question