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.
|
|
|
|
|
![]() |
||
request.form fails
|
||
| Notices |
![]() |
|
|
LinkBack (2) | Thread Tools |
#1
|
|||
|
|||
|
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 ============== |
|
|
|
#2
|
|||
|
|||
|
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 ".
|
![]() |
| Tags |
| asp, form |
| Thread Tools | |
|
|
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 |