473,703 Members | 2,376 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Request.Form not working?

I am having an issue with an app that I built, it seems that Request.Form
doesn't want to work sometimes, and only sometimes. For instance, I got a
call last week about an error, I had the user screenshot it and email it to
me, the error was,

Microsoft OLE DB Provider for SQL Server error '80040e14'

Line 1: Incorrect syntax near '='.

/file.asp, line 158

Line 158 points to a DELETE Statement with a WHERE clause of "...WHERE UID =
" & Request.Form("U ID" & i).

This error bugged me, I couldn't figure it out because the app worked for
me. So today I get into work and find that there is another email report of
a problem. I do some troubleshooting and find that UID1 cannot be found, I
mean it is there on the submitting page, but Request.Form("U ID1") returns
nothing. The weird thing is that Request.Form("U ID2") returns the value of
UID2, as do all the other UID's (there are 25 of them). I tried all of the
usuals, Request("UID1") , even tried a loop to write out all of the form
values, there was no UID1 listed (although the source from the previous page
has a value for UID1), I checked the spelling, everything! I finally got
the error resolved by refreshing the page a few times, then it worked
without a hitch.

Has anyone seen anything like this? This is very troubling because it just
quits working out of the blue, no rhyme or reason (that I can tell).

Thanks,
Drew Laing
Oct 23 '06 #1
5 4191
What happens when someone passes this to your application:

1; DROP TABLE tablename; --

http://www.4guysfromrolla.com/webtech/061902-1.shtml

Ray at work
"Drew" <drewDOTlaingAT swvtc.dmhmrsas. virginia.govwro te in message
news:%2******** ********@TK2MSF TNGP05.phx.gbl. ..
>I am having an issue with an app that I built, it seems that Request.Form
doesn't want to work sometimes, and only sometimes. For instance, I got a
call last week about an error, I had the user screenshot it and email it to
me, the error was,

Microsoft OLE DB Provider for SQL Server error '80040e14'

Line 1: Incorrect syntax near '='.

/file.asp, line 158

Line 158 points to a DELETE Statement with a WHERE clause of "...WHERE UID
= " & Request.Form("U ID" & i).

This error bugged me, I couldn't figure it out because the app worked for
me. So today I get into work and find that there is another email report
of a problem. I do some troubleshooting and find that UID1 cannot be
found, I mean it is there on the submitting page, but Request.Form("U ID1")
returns nothing. The weird thing is that Request.Form("U ID2") returns the
value of UID2, as do all the other UID's (there are 25 of them). I tried
all of the usuals, Request("UID1") , even tried a loop to write out all of
the form values, there was no UID1 listed (although the source from the
previous page has a value for UID1), I checked the spelling, everything!
I finally got the error resolved by refreshing the page a few times, then
it worked without a hitch.

Has anyone seen anything like this? This is very troubling because it
just quits working out of the blue, no rhyme or reason (that I can tell).

Thanks,
Drew Laing

Oct 23 '06 #2
It drops my table... duh!

Drew

"Ray Costanzo [MVP]" <my first name at lane 34 dot commercialwrote in
message news:Op******** ******@TK2MSFTN GP02.phx.gbl...
What happens when someone passes this to your application:

1; DROP TABLE tablename; --

http://www.4guysfromrolla.com/webtech/061902-1.shtml

Ray at work
"Drew" <drewDOTlaingAT swvtc.dmhmrsas. virginia.govwro te in message
news:%2******** ********@TK2MSF TNGP05.phx.gbl. ..
>>I am having an issue with an app that I built, it seems that Request.Form
doesn't want to work sometimes, and only sometimes. For instance, I got a
call last week about an error, I had the user screenshot it and email it
to me, the error was,

Microsoft OLE DB Provider for SQL Server error '80040e14'

Line 1: Incorrect syntax near '='.

/file.asp, line 158

Line 158 points to a DELETE Statement with a WHERE clause of "...WHERE
UID = " & Request.Form("U ID" & i).

This error bugged me, I couldn't figure it out because the app worked for
me. So today I get into work and find that there is another email report
of a problem. I do some troubleshooting and find that UID1 cannot be
found, I mean it is there on the submitting page, but
Request.Form(" UID1") returns nothing. The weird thing is that
Request.Form(" UID2") returns the value of UID2, as do all the other UID's
(there are 25 of them). I tried all of the usuals, Request("UID1") , even
tried a loop to write out all of the form values, there was no UID1
listed (although the source from the previous page has a value for UID1),
I checked the spelling, everything! I finally got the error resolved by
refreshing the page a few times, then it worked without a hitch.

Has anyone seen anything like this? This is very troubling because it
just quits working out of the blue, no rhyme or reason (that I can tell).

Thanks,
Drew Laing


Oct 23 '06 #3
But, then we can restore the data and fire the troublemaker... makes it very
easy!

Drew

"Ray Costanzo [MVP]" <my first name at lane 34 dot commercialwrote in
message news:Op******** ******@TK2MSFTN GP02.phx.gbl...
What happens when someone passes this to your application:

1; DROP TABLE tablename; --

http://www.4guysfromrolla.com/webtech/061902-1.shtml

Ray at work
"Drew" <drewDOTlaingAT swvtc.dmhmrsas. virginia.govwro te in message
news:%2******** ********@TK2MSF TNGP05.phx.gbl. ..
>>I am having an issue with an app that I built, it seems that Request.Form
doesn't want to work sometimes, and only sometimes. For instance, I got a
call last week about an error, I had the user screenshot it and email it
to me, the error was,

Microsoft OLE DB Provider for SQL Server error '80040e14'

Line 1: Incorrect syntax near '='.

/file.asp, line 158

Line 158 points to a DELETE Statement with a WHERE clause of "...WHERE
UID = " & Request.Form("U ID" & i).

This error bugged me, I couldn't figure it out because the app worked for
me. So today I get into work and find that there is another email report
of a problem. I do some troubleshooting and find that UID1 cannot be
found, I mean it is there on the submitting page, but
Request.Form(" UID1") returns nothing. The weird thing is that
Request.Form(" UID2") returns the value of UID2, as do all the other UID's
(there are 25 of them). I tried all of the usuals, Request("UID1") , even
tried a loop to write out all of the form values, there was no UID1
listed (although the source from the previous page has a value for UID1),
I checked the spelling, everything! I finally got the error resolved by
refreshing the page a few times, then it worked without a hitch.

Has anyone seen anything like this? This is very troubling because it
just quits working out of the blue, no rhyme or reason (that I can tell).

Thanks,
Drew Laing


Oct 23 '06 #4
Ray,

This problem would still be there even if I used a Stored Procedure... maybe
not the error, but it would not work as expected.

Drew

"Ray Costanzo [MVP]" <my first name at lane 34 dot commercialwrote in
message news:Op******** ******@TK2MSFTN GP02.phx.gbl...
What happens when someone passes this to your application:

1; DROP TABLE tablename; --

http://www.4guysfromrolla.com/webtech/061902-1.shtml

Ray at work
"Drew" <drewDOTlaingAT swvtc.dmhmrsas. virginia.govwro te in message
news:%2******** ********@TK2MSF TNGP05.phx.gbl. ..
>>I am having an issue with an app that I built, it seems that Request.Form
doesn't want to work sometimes, and only sometimes. For instance, I got a
call last week about an error, I had the user screenshot it and email it
to me, the error was,

Microsoft OLE DB Provider for SQL Server error '80040e14'

Line 1: Incorrect syntax near '='.

/file.asp, line 158

Line 158 points to a DELETE Statement with a WHERE clause of "...WHERE
UID = " & Request.Form("U ID" & i).

This error bugged me, I couldn't figure it out because the app worked for
me. So today I get into work and find that there is another email report
of a problem. I do some troubleshooting and find that UID1 cannot be
found, I mean it is there on the submitting page, but
Request.Form(" UID1") returns nothing. The weird thing is that
Request.Form(" UID2") returns the value of UID2, as do all the other UID's
(there are 25 of them). I tried all of the usuals, Request("UID1") , even
tried a loop to write out all of the form values, there was no UID1
listed (although the source from the previous page has a value for UID1),
I checked the spelling, everything! I finally got the error resolved by
refreshing the page a few times, then it worked without a hitch.

Has anyone seen anything like this? This is very troubling because it
just quits working out of the blue, no rhyme or reason (that I can tell).

Thanks,
Drew Laing


Oct 23 '06 #5
Figured it out, although I still don't understand why... my Response.Write
for the form elements on the submitting page used apostrophe's instead of
double quotes (""), I changed them to double quotes ("") and that took care
of it.

Drew

"Drew" <drewDOTlaingAT swvtc.dmhmrsas. virginia.govwro te in message
news:%2******** ********@TK2MSF TNGP05.phx.gbl. ..
>I am having an issue with an app that I built, it seems that Request.Form
doesn't want to work sometimes, and only sometimes. For instance, I got a
call last week about an error, I had the user screenshot it and email it to
me, the error was,

Microsoft OLE DB Provider for SQL Server error '80040e14'

Line 1: Incorrect syntax near '='.

/file.asp, line 158

Line 158 points to a DELETE Statement with a WHERE clause of "...WHERE UID
= " & Request.Form("U ID" & i).

This error bugged me, I couldn't figure it out because the app worked for
me. So today I get into work and find that there is another email report
of a problem. I do some troubleshooting and find that UID1 cannot be
found, I mean it is there on the submitting page, but Request.Form("U ID1")
returns nothing. The weird thing is that Request.Form("U ID2") returns the
value of UID2, as do all the other UID's (there are 25 of them). I tried
all of the usuals, Request("UID1") , even tried a loop to write out all of
the form values, there was no UID1 listed (although the source from the
previous page has a value for UID1), I checked the spelling, everything!
I finally got the error resolved by refreshing the page a few times, then
it worked without a hitch.

Has anyone seen anything like this? This is very troubling because it
just quits working out of the blue, no rhyme or reason (that I can tell).

Thanks,
Drew Laing

Oct 23 '06 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
5751
by: Sure | last post by:
Hello All, I want to update a form using the LWP & HTTP method. It was working fine when I am updating the values like this $ua = LWP::UserAgent->new; $url ='http://xxx.be/cgi-bin/viewauth/Tracking/TestProjectAgainInitialDevStory#edittable2'; use HTTP::Request::Common; my $res = $ua->request(POST $url, Content_Type =>'form-data',
4
10556
by: Pavils Jurjans | last post by:
Hallo, I am working on multilingual web-application, and I have to be very sure about how the international characters are encoded and decoded in the client-server form requests. There's a great article about the issue: http://ppewww.ph.gla.ac.uk/~flavell/charset/form-i18n.html Generally, that states that this are is filled with landmines. From my tests
5
1626
by: Wayne Wengert | last post by:
I am trying to use Request.Form to differentiate between when a page containing a form is first loaded and when it is reloaded as a result of the user clicking on the Submit button. Things are not working as expected. Some snippets of my code are: fSubmit = Request.Form("Submit1") = "Process" Response.Write("Submit1 " & Request.Form("Submit1") & "<br>") Response.Write("fSubmit: " & fSubmit & "<br>") ......
6
6885
by: Andy | last post by:
hI, wOULD PLEASE HELP ME. I AM GETTIGN THE REQUEST OBJECT ERROS ASP 0105: 80004005 INDEX OUT OF RANGE ERROR. HERE IS THE SNIPPET OF CODE THAT I AM USING. WHAT IS WRONG HERE? YOU CAN SEE WHAT I AM TRYING TO DO ADN ERROR ON THIS LINK: http://www.walani.com/ProjectFiles/01_main.asp. PLEASE HELP <% Dim iQuestions 'Holds the question
4
4297
by: Paxton | last post by:
At the risk of being told "If it ain't broke, don't fix it", my code works, but is ugly. Part of the admin site I'm working on at the moment includes a facility for users to enter Formulations (recipes for making cosmetics etc) in 3 stages: Stage 1: basic info such as title, method etc and number of Phases (steps in recipe). Stage 2: dynamically generated form containing the exact number of phases as textboxes, depending on the number...
0
2522
by: Frank 'Olorin' Rizzi | last post by:
Hello everyone. This is quite convoluted, but I'll try to make it simple. I have a couple of bottom-line questions (I guess): 1~ what happens between the Page_Load routine in the code behind of an aspx page and the presentation of the page to the user? 2~ is it true that the engine takes data from the Request.Form and puts them
6
11595
by: sck10 | last post by:
Hello, How do you use Request.Form when the first page is using a MasterPage? Thanks, sck10
0
2919
by: buntyindia | last post by:
Hi, I have a very strange problem with my application. I have developed it using Struts. I have a TextBox With Some fixed value in it and on Submit iam passing it to another page. <html:form action="/login"> <html:text property="userName" value="Bunty"/> <html:submit/>
0
8762
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9265
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9125
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9018
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7878
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5923
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4435
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3127
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2463
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.