request.form fails

This is a discussion on "request.form fails" within the Classic ASP section. This forum, and the thread "request.form fails are both part of the Program Your Website category.


 Subscribe in a reader

Go Back   Webforumz.com > Main Forums > Program Your Website > Classic ASP

Notices




Reply
 
LinkBack (2) Thread Tools
  2 links from elsewhere to this Post. Click to view. #1  
Old Mar 3rd, 2007, 14:49
New Member
Join Date: Mar 2007
Location: Fort Lauderdale, FL
Age: 51
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Angry request.form fails

Hi Guys! This one is stumping me!
I have an account sign-up form (code at the bottom of this post) which calls an asp page which would read the form, build a SQL insert string and insert the new record into a table. I was originally getting a SQL error for trying to submit a blank field. In my debugging process I have eliminated all the ADO and SQL code and I am capturing and printing the form variables. The odd thing is that request.form(variable_name) is only returning values for the first two fields of the form.
I'm sure its something stupid I'm doing but I can't seem to see the forest for the trees! I would appreciate your help!
Following is the form code sans the table formatting, the asp code and the output.
Thanks,
Phil
================ FORM CODE ================
[code laungage=html]
<form name="account_setup" method="POST" action="/customer/register.asp">
<input type="hidden" name="referer" value=>
User id: <input type="text" name="userid" size="20">
Password: <input type="password" name="userpass" size="20">
Verify Password: <input type="password" name="passtwo" size="20">
E-mail address: <input type="text" name=”email” size="50">
First Name: <input type="text" name=”first” size="50">
Last Name: <input type=”text” name=”last” size="50">
Company: <input type=”text” name=”company” size="80">
Street: <input type=”text” name=”address1” size="80">
Suite: <input type=”text” name=”address2” size="50">
City: <input type=”text” name=”city” size="80">
State: <input type=”text” name=”state” size="2">
Zip: <input type=”text” name=”zip” size="10">
Country: <input type=”text” name=”country” size="50">
Phone: <input type=”text” name=”night_phone_a” size="3">-
<input type=”text” name=”night_phone_b” size="3">-
<input type=”text” name=”night_phone_c” size="4">
<input type="submit" value="Submit" name="B1" onclick="validate('account_setup');">
<input type="reset" value="Reset" name="B2"></p>
</form>
[/code]
============== END FORM CODE ==============
================ ASP CODE ================
[code laungage=ASP]
<%@ Language=VBScript %>
<%
Dim u1 ' Form storage variables
Dim u2
Dim u3
Dim u4
Dim u5
Dim u6
Dim u7
Dim u8
Dim u9
Dim u10
Dim u11
Dim u12
Dim u13
Dim u13b
Dim u13c
Dim u14
%>
The form data <%= Request.Form %>
<br>
<%
If Request.Form("userid") > "" Then
u1 = Trim(Request.Form("userid"))
u2 = Trim(Request.Form("userpass"))
u3 = Trim(Request.Form("email"))
u4 = Trim(Request.Form("first"))
u5 = Trim(Request.Form("last"))
u6 = Trim(Request.Form("company"))
u7 = Trim(Request.Form("address1"))
u8 = Trim(Request.Form("address2"))
u9 = Trim(Request.Form("city"))
u10 = Trim(Request.Form("state"))
u11 = Trim(Request.Form("zip"))
u12 = Trim(Request.Form("country"))
u13 = Trim(Request.Form("night_phone_a"))
u13b = Trim(Request.Form("night_phone_b"))
u13c = Trim(Request.Form("night_phone_c"))
u14 = Trim(Request.Form("referer"))
'combine the phone number into one string
u13 = u13 &u13b &u13c
response.write("Form Variables: <br>" )
response.write("userid = " &u1 &"<br>" )
response.write("userpass = " &u2 &"<br>" )
response.write("email = " &u3 &"<br>" )
response.write("first = " &u4 &"<br>" )
response.write("last = " &u5 &"<br>" )
response.write("company = " &u6 &"<br>" )
response.write("addr1 = " &u7 &"<br>" )
response.write("addr2 = " &u8 &"<br>" )
response.write("city = " &u9 &"<br>" )
response.write("st = " &u10 &"<br>" )
response.write("zip =" &u11 &"<br>" )
response.write("country = " &u12 &"<br>" )
response.write("phone = " &u13 &"<br>" )
response.write("referer = " &u14 &"<br>")
' Build the SQL insert command
strSQL = "Insert INTO users (usr_id, usr_pass, usr_first, usr_last, usr_company, usr_addr1, usr_addr2, usr_city, usr_st, usr_postal, usr_country, usr_phone, usr_email, usr_referer) Values ('" &u1 &"','" &u2 &"','" &u4 &"','" &u5 &"','" &u6 &"','" &u7 &"','" &u8 &"','" &u9 &"','" &u10 &"','" &u11 &"','" &u12 &"','" &u13 &"','" &u3 &"','" &u14 &"')"
response.write(strSQL)
End If
%>
[/code]
============== END ASP CODE ==============
================ ASP OUTPUT ================
The form data referer=&userid=ttest&userpass=0427&passtwo=0427&% 94email%94=mailloop@localhost.com&%94first%94=Tim& %94last%94=Test&%94company%94=Anycompany%2C+Inc.&% 94address1%94=11108+Masters+Way&%94address2%94=C-102&%94city%94=Augusta&%94state%94=GA&%94zip%94=30 005&%94country%94=USA&%94night_phone_a%94=404&%94n ight_phone_b%94=111&%94night_phone_c%94=2222&B1=Su bmit
Form Variables:
userid = ttest
userpass = 0427
email =
first =
last =
company =
addr1 =
addr2 =
city =
st =
zip =
country =
phone =
referer =
Insert INTO users (usr_id, usr_pass, usr_first, usr_last, usr_company, usr_addr1, usr_addr2, usr_city, usr_st, usr_postal, usr_country, usr_phone, usr_email, usr_referer) Values ('ttest','0427','','','','','','','','','','','',' ')
============== END ASP OUTPUT ==============
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

  #2  
Old Mar 15th, 2007, 11:19
New Member
Join Date: Mar 2007
Location: Fort Lauderdale, FL
Age: 51
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Re: request.form fails

Fixed it... if you look closely the quotes surrounding the form field name are not real quotes, not sure where they came from or how they snuck in there but they are not the real ".
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Tags
asp, form

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

LinkBacks (?)
LinkBack to this Thread: http://webforumz.com/classic-asp/24180-request-form-fails.htm
Posted By For Type Date
Office In The Country » request.form fails This thread Pingback Mar 3rd, 2007 16:50
Cheat Codes » request.form fails This thread Pingback Mar 3rd, 2007 16:22

Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with 'if Request.Form' on form sing2trees Classic ASP 2 Apr 21st, 2008 14:01
Link Checker for Firefox -- fails MikeHopley Scripts and Online Services 9 Jan 14th, 2008 18:58
Form fails strict XHTML validation newoptical Web Page Design 10 Jun 7th, 2007 12:08
sending email fails flann Hosting & Domains 1 Feb 17th, 2007 23:38
Glass Ball tutorial always fails autumn_whispers2me Graphics and 3D 2 Jan 26th, 2005 20:48


All times are GMT. The time now is 14:19.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0 RC8
© 2003-2008 Webforumz.com : All Rights Reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42