PS
Storage of any Credit Card Numbers & Codes in any database is against credit card company policy and puts the OP (and buyers) at
significant risk
IMHO the OP should get and use a valid Ecommerce solution that passed the CC info to a CC processor
--
_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________
| Name is a reserved word in Access 2002 and in later versions of Access - you
| need to change it to something else. See:
|
http://support.microsoft.com/kb/286335/
|
| --
|
| ~ Kathleen Anderson
| Microsoft MVP - FrontPage
| Spider Web Woman Designs
| Expression Web Resources:
http://www.spiderwebwoman.com/xweb/
| FrontPage Resources:
http://www.spiderwebwoman.com/resources/
| Please reply to the newsgroup for the benefit of others
|
|
| | > Here's the code generated by Frontpage:
| >
| > <%
| > ' FP_ASP ASP Automatically generated by a FrontPage Component. Do not
| > Edit.
| >
| > On Error Resume Next
| > Session("FP_OldCodePage") = Session.CodePage
| > Session("FP_OldLCID") = Session.LCID
| > Session.CodePage = 1252
| > Err.Clear
| >
| > strErrorUrl = ""
| >
| > If Request.ServerVariables("REQUEST_METHOD") = "POST" Then
| > If Request.Form("VTI-GROUP") = "0" Then
| > Err.Clear
| >
| > Set fp_conn = Server.CreateObject("ADODB.Connection")
| > FP_DumpError strErrorUrl, "Cannot create connection"
| >
| > Set fp_rs = Server.CreateObject("ADODB.Recordset")
| > FP_DumpError strErrorUrl, "Cannot create record set"
| >
| > fp_conn.Open Application("gardeners_niche_early_ConnectionString")
| > FP_DumpError strErrorUrl, "Cannot open database"
| >
| > fp_rs.Open "Results", 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(18)
| > Dim arFormDBFields0(18)
| > Dim arFormValues0(18)
| >
| > arFormFields0(0) = "address"
| > arFormDBFields0(0) = "address"
| > arFormValues0(0) = Request("address")
| > arFormFields0(1) = "fax"
| > arFormDBFields0(1) = "fax"
| > arFormValues0(1) = Request("fax")
| > arFormFields0(2) = "email"
| > arFormDBFields0(2) = "email"
| > arFormValues0(2) = Request("email")
| > arFormFields0(3) = "phone"
| > arFormDBFields0(3) = "phone"
| > arFormValues0(3) = Request("phone")
| > arFormFields0(4) = "cc_type"
| > arFormDBFields0(4) = "cc_type"
| > arFormValues0(4) = Request("cc_type")
| > arFormFields0(5) = "regular_price"
| > arFormDBFields0(5) = "regular_price"
| > arFormValues0(5) = Request("regular_price")
| > arFormFields0(6) = "cc_security_code"
| > arFormDBFields0(6) = "cc_security_code"
| > arFormValues0(6) = Request("cc_security_code")
| > arFormFields0(7) = "cc_name"
| > arFormDBFields0(7) = "cc_name"
| > arFormValues0(7) = Request("cc_name")
| > arFormFields0(8) = "city"
| > arFormDBFields0(8) = "city"
| > arFormValues0(8) = Request("city")
| > arFormFields0(9) = "zip_code"
| > arFormDBFields0(9) = "zip_code"
| > arFormValues0(9) = Request("zip_code")
| > arFormFields0(10) = "cc_number"
| > arFormDBFields0(10) = "cc_number"
| > arFormValues0(10) = Request("cc_number")
| > arFormFields0(11) = "early_bird_price"
| > arFormDBFields0(11) = "early_bird_price"
| > arFormValues0(11) = Request("early_bird_price")
| > arFormFields0(12) = "company"
| > arFormDBFields0(12) = "company"
| > arFormValues0(12) = Request("company")
| > arFormFields0(13) = "name"
| > arFormDBFields0(13) = "name"
| > arFormValues0(13) = Request("name")
| > arFormFields0(14) = "state"
| > arFormDBFields0(14) = "state"
| > arFormValues0(14) = Request("state")
| > arFormFields0(15) = "total"
| > arFormDBFields0(15) = "total"
| > arFormValues0(15) = Request("total")
| > arFormFields0(16) = "hiddentotal"
| > arFormDBFields0(16) = "hiddentotal"
| > arFormValues0(16) = Request("hiddentotal")
| > arFormFields0(17) = "cc_exp"
| > arFormDBFields0(17) = "cc_exp"
| > arFormValues0(17) = Request("cc_exp")
| >
| > FP_SaveFormFields fp_rs, arFormFields0, arFormDBFields0
| >
| > If Request.ServerVariables("REMOTE_HOST") <> "" Then
| > FP_SaveFieldToDB fp_rs, Request.ServerVariables("REMOTE_HOST"),
| > "Remote_computer_name"
| > End If
| > If Request.ServerVariables("HTTP_USER_AGENT") <> "" Then
| > FP_SaveFieldToDB fp_rs, Request.ServerVariables("HTTP_USER_AGENT"),
| > "Browser_type"
| > End If
| > FP_SaveFieldToDB fp_rs, Now, "Timestamp"
| > If Request.ServerVariables("REMOTE_USER") <> "" Then
| > FP_SaveFieldToDB fp_rs, Request.ServerVariables("REMOTE_USER"),
| > "User_name"
| > End If
| >
| > fp_rs.Update
| > FP_DumpError strErrorUrl, "Cannot update the database"
| >
| > fp_rs.Close
| > fp_conn.Close
| >
| > Session("FP_SavedFields")=arFormFields0
| > Session("FP_SavedValues")=arFormValues0
| > Session.CodePage = Session("FP_OldCodePage")
| > Session.LCID = Session("FP_OldLCID")
| > Response.Redirect "gn_early_reg_confirm.asp"
| >
| > End If
| > End If
| >
| > Session.CodePage = Session("FP_OldCodePage")
| > Session.LCID = Session("FP_OldLCID")
| >
| > %>
| > <html>
| >
| > <head>
| > <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
| > <title>Gardeners Niche Early Registration</title>
| > <SCRIPT LANGUAGE="JavaScript">
| >
| > <!-- Begin
| >
| > function checkChoice(whichbox) {
| >
| > with (whichbox.form) {
| >
| > if (whichbox.checked == false)
| >
| > hiddentotal.value = eval(hiddentotal.value) - eval(whichbox.value);
| >
| > else
| >
| > hiddentotal.value = eval(hiddentotal.value) + eval(whichbox.value);
| >
| > return(formatCurrency(hiddentotal.value));
| >
| > }
| >
| > }
| >
| > function formatCurrency(num) {
| >
| > num = num.toString().replace(/\$|\,/g,'');
| >
| > if(isNaN(num)) num = "0";
| >
| > cents = Math.floor((num*100+0.5)%100);
| >
| > num = Math.floor((num*100+0.5)/100).toString();
| >
| > if(cents < 10) cents = "0" + cents;
| >
| > for (var i = 0; i < Math.floor((num.length-(1+i))/3); i++)
| >
| > num =
| > num.substring(0,num.length-(4*i+3))+','+num.substring(num.length-(4*i+3));
| >
| > return ("$" + num + "." + cents);
| >
| > }
| >
| > // End -->
| >
| > </script>
| >
| > </head>
| >
| > <body>
| >
| > <form method="POST" action="--WEBBOT-SELF--" name="FrontPage_Form1"
| > onsubmit="return FrontPage_Form1_Validator(this)" language="JavaScript">
| > <!--webbot bot="SaveDatabase" startspan SuggestedExt="asp"
| > S-DataConnection="gardeners_niche_early" S-RecordSource="Results"
| > U-Database-URL="../fpdb/gardeners_niche_early.mdb"
| > U-Confirmation-Url="gn_early_reg_confirm.asp" S-Form-Fields="address fax
| > email phone cc_type regular_price cc_security_code cc_name city zip_code
| > cc_number early_bird_price company name state total hiddentotal cc_exp"
| > S-Form-DBFields="address fax email phone cc_type regular_price
| > cc_security_code cc_name city zip_code cc_number early_bird_price company
| > name state total hiddentotal cc_exp"
| > U-ASP-Include-Url="../_fpclass/fpdbform.inc" S-Builtin-Fields="REMOTE_HOST
| > HTTP_USER_AGENT Timestamp REMOTE_USER"
| > S-Builtin-DBFields="Remote_computer_name Browser_type Timestamp User_name"
| > --><input TYPE="hidden" NAME="VTI-GROUP" VALUE="0"><!--#include
| > file="../_fpclass/fpdbform.inc"--><!--webbot bot="SaveDatabase" endspan
| > i-checksum="34604" -->
| >
| > <div align="center">
| > <table border="1" width="850">
| > <tr>
| > <td>
| > <p align="center">
| > <img border="0" src="../images/gardeners_nich.png" width="700"
| > height="166"></td>
| > </tr>
| > <tr>
| > <td> </td>
| > </tr>
| > <tr>
| > <td>
| > <p align="center"><u><b>Register Online
| > <font color="#800000" size="3">Before January 15</font> to
| > receive these Early Bird Prices</b></u></td>
| > </tr>
| > <tr>
| > <td> </td>
| > </tr>
| > <tr>
| > <td>
| > <p align="center">
| > <font color="#800000" face="Verdana" size="2"><u><b>Credit Cards
| > Only</b></u></font></td>
| > </tr>
| > <tr>
| > <td> </td>
| > </tr>
| > <tr>
| > <td>
| > <font size="2" face="Verdana">
| >
| > <input type=checkbox name=early_bird_price value="45"
| > onClick="this.form.total.value=checkChoice(this);" tabindex="1"> $45
| > Early Bird Price</font></td>
| > </tr>
| > <tr>
| > <td>
| > <font face="Verdana" size="2">
| > <input type=checkbox name=regular_price value="55"
| > onClick="this.form.total.value=checkChoice(this);" tabindex="2">
| > $55 Regular Price after January 14</td>
| > </tr>
| > <tr>
| > <td> </td>
| > </tr>
| > <tr>
| > <td>
| > <p style="margin-left: 5px"><font face="Verdana">
| > <font size="2">Name:
| > </font>
| > <!--webbot bot="Validation" s-data-type="String"
| > b-value-required="TRUE" --><input type="text" name="name" size="50"
| > tabindex="3"></font></td>
| > </tr>
| > <tr>
| > <td>
| > <p style="margin-left: 5px"><font size="2">Company:
| > <input type="text" name="company" size="45" tabindex="4"></font></td>
| > </tr>
| > <tr>
| > <td>
| > <p style="margin-left: 5px"><font face="Verdana"><font size="2">Address:
| > </font>
| > <!--webbot bot="Validation" b-value-required="TRUE" --><input
| > type="text" name="address" size="50" tabindex="5"></font></td>
| > </tr>
| > <tr>
| > <td>
| > <table border="0" width="100%">
| > <tr>
| > <td width="53"><font size="2">City:</font></td>
| > <td width="216">
| > <input type="text" name="city" size="25" tabindex="6">,</td>
| > <td width="53"><font size="2">State:</font></td>
| > <td width="214">
| > <input type="text" name="state" size="20" tabindex="7"></td>
| > <td width="82"><font size="2">Zip Code:</font></td>
| > <td>
| > <input type="text" name="zip_code" size="20" tabindex="8"></td>
| > </tr>
| > </table>
| > </td>
| > </tr>
| > <tr>
| > <td>
| > <table border="0" width="100%">
| > <tr>
| > <td width="51"><font size="2">Phone:</font></td>
| > <td width="185">
| > <input type="text" name="phone" size="20" tabindex="9"></td>
| > <td width="45"><font size="2">Fax:</font></td>
| > <td width="231">
| > <input type="text" name="fax" size="20" tabindex="10"></td>
| > <td width="50"><font size="2">email:</font></td>
| > <td>
| > <input type="text" name="email" size="35" tabindex="11"></td>
| > </tr>
| > </table>
| > </td>
| > </tr>
| > <tr>
| > <td>
| > </td>
| > </tr>
| > <tr>
| > <td>
| > <hr width="75%" color="#008000"></td>
| > </tr>
| > <tr>
| > <td>
| > <p style="margin-left: 5px"><font face="Verdana" size="2">Amount Owed:
| > <font face="Verdana">
| > <input type="text" name="total" value="" size=6
| > readonly></font></font></td>
| > </tr>
| > <tr>
| > <td>
| > <p style="margin-left: 5px"><font face="Verdana">
| > <font size="2">Credit Card Type:
| > </font>
| > <!--webbot bot="Validation" b-value-required="TRUE"
| > b-disallow-first-item="TRUE" --><select size="1" name="cc_type"
| > tabindex="12">
| > <option selected>Choose Credit Card Type</option>
| > <option>Visa</option>
| > <option>MasterCard</option>
| > <option>American Express</option>
| > <option>Discover</option>
| > </select></font></td>
| > </tr>
| > <tr>
| > <td>
| > <p style="margin-left: 5px"><font face="Verdana">
| > <font size="2">Name on Credit Card:
| > </font>
| > <!--webbot bot="Validation" s-data-type="String"
| > b-value-required="TRUE" --><input type="text" name="cc_name" size="30"
| > tabindex="13"></font></td>
| > </tr>
| > <tr>
| > <td>
| > <p style="margin-left: 5px"><font face="Verdana">
| > <font size="2">Credit Card #:
| > </font>
| > <!--webbot bot="Validation" s-data-type="Number"
| > s-number-separators=",." b-value-required="TRUE" --><input type="text"
| > name="cc_number" size="30" tabindex="14"></font></td>
| > </tr>
| > <tr>
| > <td>
| > <p style="margin-left: 5px"><font face="Verdana">
| > <font size="2">Expiration Date:
| > </font>
| > <!--webbot bot="Validation" b-value-required="TRUE" --><input
| > type="text" name="cc_exp" size="20" tabindex="15"></font></td>
| > </tr>
| > <tr>
| > <td>
| > <p style="margin-left: 5px"><font face="Verdana">
| > <font size="2">3 or 4 Digit Security Code:
| > </font>
| > <!--webbot bot="Validation" s-data-type="Number"
| > s-number-separators=",." b-value-required="TRUE" --><input type="text"
| > name="cc_security_code" size="7" tabindex="16"></font><font size="2"
| > face="Verdana"> (front of AmEx, back on others)</font></td>
| > </tr>
| > <tr>
| > <td> </td>
| > </tr>
| > <tr>
| > <td>
| > <p align="center">
| > <input type="submit" value="Submit" name="B1" tabindex="17"><input
| > type="reset" value="Reset" name="B2" tabindex="18"></td>
| > </tr>
| > <tr>
| > <td><b><font color="#800000" face="Verdana" size="2">
| > Please be patient waiting for a confirmation; Be sure to
| > hit the Submit button only once or your credit card will
| > be processed twice. Thank you.</font></b></td>
| > </tr>
| > <tr>
| > <td> </td>
| > </tr>
| > </table>
| > </div>
| > <input type="hidden" name="hiddentotal" value="0">
| > </form>
| >
| > </body>
| >
| > </html>
| >
| > "Stefan B Rusynko" wrote:
| >
| >> Post your form code
| >> - make sure your fields are valid names
| >>
| >> --
| >>
| >> _____________________________________________
| >> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| >> "Warning - Using the F1 Key will not break anything!" (-;
| >> _____________________________________________
| >>
| >>
| >> | >> |I have done this a hundred times but for some reason cannot get it to
| >> work
| >> | this time. I'm using FP 2003 and Access 2003. I have created the form
| >> to be
| >> | completed by registrants, I have created the confirmation form and up
| >> to this
| >> | point everything is working. Next I opened the form page,
| >> right-clicked to
| >> | get to form properties, chose go to database, clicked options and chose
| >> | create database and entered the url of the confirmation page. A
| >> database
| >> | was created. I then went to tools to verify the database connection
| >> and it
| >> | verified. When I published the form, the confirmation and the
| >> database, I
| >> | then completed the form and submitted, the confirmation page with info
| >> was
| >> | displayed; however when I opened the database no information is there
| >> just
| >> | the names of the fields. What have I missed??? Thanks for your help.
| >>
| >>
| >>
|
|
