473,325 Members | 2,712 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

'request' help

I have a form which shows all Records from a database
eg.
select * from sometable

the user inputs criteria in a form on the sam page and submits it.
i need to see if the form has been submited. and the way to do it is to
see if i have 'Request.form(somefield)' and then refrase the sql into
something like

select *from table where something=this and somethingelse=this
my problem is that i have to check every form field to see if it has been
set(not empty).
Is there a way to see this without checking every form field???
Oct 26 '05 #1
5 1315
> Is there a way to see this without checking every form field???

Yes, simply apply the same methodology you use to see if there's any beer in
your refrigerator without opening the door.

Bob Lehmann

"polilop" <fm******@inet.hr> wrote in message
news:eV**************@TK2MSFTNGP12.phx.gbl...
I have a form which shows all Records from a database
eg.
select * from sometable

the user inputs criteria in a form on the sam page and submits it.
i need to see if the form has been submited. and the way to do it is to
see if i have 'Request.form(somefield)' and then refrase the sql into
something like

select *from table where something=this and somethingelse=this
my problem is that i have to check every form field to see if it has been
set(not empty).
Is there a way to see this without checking every form field???

Oct 26 '05 #2
Bob Lehmann wrote on 26 okt 2005 in
microsoft.public.inetserver.asp.general:
Is there a way to see this without checking every form field???


Yes, simply apply the same methodology you use to see if there's any
beer in your refrigerator without opening the door.


Look to see if there is a note on the door saying:
"We're out of beer, your're out of luck, be out of here"?

--
Evertjan.
The Netherlands.
(Replace all crosses with dots in my emailaddress)

Oct 26 '05 #3

"Evertjan." <ex**************@interxnl.net> wrote in message
news:Xn********************@194.109.133.242...
Bob Lehmann wrote on 26 okt 2005 in
microsoft.public.inetserver.asp.general:
Is there a way to see this without checking every form field???


Yes, simply apply the same methodology you use to see if there's any
beer in your refrigerator without opening the door.


Look to see if there is a note on the door saying:
"We're out of beer, your're out of luck, be out of here"?


No, no, no. That requires effort. It is so much easier to yell from the
comfort of the reclining chair, "Honey, get me a beer."
Oct 26 '05 #4
polilop wrote:
I have a form which shows all Records from a database
eg.
select * from sometable
You should avoid doing this:
http://www.aspfaq.com/show.asp?id=2096

the user inputs criteria in a form on the sam page and submits it.
i need to see if the form has been submited. and the way to do it is
to see if i have 'Request.form(somefield)' and then refrase the sql
into something like

select *from table where something=this and somethingelse=this
Doesn't your table have a primary key??
my problem is that i have to check every form field to see if it has
been set(not empty).
Is there a way to see this without checking every form field???


Sure. Use some client-side code in the form's onsubmit event to populate a
hidden field to indicate whether or not the form's data has been changed.
That will allow you to only check a single field in your server-side code to
see if you need to process the form's data. Of course, you will also need to
fall back to checking all the fields in the event that the client has
client-side scripting disabled.

If you need help writing the client-side code, post to a client-side
scripting newsgroup such as microsoft.public.scripting.jscript.

HTH,
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Oct 26 '05 #5
Evertjan. wrote:
Bob Lehmann wrote on 26 okt 2005 in
microsoft.public.inetserver.asp.general:
Is there a way to see this without checking every form field???


Yes, simply apply the same methodology you use to see if there's any
beer in your refrigerator without opening the door.


Look to see if there is a note on the door saying:
"We're out of beer, your're out of luck, be out of here"?

:-)
Funny, but this is pretty much what i suggested when I suggested that he use
a hidden form field.
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Oct 26 '05 #6

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

Similar topics

0
by: ThisIsMe | last post by:
I am using this php email form and it seems to work. But I would like for the option for attn$ Webmaster to go to a different email address than the mymail$ Please be Kind to us newbies... can...
8
by: turnit \(removethis\) | last post by:
I have a login form that uses the post method to carry the information to the next page. The form works just fine in ie6.0, but fails in mozilla and fails in ie5.2 on a mac. "HTTP/1.1 400 Bad...
2
by: RobertHillEDS | last post by:
While using the Soap generated ASP code, I would like to dump the raw contents of the request and response objects using Response.AppendToLog. I have tried using variations of the following code,...
6
by: Ammar | last post by:
Dear All, I'm facing a small problem. I have a portal web site, that contains articles, for each article, the end user can send a comment about the article. The problem is: I the comment length...
4
by: Nalaka | last post by:
Hi, I have some request specific data that gets created in a "early event", that I need to pass around to many other events. I need access to this data during that request. (and more importantly...
2
by: Gregory Piñero | last post by:
Hi Guys, Does anyone know how to program a Python script to send out emails with a request delivery receipt? Is it something I can build into the email message via the mime stuff? And yes, I...
4
by: Michael Kujawa | last post by:
I am using the following to create an SQL statement using the names and values from request.form. The loop goes through each item in request.form The issue comes in having an additional "and" at...
2
by: Arti | last post by:
Hi, I am trying to access a servlet hosted on Tomcat server using HTTPS Post protocol. I am getting the exception: "The underlying connection was closed: Could not establish trust relationship...
3
by: Joseph Geretz | last post by:
I'm using the Request Filter documentation which can be found here: http://msdn.microsoft.com/en-us/library/system.web.httprequest.filter.aspx In this example, two filters are installed, one...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.