DaniWeb Forum Index > Web Development > ASP

string not working

Please support our ASP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: May 2004

Posts: 4

Reputation: squirrelj is an unknown quantity at this point

Solved Threads: 0

squirrelj

Offline

Newbie Poster

string not working

May 21st, 2004

I have the following checkbox on my site but it dosen't work, tried to solve it before but still having trouble.

this is the code from my first page

<P>Do you want to take pets with you?
<INPUT type=CHECKBOX name = "PETS" value = "Y">Yes<br>

This is the code from my second page

IF strPETS = "Y" THEN strSQLLOC = strSQLLOC & " AND fldPETS = 'Y' " ELSE strSQLLOC = strSQLLOC

Please help!!!

•

Join Date: Feb 2002

Posts: 1,135

Reputation: samaru is just really nice

Solved Threads: 6

samaru

Offline

a.k.a inscissor

Re: string not working

May 24th, 2004

•

Originally Posted by squirrelj

I have the following checkbox on my site but it dosen't work, tried to solve it before but still having trouble.

this is the code from my first page

<P>Do you want to take pets with you?
<INPUT type=CHECKBOX name = "PETS" value = "Y">Yes<br>

This is the code from my second page

IF strPETS = "Y" THEN strSQLLOC = strSQLLOC & " AND fldPETS = 'Y' " ELSE strSQLLOC = strSQLLOC

Please help!!!

You're not capturing the value from the HTML form's checkbox. If you have a form with a checkbox name "PETS" then in your ASP script, you have to use Response.Form("PETS") to capture the value "Y" - this is only if the method of the form is "POST" - anyways, try this:

 Help with Code Tags 
 ASP Syntax (Toggle Plain Text) 
<%
 
IF request.form("PETS") = "Y" THEN 
strSQLLOC = strSQLLOC & " AND fldPETS = 'Y' " 
response.write("YOU CHECKED THE BOX")
ELSE 
strSQLLOC = strSQLLOC
response.write("BOX NOT CHECKED")
end if
 
%>
<%
 
IF request.form("PETS") = "Y" THEN 
strSQLLOC = strSQLLOC & " AND fldPETS = 'Y' " 
response.write("YOU CHECKED THE BOX")
ELSE 
strSQLLOC = strSQLLOC
response.write("BOX NOT CHECKED")
end if
 
%>

•

Join Date: Feb 2003

Posts: 793

Reputation: Paladine has a spectacular aura about

Solved Threads: 27

Paladine

Offline

Master Poster

Re: string not working

May 24th, 2004

Is a checkbox really sending a string value or is it not a boolen value?

Assistant Manager, Pharmacy Informatics
Wordpress Learning Blog
Updated : ASP.Net Login Code

•

Join Date: Jul 2004

Posts: 32

Reputation: RobUK is an unknown quantity at this point

Solved Threads: 1

RobUK

Offline

Light Poster

Re: string not working

Jul 13th, 2004

Actually, it's a string value, and so is everything send via an HTTP GET or POST.

It is up to you, the developer to cast the strings to explicit types.

You must assign the value of the posted form field to your variable, strpets.
Either that, or do this:

 Help with Code Tags 
 ASP Syntax (Toggle Plain Text) 
IF request.form("PETS") = "Y" THEN strSQLLOC = strSQLLOC & " AND fldPETS = 'Y' "
IF request.form("PETS") = "Y" THEN strSQLLOC = strSQLLOC & " AND fldPETS = 'Y' "