Writing SessionID to Table Fields

ggrewe · Nov 21, 2001

I am trying to assigned the SessionID to a variable and then insert that value into an Access table via a hidden form on the form. I am also trying to display the value on a confirmation page. I am having no luck with either. I am using Front Page and could use some help.

This is my basic code:

<%@ Language=VBScript %>
<%
dim confirm
confirm=Session.SessionID
%>

<input type="hidden" name="ConfirmNumber" value=&Confirm&>

BigBadDave · Nov 21, 2001

You need :

<%@ Language=VBScript %>
<%
dim confirm
confirm=Session.SessionID
%>

<input type="hidden" name="ConfirmNumber" value="<% =confirm %>"> Regards

Big Dave

davidbyng@hotmail.com

** If I am wrong I am sorry, but i'm only trying to help!! **

lobstah · Nov 21, 2001

try

<input type="hidden" name="ConfirmNumber" value="&Confirm&">

have you done a
response.write (Session.SessionID)
and
response.write (confirm)

to ensure the variable took the value?

lobstah · Nov 21, 2001

oops! davidbyng's right! i was sleeping..... or thinking of turkey, who knows....

lobstah · Nov 21, 2001

except move the space from before to after the = sign.

"<%= confirm %>"

ggrewe · Nov 21, 2001

Dave;

That did it, I can see the value. Now will the confirmation page display the value if I use

Confirmation Number = <<confirm>>

Thanks and Happy T-Day

BigBadDave · Nov 21, 2001

Conformation Number = <%= confirm %> Regards

Big Dave

davidbyng@hotmail.com

** If I am wrong I am sorry, but i'm only trying to help!! **

ggrewe · Nov 21, 2001

Thanks for all your help. I guess I need to take a class. Take care,

Greg

ggrewe · Nov 21, 2001

Dave;

When trying to display the appropriate confirmation page for form, I am using the following code;

U-Confirmation-Url="confirmationreg.asp?ConfirmationNumber=<% =confirm %>"

It returns the following error;

Response.Redirect "confirmationreg.asp?ConfirmationNumber=<% =confirm
---------------------------------------------------------------------^

Any ideas?

Thanks.

lobstah · Nov 21, 2001

in this case, your syntax will be:

U-Confirmation-Url="confirmationreg.asp?ConfirmationNumber=" & confirm

When you are within the script tags:

<%

and you have a string defined as above, then you start and end your string with double quotes (&quot

, and concantenate strings and variables with &

%>

When you are outside of the <% %> tags, in straight HTML, as you were in your form field example above, then you need to use <%= %> to access variable values. The <%= %> actually replaces "Response.Write"

make more sense now?

ggrewe · Nov 21, 2001

Thanks lobstah, this makes perfect sense now. I changed my code and the works now works, however when the confirmation page is displayed, I recieve the error that no parameter value was passed;

Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Extra ) in query expression '(ConfirmationNumber = )'.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers

One or more form fields were empty. You should provide default values for all form fields that are used in the query.

The link comes up without the value as well;

https://members.mtna.org/events/confirmationreg.asp?ConfirmationNumber=

So I must have something wrong somewhere, although the value is being written into the db.

BigBadDave · Nov 21, 2001

Post all the code for the page then the error can be identified. Regards

Big Dave

davidbyng@hotmail.com

** If I am wrong I am sorry, but i'm only trying to help!! **

ggrewe · Nov 21, 2001

Okay, but it is a big one. Thanks in advance.

Greg

<%
dim confirm
confirm=Session.SessionID
%>
<%
' FP_ASP ASP Automatically generated by a Frontpage Component. Do not Edit.
On Error Resume Next

strErrorUrl = ""

If Request.ServerVariables("REQUEST_METHOD&quot

= "POST" Then
If Request.Form("VTI-GROUP&quot

= "0" Then
Err.Clear

Set fp_conn = Server.CreateObject("ADODB.Connection&quot

FP_DumpError strErrorUrl, "Cannot create connection"

Set fp_rs = Server.CreateObject("ADODB.Recordset&quot

FP_DumpError strErrorUrl, "Cannot create record set"

fp_conn.Open Application("Convention_ConnectionString&quot

FP_DumpError strErrorUrl, "Cannot open database"

fp_rs.Open "Convention", fp_conn, 1, 3, 2 ' adOpenKeySet, adLockOptimistic, adCmdTable
FP_DumpError strErrorUrl, "Cannot open record set"

fp_rs.AddNew
FP_DumpError strErrorUrl, "Cannot add new record set to the database"
Dim arFormFields0(71)
Dim arFormDBFields0(71)

arFormFields0(0) = "AssocBreakfastAmount"
arFormDBFields0(0) = "AssocBreakfastAmount"
arFormFields0(1) = "StudentMember"
arFormDBFields0(1) = "StudentMember"
arFormFields0(2) = "Telephone"
arFormDBFields0(2) = "Telephone"
arFormFields0(3) = "FromTopAmount"
arFormDBFields0(3) = "FromTopAmount"
arFormFields0(4) = "AmericanExpress"
arFormDBFields0(4) = "AmericanExpress"
arFormFields0(5) = "Visa"
arFormDBFields0(5) = "Visa"
arFormFields0(6) = "MTNAGala"
arFormDBFields0(6) = "MTNAGala"
arFormFields0(7) = "Pedagogy"
arFormDBFields0(7) = "Pedagogy"
arFormFields0(8) = "StudentMemberAmount"
arFormDBFields0(8) = "StudentMemberAmount"
arFormFields0(9) = "Address1"
arFormDBFields0(9) = "Address1"
arFormFields0(10) = "MTNAMastercard"
arFormDBFields0(10) = "MTNAMasterCard"
arFormFields0(11) = "PedagogyStudent"
arFormDBFields0(11) = "PedagogyStudent"
arFormFields0(12) = "SymposiumQTY"
arFormDBFields0(12) = "SymposiumQTY"
arFormFields0(13) = "SpecialInvitationAmount"
arFormDBFields0(13) = "SpecialInvitationAmount"
arFormFields0(14) = "ActiveMemberAmount"
arFormDBFields0(14) = "ActiveMemberAmount"
arFormFields0(15) = "ExpDate"
arFormDBFields0(15) = "ExpDate"
arFormFields0(16) = "CardNumber"
arFormDBFields0(16) = "CardNumber"
arFormFields0(17) = "AwardsBrunch"
arFormDBFields0(17) = "AwardsBrunch"
arFormFields0(18) = "PedagogyLunchQTY"
arFormDBFields0(18) = "PedagogyLunchQTY"
arFormFields0(19) = "ProStudioStudentQTY"
arFormDBFields0(19) = "ProStudioStudentQTY"
arFormFields0(20) = "SpecialInvitation"
arFormDBFields0(20) = "SpecialInvitation"
arFormFields0(21) = "FirstConference"
arFormDBFields0(21) = "FirstConference"
arFormFields0(22) = "SpecialNeeds"
arFormDBFields0(22) = "SpecialNeeds"
arFormFields0(23) = "ProStudioLunch"
arFormDBFields0(23) = "ProStudioLunch"
arFormFields0(24) = "NonMemberAmount"
arFormDBFields0(24) = "NonMemberAmount"
arFormFields0(25) = "PedagogyLunchAmount"
arFormDBFields0(25) = "PedagogyLunchAmount"
arFormFields0(26) = "PedagogyStudentQTY"
arFormDBFields0(26) = "PedagogyStudentQTY"
arFormFields0(27) = "ProStudioQTY"
arFormDBFields0(27) = "ProStudioQTY"
arFormFields0(28) = "ProStudio"
arFormDBFields0(28) = "ProStudio"
arFormFields0(29) = "MemberId"
arFormDBFields0(29) = "MemberID"
arFormFields0(30) = "Program"
arFormDBFields0(30) = "Program"
arFormFields0(31) = "AssocBreakfastQTY"
arFormDBFields0(31) = "AssocBreakfastQTY"
arFormFields0(32) = "SymposiumAmount"
arFormDBFields0(32) = "SymposiumAmount"
arFormFields0(33) = "email"
arFormDBFields0(33) = "e-mail"
arFormFields0(34) = "ProgramAmount"
arFormDBFields0(34) = "ProgramAmount"
arFormFields0(35) = "PedagogyLunch"
arFormDBFields0(35) = "PedagogyLunch"
arFormFields0(36) = "Mastercard"
arFormDBFields0(36) = "MasterCard"
arFormFields0(37) = "MTNAGalaAmount"
arFormDBFields0(37) = "MTNAGalaAmount"
arFormFields0(38) = "ProStudioLunchQTY"
arFormDBFields0(38) = "ProStudioLunchQTY"
arFormFields0(39) = "StudentNonMemberAmount"
arFormDBFields0(39) = "StudentNonMemberAmount"
arFormFields0(40) = "City"
arFormDBFields0(40) = "City"
arFormFields0(41) = "FromTopQTY"
arFormDBFields0(41) = "FromTopQTY"
arFormFields0(42) = "TotalFees"
arFormDBFields0(42) = "TotalFees"
arFormFields0(43) = "PedagogyStudentAmount"
arFormDBFields0(43) = "PedagogyStudentAmount"
arFormFields0(44) = "PedagogyQTY"
arFormDBFields0(44) = "PedagogyQTY"
arFormFields0(45) = "LabOnlyQTY"
arFormDBFields0(45) = "LabOnlyQTY"
arFormFields0(46) = "NewMember"
arFormDBFields0(46) = "NewMember"
arFormFields0(47) = "FirstName"
arFormDBFields0(47) = "FirstName"
arFormFields0(48) = "AwardsBrunchQTY"
arFormDBFields0(48) = "AwardsBrunchQTY"
arFormFields0(49) = "ProStudioLunchAmount"
arFormDBFields0(49) = "ProStudioLunchAmount"
arFormFields0(50) = "LabOnlyAmount"
arFormDBFields0(50) = "LabOnlyAmount"
arFormFields0(51) = "Symposium"
arFormDBFields0(51) = "Symposium"
arFormFields0(52) = "AssocBreakfast"
arFormDBFields0(52) = "AssocBreakfast"
arFormFields0(53) = "ProStudioStudentAmount"
arFormDBFields0(53) = "ProStudioStudentAmount"
arFormFields0(54) = "LabOnly"
arFormDBFields0(54) = "LabOnly"
arFormFields0(55) = "ActiveMember"
arFormDBFields0(55) = "ActiveMember"
arFormFields0(56) = "Specifics"
arFormDBFields0(56) = "Specifics"
arFormFields0(57) = "Monitordates"
arFormDBFields0(57) = "MonitorDates"
arFormFields0(58) = "ProgramQTY"
arFormDBFields0(58) = "ProgramQTY"
arFormFields0(59) = "ProStudioStudent"
arFormDBFields0(59) = "ProStudioStudent"
arFormFields0(60) = "ProStudioAmount"
arFormDBFields0(60) = "ProStudioAmount"
arFormFields0(61) = "StudentNonMember"
arFormDBFields0(61) = "StudentNonMember"
arFormFields0(62) = "Zipcode"
arFormDBFields0(62) = "ZipCode"
arFormFields0(63) = "LastName"
arFormDBFields0(63) = "LastName"
arFormFields0(64) = "PreferedName"
arFormDBFields0(64) = "PreferredName"
arFormFields0(65) = "AwardsBrunchAmount"
arFormDBFields0(65) = "AwardsBrunchAmount"
arFormFields0(66) = "MTNAGalaQTY"
arFormDBFields0(66) = "MTNAGalaQTY"
arFormFields0(67) = "NonMember"
arFormDBFields0(67) = "NonMember"
arFormFields0(68) = "Monitor"
arFormDBFields0(68) = "Monitor"
arFormFields0(69) = "State"
arFormDBFields0(69) = "State"
arFormFields0(70) = "PedagogyAmount"
arFormDBFields0(70) = "PedagogyAmount"

FP_SaveFormFields fp_rs, arFormFields0, arFormDBFields0

fp_rs.Update
FP_DumpError strErrorUrl, "Cannot update the database"

fp_rs.Close
fp_conn.Close

FP_FormConfirmation "text/html; charset=windows-1252",_
"Form Confirmation",_
"Thank you for submitting the following information:",_
"conf02reg_Grewe.asp",_
"Return to the form."

End If
End If

%>
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>MTNA Online Registration Form</title>
</head>

<body bgcolor="white" onload="alert('This is a secure site for online registration. Only one registrant per form is permitted. Please use the TAB key to navigate through the form. You must update totals before submitting the form and after making any changes. Upon submitting the form, please print the confirmation page for your records.')">
<form method="POST" action="--WEBBOT-SELF--" onsubmit="return FrontPage_Form1_Validator(this)" name="FrontPage_Form1">

<input type="hidden" name="ConfirmNumber" value="<% =confirm %>">
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="100%" align="center" bgcolor="#C0C0C0"><font size="4" face="Times New Roman"><b>MTNA
National Conference</b></font></td>
</tr>
<tr>
<td width="100%" align="center" bgcolor="#C0C0C0"><font face="Times New Roman" size="3"><b>Cincinnati,
Ohio     March 16-20, 2002</b></font></td>
</tr>
</center>
<tr>
<td width="100%" align="center">
<p align="right"><a href="mailto:sgeis@mtna.org"><font face="Times New Roman" size="2">Need
Help?</font></a></td>
</tr>
<center>
<tr>
<td width="100%" align="center"><font face="Times New Roman" size="3"><b>
ONLINE
REGISTRATION FORM<br>
</b><i> Please carefully complete and submit the form below. Only one
registrant per form is permitted.<br>
Use the TAB key to navigate through the form.</i></font></td>
</tr>
</table>
</center>
</div>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="50%">
<div align="left">
<table border="0" cellpadding="0" cellspacing="0" width="250">
<tr>
<td bgcolor="#C0C0C0"><font face="Times New Roman" size="4"><b>Registration
Information</b></font></td>
</tr>
</table>
</div>
</td>
<td width="50%"> </td>
</tr>
<tr>
<td width="100%" colspan="2">Last Name  <input type="text" name="LastName" size="20">
First Name  <input type="text" name="FirstName" size="20"> Member
# <input type="text" name="MemberId" size="8"></td>
</tr>
<tr>
<td width="50%">Address  <input type="text" name="Address1" size="30"></td>
<td width="50%"> City  <input type="text" name="City" size="15">State

<input type="text" name="State" size="2">Zip  <input type="text" name="Zipcode" size="5"></td>
</tr>
<tr>
<td width="50%">Phone <input type="text" name="Telephone" size="10">E-mail <input type="text" name="email" size="20"></td>
<td width="50%">Preferred name on badge <input type="text" name="PreferedName" size="20"></td>
</tr>
<tr>
<td width="100%" colspan="2"><input type="checkbox" name="FirstConference" value="1">Check
here if this is your first MTNA National Conference.</td>
</tr>
<tr>
<td width="100%" colspan="2"><input type="checkbox" name="NewMember" value="1">Check
here if you are a new member.</td>
</tr>
<tr>
<td width="100%" colspan="2"><input type="checkbox" name="Monitor" value="1">Check
here if you are willing to volunteer to be a monitor. </td>
</tr>
<tr>
<td width="100%" colspan="2">Please specify days available below:
<p><textarea rows="2" name="Monitordates" cols="30"></textarea></td>
</tr>
<tr>
<td width="100%" colspan="2"><input type="checkbox" name="SpecialNeeds" value="1">Check
here if you have special needs (including special dietary needs).<br>
Please explain below:
<p><textarea rows="2" name="Specifics" cols="30"></textarea></td>
</tr>
</table>
</center>
</div>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="25%" valign="top">
<div align="center">
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="100%" bgcolor="#C0C0C0"><b><font face="Times New Roman" size="4">Registration
Fees</font></b></td>
</tr>
</table>
</div>
</td>
<td width="75%" valign="top"><font size="3" face="Times New Roman">The
special discounted registration fees listed below are valid only for
those whose registration form is submitted on or before midnight February 8,
2002. Those registering after February 8, 2002 will be subject to full
registration fees.</font></td>
</tr>
</table>
</center>
</div>
<div align="center">
<table border="1" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="64%" align="center" bgcolor="#C0C0C0">
<p align="left"><font face="Times New Roman" size="3"><b>Conference
Registration </b></font><font face="Times New Roman" size="2">(Check appropriate
box below.)</font></td>
<center>
<td width="12%" align="center" bgcolor="#C0C0C0"><b><font size="3" face="Times New Roman">On
or before 2/8/02</font></b></td>
<td width="12%" align="center" bgcolor="#C0C0C0"><b><font size="3" face="Times New Roman">After
2/8/02</font></b></td>
<td width="12%" align="center" bgcolor="#C0C0C0"><b><font size="3" face="Times New Roman">Amount</font></b></td>
</tr>
<tr>
<td width="64%"><input type="checkbox" name="SpecialInvitation" value="1" onclick="SpecialInvitationAmount.value=149.50">Special
Invitation Offer $149.50 (valid until November 30, 2001)</td>
<td width="12%">
<p align="center">  </td>
<td width="12%" align="center"></td>
<td width="12%" align="center"><input type="text" name="SpecialInvitationAmount" size="8"></td>
</tr>
<tr>
<td width="64%"><input type="checkbox" name="ActiveMember" value="1" onclick="ActiveMemberAmount.value=165" >Active
Member (registration only)</td>
<td width="12%">
<p align="center">$165</td>
<td width="12%" align="center">$215</td>
<td width="12%" align="center"><input type="text" name="ActiveMemberAmount" onclick="TotalFees.value=165" size="8"></td>
</tr>
<tr>
<td width="64%"><input type="checkbox" name="StudentMember" value="1" onclick="StudentMemberAmount.value=50">Student
Member (registration only)</td>
<td width="12%">
<p align="center">$50</td>
<td width="12%" align="center">$65</td>
<td width="12%" align="center"><input type="text" name="StudentMemberAmount" size="8"></td>
</tr>
<tr>
<td width="64%"><input type="checkbox" name="NonMember" value="1" onclick="NonMemberAmount.value=225">Nonmember
(registration only)</td>
<td width="12%">
<p align="center">$225</td>
<td width="12%" align="center">$275</td>
<td width="12%" align="center"><input type="text" name="NonMemberAmount" size="8"></td>
</tr>
<tr>
<td width="64%"><input type="checkbox" name="StudentNonMember" value="1" onclick="StudentNonMemberAmount.value=65">Student
Nonmember (registration only) <br>
    (Includes $12 voucher towards membership.)</td>
<td width="12%">
<p align="center">$65 </td>
<td width="12%" align="center">$75</td>
<td width="12%" align="center"><input type="text" name="StudentNonMemberAmount" size="8"></td>
</tr>
<tr>
<td width="64%" bgcolor="#C0C0C0"><font size="3" face="Times New Roman"><b>Pre-Conference
Workshops </b></font><font face="Times New Roman" size="2">(Check appropriate boxes
below.)</font></td>
<td width="12%" align="center" bgcolor="#C0C0C0"><b><font size="3" face="Times New Roman">Fee</font></b></td>
<td width="12%" align="center" bgcolor="#C0C0C0"><b><font size="3" face="Times New Roman">Quantity</font></b></td>
<td width="12%" align="center" bgcolor="#C0C0C0"><b><font size="3" face="Times New Roman">Amount</font></b></td>
</tr>
<tr>
<td width="64%"><input type="checkbox" name="Symposium" value="1" onclick ="SymposiumAmount.value=75">Technology in Music Symposium; Fri., March
15-<br>
Tue.,
March 19 (<i>Includes all technology sessions and lab.)</i></td>
<td width="12%">
<p align="center">$75</td>
<td width="12%" align="center">
<p align="center">N/A
</td>
<td width=" align=" 12%" center">
<p align="center"><input type="text" name="SymposiumAmount" size="8"></p>
</td>
</tr>
<tr>
<td width="64%"><input type="checkbox" name="LabOnly" value="1" onclick ="LabOnlyAmount.value=40">Technology Lab
Only; Sun., March 17-Tue., March 19</td>
<td width="12%" align="center">$40</td>
<td width="12%" align="center">N/A</td>
<td width="12%" align="center"><input type="text" name="LabOnlyAmount" size="8"></td>
</tr>
<tr>
<td width="64%"><input type="checkbox" name="ProStudio" value="1" onclick ="ProStudioAmount.value=35">Professional Studio Saturday; Sat., March 16</td>
<td width="12%" align="center">$35</td>
<td width="12%" align="center">N/A</td>
<td width="12%" align="center"><input type="text" name="ProStudioAmount" size="8"></td>
</tr>
<tr>
<td width="64%"><input type="checkbox" name="ProStudioStudent" value="1" onclick="ProStudioStudentAmount.value=25">Professional Studio Saturday <i><b>Student</b>;</i>
Sat., March 16</td>
<td width="12%" align="center">$25</td>
<td width="12%" align="center">N/A</td>
<td width="12%" align="center"><input type="text" name="ProStudioStudentAmount" size="8"></td>
</tr>
<tr>
<td width="64%"><input type="checkbox" name="Pedagogy" value="1" onclick ="PedagogyAmount.value=35">Pedagogy Saturday; Sat., March 16</td>
<td width="12%" align="center">$35</td>
<td width="12%" align="center">N/A</td>
<td width="12%" align="center"><input type="text" name="PedagogyAmount" size="8"></td>
</tr>
<tr>
<td width="64%"><input type="checkbox" name="PedagogyStudent" value="1" onclick ="PedagogyStudentAmount.value=25">Pedagogy Saturday <b><i>Student;</i></b> Sat., March
16</td>
<td width="12%" align="center">$25</td>
<td width="12%" align="center">N/A</td>
<td width="12%" align="center"><input type="text" name="PedagogyStudentAmount" size="8"></td>
</tr>
<tr>
<td width="64%">Add boxed lunch for Professional Studio Saturday;<i> </i>Sat.,
March 16 <i><br>
(Please specify quantity. Must be ordered in advance.)</i></td>
<td width="12%" align="center">$15</td>
<td width="12%" align="center"><input type="text" name="ProStudioLunchQTY" size="8" value="0" onchange="ProStudioLunchAmount.value=ProStudioLunchQTY.value*15"></td>
<td width="12%" align="center"><input type="text" name="ProStudioLunchAmount" size="8"></td>
</tr>
<tr>
<td width="64%">Add boxed lunch for Pedagogy Saturday; Sat., March 16 <br>
<i>(Please specify quantity. Must be ordered in advance.)</i></td>
<td width="12%" align="center">$15</td>
<td width="12%" align="center"><input type="text" name="PedagogyLunchQTY" size="8" value="0" onchange="PedagogyLunchAmount.value=PedagogyLunchQTY.value*15"></td>
<td width="12%" align="center"><input type="text" name="PedagogyLunchAmount" size="8"></td>
</tr>
<tr>
<td width="64%" bgcolor="#C0C0C0"><font size="3" face="Times New Roman"><b>Events
</b></font><font face="Times New Roman" size="2">(Please specify quantities for each event listed
below.)</font></td>
<td width="12%" align="center" bgcolor="#C0C0C0"></td>
<td width="12%" align="center" bgcolor="#C0C0C0"></td>
<td width="12%" align="center" bgcolor="#C0C0C0"></td>
</tr>
<tr>
<td width="64%">MTNA Gala; Mon., March 18</td>
<td width="12%" align="center">$60</td>
<td width="12%" align="center"><input type="text" name="MTNAGalaQTY" size="8" value="0" onchange="MTNAGalaAmount.value=MTNAGalaQTY.value*60"></td>
<td width="12%" align="center"><input type="text" name="MTNAGalaAmount" size="8"></td>
</tr>
<tr>
<td width="64%">Association Breakfast; Tue., March 19</td>
<td width="12%" align="center">$15</td>
<td width="12%" align="center"><input type="text" name="AssocBreakfastQTY" size="8" value="0" onchange="AssocBreakfastAmount.value=AssocBreakfastQTY.value*15"></td>
<td width="12%" align="center"><input type="text" name="AssocBreakfastAmount" size="8"></td>
</tr>
<tr>
<td width="64%">Awards Brunch; Wed., March 20</td>
<td width="12%" align="center">$30</td>
<td width="12%" align="center"><input type="text" name="AwardsBrunchQTY" size="8" value="0" onchange="AwardsBrunchAmount.value=AwardsBrunchQTY.value*30"></td>
<td width="12%" align="center"><input type="text" name="AwardsBrunchAmount" size="8"></td>
</tr>
<tr>
<td width="64%">From the Top, <i>Taping Transportation Fee</i>, Tue.
March 19</td>
<td width="12%" align="center">$10</td>
<td width="12%" align="center"><input type="text" name="FromTopQTY" size="8" value="0" onchange="FromTopAmount.value=FromTopQTY.value*10"></td>
<td width="12%" align="center"><input type="text" name="FromTopAmount" size="8"></td>
</tr>
<tr>
<td width="64%"></td>
<td width="12%" align="center"></td>
<td width="12%" align="center"></td>
<td width="12%" align="center"></td>
</tr>
<tr>
<td width="64%">MTNA National Student Competitions Program Book</td>
<td width="12%" align="center">$5</td>
<td width="12%" align="center"><input type="text" name="ProgramQTY" size="8" value="0" onchange="ProgramAmount.value=ProgramQTY.value*5"></td>
<td width="12%" align="center"><input type="text" name="ProgramAmount" size="8"></td>
</tr>
</center>
<tr>
<td width="88%" colspan="3">
 
</td>
<center>
<td width="12%" align="center"> </td>
</tr>
</table>
</center>
</div>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="60%" colspan="5">Click to update total before submitting your
form and after making any changes.<br>
<input type="button" value="Click to update total $" name="Update" onclick="TotalFees.value=(ActiveMemberAmount.value*1)+(StudentMemberAmount.value*1)+(NonMemberAmount.value*1)+(StudentNonMemberAmount.value*1)+(SpecialInvitationAmount.value*1)+(SymposiumAmount.value*1)+(LabOnlyAmount.value*1)+(ProStudioAmount.value*1)+(ProStudioStudentAmount.value*1)+(ProStudioLunchAmount.value*1)+(PedagogyAmount.value*1)+(PedagogyStudentAmount.value*1)+(PedagogyLunchAmount.value*1)+(MTNAGalaAmount.value*1)+(AssocBreakfastAmount.value*1)+(AwardsBrunchAmount.value*1)+ (FromTopAmount.value*1)+(ProgramAmount.value*1)" style="font-weight: bold"><input type="text" name="TotalFees" size="8" style="font-weight: bold" ></td>
</tr>
<tr>
<td width="16%"><b>Please charge to my:</b></td>
<td width="12%"><input type="checkbox" name="MTNAMastercard" value="1">MTNA
Mastercard</td>
<td width="8%" valign="top"><input type="checkbox" name="Visa" value="1">Visa</td>
<td width="12%" valign="top"><input type="checkbox" name="Mastercard" value="1">Mastercard</td>
<td width="12%" valign="top"><input type="checkbox" name="AmericanExpress" value="1">American
Express</td>
</tr>
</table>
</center>
</div>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="50%">Credit Card #  <input type="text" name="CardNumber" size="20"></td>
<td width="50%">Expiration Date  <input type="text" name="ExpDate" size="10"></td>
</tr>
</table>
</center>
</div>
<p>
Please review your information carefully and update totals before submitting the
form. Upon submitting the form, please print the confirmation page for your
records.<br>
<input type="submit" value="Submit Form" name="Submit"><input type="reset" value="Reset Form" name="Reset">
</p>
</form>

</body>

</html>

BigBadDave · Nov 21, 2001

I think the error is this chunk here :

<!--webbot bot="SaveDatabase" SuggestedExt="asp"
U-ASP-Include-Url="../_fpclass/fpdbform.inc" S-DataConnection="Convention"
S-RecordSource="Convention" U-Database-URL="../fpdb/Convention.mdb"
U-Confirmation-Url="confirmationreg.asp?ConfirmationNumber=" & confirm
S-Form-Fields="AssocBreakfastAmount StudentMember Telephone

when it should be :

<!--webbot bot="SaveDatabase" SuggestedExt="asp"
U-ASP-Include-Url="../_fpclass/fpdbform.inc" S-DataConnection="Convention"
S-RecordSource="Convention" U-Database-URL="../fpdb/Convention.mdb"
U-Confirmation-Url="confirmationreg.asp?ConfirmationNumber=<%= confirm %>"
S-Form-Fields="AssocBreakfastAmount StudentMember Telephone

Regards

Big Dave

davidbyng@hotmail.com

** If I am wrong I am sorry, but i'm only trying to help!! **

ggrewe · Nov 21, 2001

Dave;

I did have that code in at one point. If you look a few messages up, when I enter <%=confirm%> if get the error;

U-Confirmation-Url="confirmationreg.asp?ConfirmationNumber=<% =confirm %>"

It returns the following error;

Response.Redirect "confirmationreg.asp?ConfirmationNumber=<% =confirm
---------------------------------------------------------------------^

That is when Lobstah suggested & confirm

BigBadDave · Nov 21, 2001

oh right yeah, sorry Regards

Big Dave

davidbyng@hotmail.com

** If I am wrong I am sorry, but i'm only trying to help!! **

ggrewe · Nov 21, 2001

If I maunally assign a value instead of passing a parameter, it works. Should I be using something other than the variable confirm? Maybe the field name "ConfirmNumber"?

BigBadDave · Nov 21, 2001

Confirm is not a reserved word so that shouldn't be the problem. Regards

Big Dave

davidbyng@hotmail.com

** If I am wrong I am sorry, but i'm only trying to help!! **

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!

Writing SessionID to Table Fields

IS-IT--Management

Programmer

Programmer

Programmer

Programmer

IS-IT--Management

Programmer

IS-IT--Management

IS-IT--Management

Programmer

IS-IT--Management

Programmer

IS-IT--Management

Programmer

IS-IT--Management

Programmer

IS-IT--Management

Programmer

Similar threads

Log in

Part and Inventory Search

Sponsor