navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

 

Check Box Multi Select Search

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP and Database >> Check Box Multi Select Search 		Page: [1]
 
nettop

 

Posts: 212
Joined: 2/9/2004
Status: offline

  		Check Box Multi Select Search - 11/11/2005 16:56:39   
Hi:

I'm trying to create a Check Box, multi select function. Only the single check per field works. Please check it out at http://www.paramountbusinessbrokers.com/listings/default.asp . Here's the current code. Thanks, Tim 
<html>
<head>
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Current Listings</title>
<meta name="Microsoft Border" content="tb">
</head>
<body>
<%
strOddColor = "bgcolor='#FFFFFF'"
strEvenColor = "bgcolor='#DCCFC3'"
intLineNum = 0
%>
<form BOTID="0" METHOD="POST" action="default.asp">
	<input type="hidden" name="fpdbr_0_PagingMove" value="  |<  ">
	<table BORDER="0" width="464">
		<tr>
			<td> </td>
			<td><input type="checkbox" name="Search_ALL" value="ON"> <b>SEARCH 
			ALL</b></td>
		</tr>
		<tr>
			<td><b>Type</b></td>
			<td><input type="checkbox" name="Type" value="Auto Related">
			<font face="Arial" size="2">Auto Related</font> <br>
			<input type="checkbox" name="Type" value="Business Services">
			<font face="Arial" size="2">Business Services</font> <br>
			<input type="checkbox" name="Type" value="Personal Services">
			<font face="Arial" size="2">Personal Services</font> <br>
			<input type="checkbox" name="Type" value="Restaurant">
			<font face="Arial" size="2">Restaurant<br>
			</font>
			<input type="checkbox" name="Type" value="Restaurant Related"><font face="Arial" size="2"> 
			Restaurant Related<br>
			</font><input type="checkbox" name="Type" value="Retail"><font face="Arial" size="2"> 
			Retail</font>  </td>
		</tr>
		<tr>
			<td><b>Area</b></td>
			<td><font face="Arial" size="2">
			<input type="checkbox" name="Area" value="Greater Sacramento Area"> 
			Greater Sacramento Area</font>  <br>
			<font face="Arial" size="2">
			<input type="checkbox" name="Area" value="Sierra Foothills - Auburn Area"></font>
			<font face="Arial" size="2">Sierra Foothills - Auburn Area</font>
			<br>
			<font face="Arial" size="2">
			<input type="checkbox" name="Area" value="Sierra Foothills - Grass Valley Area"> 
			Sierra Foothills - Grass Valley Area</font> <br>
			<font face="Arial" size="2">
			<input type="checkbox" name="Area" value="Sierra Foothills - I-80 and Hwy 49"></font>
			<font face="Arial" size="2">Sierra Foothills - I-80 and Hwy 49</font></td>
		</tr>
	</table>
	<br>
	<input TYPE="Submit"><input TYPE="Reset"><p> </p>
</form>
<p align="center"><b><font color="#111111" size="6" face="Arial">BUSINESSES FOR SALE</font></b></p>
<table width="100%" border="1" cellspacing="0" bordercolor="#26265F">
  <thead>
    <tr>
      <th bgcolor="#DCCFC3"><b><font face="Arial" size="2">Listing #</font></b></th>
      <th bgcolor="#DCCFC3"><font face="Arial" size="2"><b>Description
      <font color="#ff0000">(click to view details)</font></b></font></th>
      <td align="center" bgcolor="#DCCFC3"><font face="Arial" size="2"><b>Type</b></font></td>
      <td align="center" bgcolor="#DCCFC3"><font face="Arial" size="2"><b>
      Area</b></font></td>
      <td align="center" bgcolor="#DCCFC3"><font face="Arial" size="2"><b>Price</b></font></td>
      <td align="center" bgcolor="#DCCFC3"><font face="Arial" size="2"><b>Status</b></font></td>
         </tr>
  </thead>
  <tbody>
 <!--#include file="../_fpclass/fpdblib.inc"-->
<% if 0 then %>
<% end if %>
<%
fp_sQry="SELECT * FROM Results WHERE (Type like  '::Type::' AND Area like '::Area::') ORDER BY ID DESC"
fp_sDefault="Type=%&Area=%"
fp_sNoRecords="<tr><td colspan=6 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="listings"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=50
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&ID=3&_1_description_and_price=202&Business_name=202&Street_Address=202&City=202&State=202&Zip=202&Type=202&_2_Area=202&Detailed_Description=203&Ownership_Structure=202&_4_Employees=202&_5_Year_Established=202&_6_Seats=202&_7_Parking=202&_8_Licenses_Required=202&_9_Hrs_Open=202&_10_Sq_Ft_Size=202&_11_Lease_Term=202&_12_Lease_Options=202&_13_Base_Rent=202&_14_Last_Years_Annual_Gross=202&_15_Annual_Adjusted_Net_Profit=202&_16_COGS=202&_17_Inventory=202&Remote_computer_name=202&User_name=202&Browser_type=202&Timestamp=135&Misc_1=202&Misc_2=202&Misc_3=202&Misc_4=3&Operation_Desc_1=202&MiscO9=202&MiscO10=202&Payroll_detailF4=202&Misc1F8=202&Misc2F9=202&Misc3F10=202&Misc_31=203&photo1_sm=202&photo1_lg=202&photo2_sm=202&photo2_lg=202&photo3_sm=202&photo3_lg=202&photo4_sm=202&photo4_lg=202&photo5_sm=202&photo5_lg=202&photo6_sm=202&photo6_lg=202&photo7_sm=202&photo7_lg=202&photo8_sm=202&photo8_lg=202&Owners_First_Name=202&Owners_Last_Name=202&Owners_Mailing_Address=202&Owners_City=202&Owners_State=202&Owners_Zip=202&Owners_Home_Phone=202&Owners_Cell_Phone=202&Owners_Fax=202&Owners_Email1=202&Owners_Email2=202&Area=202&Misc_5=202&"
fp_iDisplayCols=6
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<%
intLineNum = intLineNum + 1
If intLineNum Mod 2 = 0 Then
strLineColor = strEvenColor
Else
strLineColor = strOddColor
End If
%>
<tr <%=strLineColor%>>   
      <td><font size="2" face="Arial"><%=FP_FieldVal(fp_rs,"ID")%></font></td> 
      <td><font size="2" face="Arial"> <a href="detail.asp?ID=<%=FP_FieldURL(fp_rs,"ID")%>"><%=FP_FieldVal(fp_rs,"_1_description_and_price")%></font></td>
      <td><font size="2" face="Arial"><%=FP_FieldVal(fp_rs,"Type")%></font></td>
      <td><font size="2" face="Arial"><%=FP_FieldVal(fp_rs,"Area")%></font></td>
      <td><font size="2" face="Arial"><align="right"><%=FormatCurrency(FP_FieldVal(fp_rs,"Misc_4"),0)%></font></td>
      <td><font size="2" face="Arial"><%=FP_FieldVal(fp_rs,"Misc_2")%></font></td>
    </tr>
<!--#include file="../_fpclass/fpdbrgn2.inc"-->
</tbody>
</table>
</body>
</html>


< Message edited by Spooky -- 11/11/2005 19:48:45 >
rdouglass

 

Posts: 9280
From: Biddeford, ME USA
Status: offline

  		RE: Check Box Multi Select Search - 11/11/2005 21:32:11   
quote:

Type like '::Type::'


A coupla' things I can see. First is generally speaking, you'd use the LIKE command with the wildcard "%" like so:

Type like '%::Type::%'

where that would be equivalent to "contains". And

Type like '%::Type::'
Type like '::Type::%'

would be begins with and ends with respectively.

Now the second part of your issue (if you want to select multiple elements) is the inherent limitations of the DRW as I see it. The problem is, lets say we want to include 2 of the "Type" checkboxes. We'd need the SQL statement to look like:

(Type like '%::Type::%') OR (Type like '%::Type::%')

and so we'd need to separate the two returned values and create the SQL on the fly. :) Not difficult if you're comfortable with ASP but there is, IMO, an easier way. I'd suggest changing the checkbox values to some kind of numerical values. For instance, if you keep the checkbox values in a database table and use the ID's of the records (the checkbox items), then you can do something like:

Type IN ::Type::

To me, a whole lot simpler. Of course, you'd need the numerical value in the records being searched instead of the text values but you should probably do that / have done that to normalize your database anyways.

Did that help or confuse? Do you think the numeric approach is feasable or are you up to a big ASP exersize in building SQL dynamically?

Hope that helps.

_____________________________

Don't take you're eye off your final destination.

ASP Checkbox Function Tutorial.

(in reply to nettop)
nettop

 

Posts: 212
Joined: 2/9/2004
Status: offline

  		RE: Check Box Multi Select Search - 11/16/2005 9:19:40   
I like your idea to add values to the types. I will have to add that field to the database. I'll give it a try and get back to you as I'm sure I'll have some further questions/challenges with that. Thanks, Tim

(in reply to rdouglass)
nettop

 

Posts: 212
Joined: 2/9/2004
Status: offline

  		RE: Check Box Multi Select Search - 12/4/2005 2:22:35   
Well, I've updated the database by reconstructing it and adding a few new fields with area_number and type_number to allow for searching with check boxes in a simpler manner as you've described. I've added form elements, but can't get them to work. The page is at http://www.paramountbusinessbrokers.com/12_default.asp (but it currently gives an error) and here's the code so far (Thanks for your help, Tim): 

<table border="0" width="100%">
<tr>
<td width="1%" align="left" valign="top"> </td>
<td width="72%" align="left" valign="top">
<p align="center"><b><font color="#111111" size="6" face="Arial">BUSINESSES FOR SALE</font></b></p>
</td>
</tr>
</table>
<p></p>
</div>
</form>

		<div align="center">
			<form BOTID="0" METHOD="POST" action="12_default.asp">
				<input type="hidden" name="fpdbr_0_PagingMove" value="  |<  ">
				<table BORDER="0" width="95%">
					<tr>
						<td><b>Search Areas</b></td>
						<td>
						<input type="checkbox" name="Area_Number" value="<%=Server.HtmlEncode(Request("Area_Number='1'"))%>">Grass 
						Valley/Nevada City Areas<br>
						<input type="checkbox" name="Area_Number" value="<%=Server.HtmlEncode(Request("Area_Number='2'"))%>">Auburn 
						Area<br>
						<input type="checkbox" name="Area_Number" value="<%=Server.HtmlEncode(Request("Area_Number='3'"))%>">Greater 
						Sacramento Area<br>
						<input type="checkbox" name="Area_Number" value="<%=Server.HtmlEncode(Request("Area_Number=%"))%>">All 
						Areas</td>
					</tr>
					<tr>
						<td><b>Search by Business Types</b></td>
						<td>
						<input type="checkbox" name="Type_Number" value="<%=Server.HtmlEncode(Request("Type_Number='1'"))%>">  
						Manufacturing<br>
						<input type="checkbox" name="Type_Number" value="<%=Server.HtmlEncode(Request("Type_Number='2'"))%>">  
						Service Related<br>
						<input type="checkbox" name="Type_Number" value="<%=Server.HtmlEncode(Request("Type_Number='3'"))%>">  
						Retail-Related<br>
						<input type="checkbox" name="Type_Number" value="<%=Server.HtmlEncode(Request("Type_Number='4'"))%>">  
						Wholesale/Distribution<br>
						<input type="checkbox" name="Type_Number" value="<%=Server.HtmlEncode(Request("Type_Number='5'"))%>">  
						Restaurant/Food Service<br>
						<input type="checkbox" name="Type_Number" value="<%=Server.HtmlEncode(Request("Type_Number='6'"))%>">  
						Auto Related<br>
						<input type="checkbox" name="Type_Number" value="<%=Server.HtmlEncode(Request("Type_Number='7'"))%>">  
						Constructions Related<br>
						<input type="checkbox" name="Type_Number" value="<%=Server.HtmlEncode(Request("Type_Number='8'"))%>">  
						Markets/Grocery/Liquor<br>
						<input type="checkbox" name="Type_Number" value="<%=Server.HtmlEncode(Request("Type_Number='9'"))%>">  
						Hotels/Motels/B&B’s<br>
</td>
					</tr>
				</table>
				<br>
				<input TYPE="Submit"><input TYPE="Reset"></form>
			<table width="100%" border="1">
				<thead>
					<tr>
						<th ALIGN="LEFT"><b>ID</b></th>
						<th ALIGN="LEFT"><b>Description_and_price</b></th>
						<th ALIGN="LEFT"><b>Type</b></th>
						<th ALIGN="LEFT"><b>Area</b></th>
						<th ALIGN="LEFT"><b>Price</b></th>
						<th ALIGN="LEFT"><b>Status</b></th>
					</tr>
				</thead>
				<tbody>
<!--#include file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<% end if %>
<%
fp_sQry="SELECT * FROM Results WHERE (Area_Number IN ::Area_Number:: AND Type_Number IN ::Type_Number::) ORDER BY ID DESC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=6 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="listings12"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=10
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&ID=3&Description_and_price=202&Business_name=202&Street_Address=202&City=202&State=202&Zip=202&Detailed_Description=203&Ownership_Structure=202&Type=202&Type_Number=3&Price=202&Area=202&Area_Number=3&Status=202&Status_Number=3&Page=202&Revenues=202&Adjusted_Net=202&Misc1=202&Misc2=202&Misc3=202&Misc4=202&Profile=202&Financial=202&Photos=202&CA=202&photo1_sm=202&photo1_lg=202&photo2_sm=202&photo2_lg=202&photo3_sm=202&photo3_lg=202&photo4_sm=202&photo4_lg=202&photo5_sm=202&photo5_lg=202&photo6_sm=202&photo6_lg=202&photo7_sm=202&photo7_lg=202&photo8_sm=202&photo8_lg=202&Owners_First_Name=202&Owners_Last_Name=202&Owners_Mailing_Address=202&Owners_City=202&Owners_State=202&Owners_Zip=202&Owners_Home_Phone=202&Owners_Cell_Phone=202&Owners_Fax=202&Owners_Email1=202&Owners_Email2=202&Timestamp=135&"
fp_iDisplayCols=6
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<tr>
						<td>
<%=FP_FieldVal(fp_rs,"ID")%></td>
						<td>
<%=FP_FieldVal(fp_rs,"Description_and_price")%></td>
						<td>
<%=FP_FieldVal(fp_rs,"Type")%></td>
						<td>
<%=FP_FieldVal(fp_rs,"Area")%></td>
						<td>
<%=FP_FieldVal(fp_rs,"Price")%></td>
						<td>
<%=FP_FieldVal(fp_rs,"Status")%></td>
					</tr>
<!--#include file="_fpclass/fpdbrgn2.inc"-->
</tbody>
			</table>


< Message edited by Spooky -- 12/4/2005 3:30:25 >

(in reply to nettop)
BeTheBall

 

Posts: 6381
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: Check Box Multi Select Search - 12/4/2005 16:36:45   
You need parenthesis around whatever comes after IN. See if this helps any?

fp_sQry="SELECT * FROM Results WHERE (Area_Number IN (::Area_Number::) AND Type_Number IN (::Type_Number::)) ORDER BY ID DESC"

_____________________________

Duane

Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.

(in reply to nettop)
nettop

 

Posts: 212
Joined: 2/9/2004
Status: offline

  		RE: Check Box Multi Select Search - 12/4/2005 18:00:51   
I have made your suggested change. Still not fixed. Do I have my selections right for each of the checkboxes. Here's a couple of examples of what I have for the field 'Type_Number':

<input type="checkbox" name="Type_Number1" value="<%=Server.HtmlEncode(Request("Type_Number='1'"))%>"> 
Manufacturing<br>
<input type="checkbox" name="Type_Number2" value="<%=Server.HtmlEncode(Request("Type_Number='2'"))%>"> 
Service Related<br>

Should it be something more like this???:

<input type="checkbox" name="Type_Number1" value="1"))%>"> Manufacturing<br>
<input type="checkbox" name="Type_Number2" value="2"))%>"> 
Service Related<br>

(in reply to BeTheBall)
nettop

 

Posts: 212
Joined: 2/9/2004
Status: offline

  		RE: Check Box Multi Select Search - 12/5/2005 9:38:54   
I was thinking about this some more. Should it be something more like this, where the name is just 'Type_Number', since that's what's in the query??? Thanks, Tim:

<input type="checkbox" name="Type_Number" value="1"))%>"> Manufacturing<br>
<input type="checkbox" name="Type_Number" value="2"))%>">
Service Related<br>

(in reply to nettop)
rdouglass

 

Posts: 9280
From: Biddeford, ME USA
Status: offline

  		RE: Check Box Multi Select Search - 12/5/2005 9:49:24   
quote:

Should it be something more like this


That's how you should do it if you're using the IN clause as above. At least IMO.

_____________________________

Don't take you're eye off your final destination.

ASP Checkbox Function Tutorial.

(in reply to nettop)
BeTheBall

 

Posts: 6381
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: Check Box Multi Select Search - 12/5/2005 10:41:26   
quote:

<input type="checkbox" name="Type_Number" value="1"))%>"> Manufacturing<br>
<input type="checkbox" name="Type_Number" value="2"))%>">
Service Related<br>


You wouldn't want the script delimiter in there (%>). More like this:

<input type="checkbox" name="Type_Number" value="1"> Manufacturing<br>
<input type="checkbox" name="Type_Number" value="2">
Service Related<br>

_____________________________

Duane

Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.

(in reply to rdouglass)
nettop

 

Posts: 212
Joined: 2/9/2004
Status: offline

  		RE: Check Box Multi Select Search - 12/5/2005 23:40:52   
That works now when I happen to select the right grouping...for example, 'Retail Related' and 'Grass Valley Area'. Check it out at:

What needs to be edited to get 'ALL LISTINGS' to show up by default?

Thanks, Tim 

<form BOTID="0" METHOD="POST" action="12_default.asp">
				<input type="hidden" name="fpdbr_0_PagingMove" value="  |<  ">
				<div align="center">
					<table border="2" width="98%" cellspacing="0" bordercolor="#111111">
						<tr>
							<td>
							<div align="center">
								<table border="0" width="96%" cellspacing="0">
									<tr>
										<td align="left" valign="top" colspan="2">
										<font face="Arial"><b>SEARCH OUR 
										BUSINESSES FOR SALE LISTINGS.</b>
										<font size="2"> Just check the 
										boxes that fit your type and location of 
										business, and then press the “Search” 
										button.</font></font></td>
									</tr>
									<tr>
										<td align="left" valign="top"> </td>
										<td align="left" valign="top"> </td>
									</tr>
									<tr>
										<td align="left" valign="top"><b>Search by Business Types<br>
										</b>
										
						<input type="checkbox" name="Type_Number" value="1"> Manufacturing<br>
						<input type="checkbox" name="Type_Number" value="2">Service Related<br>
						<input type="checkbox" name="Type_Number" value="3">Retail-Related<br>
						<input type="checkbox" name="Type_Number" value="4">Wholesale/Distribution<br>
						<input type="checkbox" name="Type_Number" value="5">Restaurant/Food Service<br>
						<input type="checkbox" name="Type_Number" value="6">Auto Related<br>
						<input type="checkbox" name="Type_Number" value="7">Constructions Related<br>
						<input type="checkbox" name="Type_Number" value="8">Markets/Grocery/Liquor<br>
						<input type="checkbox" name="Type_Number" value="9">Hotels/Motels/B&B’s</td>
										<td align="left" valign="top"><b>Search Areas<br>
										</b>
						<input type="checkbox" name="Area_Number" value="1">Grass Valley/Nevada City Areas<br>
						<input type="checkbox" name="Area_Number" value="2">Auburn Area<br>
						<input type="checkbox" name="Area_Number" value="3">Greater Sacramento Area<br>
<p> </p>
										<p><br>
				<input TYPE="submit" value="Search"></td>
									</tr>
								</table>
							</div>
							</td>
						</tr>
					</table>
				</div>
</form>
			<table width="100%" border="1" cellspacing="0" bordercolor="#111111">
				<thead>
					<tr>
						<th ALIGN="LEFT"><font face="Arial" size="2"><b>ID</b></font></th>
						<th ALIGN="LEFT"><font face="Arial" size="2"><b>Description</b></font></th>
						<th ALIGN="LEFT"><font face="Arial" size="2"><b>Type</b></font></th>
						<th ALIGN="LEFT"><font face="Arial" size="2"><b>Area</b></font></th>
						<th ALIGN="LEFT"><font face="Arial" size="2"><b>Price</b></font></th>
						<th ALIGN="LEFT"><font face="Arial" size="2"><b>Status</b></font></th>
					</tr>
				</thead>
				<tbody>
<!--#include file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<% end if %>
<%
fp_sQry="SELECT * FROM Results WHERE (Area_Number IN (::Area_Number::) AND Type_Number IN (::Type_Number::)) ORDER BY ID DESC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=6 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="listings12"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=10
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&ID=3&Description_and_price=202&Business_name=202&Street_Address=202&City=202&State=202&Zip=202&Detailed_Description=203&Ownership_Structure=202&Type=202&Type_Number=3&Price=202&Area=202&Area_Number=3&Status=202&Status_Number=3&Page=202&Revenues=202&Adjusted_Net=202&Misc1=202&Misc2=202&Misc3=202&Misc4=202&Profile=202&Financial=202&Photos=202&CA=202&photo1_sm=202&photo1_lg=202&photo2_sm=202&photo2_lg=202&photo3_sm=202&photo3_lg=202&photo4_sm=202&photo4_lg=202&photo5_sm=202&photo5_lg=202&photo6_sm=202&photo6_lg=202&photo7_sm=202&photo7_lg=202&photo8_sm=202&photo8_lg=202&Owners_First_Name=202&Owners_Last_Name=202&Owners_Mailing_Address=202&Owners_City=202&Owners_State=202&Owners_Zip=202&Owners_Home_Phone=202&Owners_Cell_Phone=202&Owners_Fax=202&Owners_Email1=202&Owners_Email2=202&Timestamp=135&"
fp_iDisplayCols=6
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<tr>
						<td>
<font face="Arial" size="2">
<%=FP_FieldVal(fp_rs,"ID")%></font></td>
						<td>
<font face="Arial" size="2">
<%=FP_FieldVal(fp_rs,"Description_and_price")%></font></td>
						<td>
<font face="Arial" size="2">
<%=FP_FieldVal(fp_rs,"Type")%></font></td>
						<td>
<font face="Arial" size="2">
<%=FP_FieldVal(fp_rs,"Area")%></font></td>
						<td>
<font face="Arial" size="2">
<%=FP_FieldVal(fp_rs,"Price")%></font></td>
						<td>
<font face="Arial" size="2">
<%=FP_FieldVal(fp_rs,"Status")%></font></td>
					</tr>
<!--#include file="_fpclass/fpdbrgn2.inc"-->


< Message edited by Spooky -- 12/5/2005 23:58:58 >

(in reply to BeTheBall)
Spooky

 

Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: Check Box Multi Select Search - 12/6/2005 0:33:31   
By default, do you mean when the page is first visited show all records?

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to nettop)
nettop

 

Posts: 212
Joined: 2/9/2004
Status: offline

  		RE: Check Box Multi Select Search - 12/6/2005 0:47:16   
Yes.

The second issue is that I need a search return value to show 'No Records Match Your Search Critieria, Please Try Again' if they select something that is not in the database.

Thanks, Tim

(in reply to Spooky)
Spooky

 

Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: Check Box Multi Select Search - 12/6/2005 2:16:56   
Isnt this what you mean?

http://www.frontpagewebmaster.com/m-302654/tm.htm

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to nettop)
nettop

 

Posts: 212
Joined: 2/9/2004
Status: offline

  		RE: Check Box Multi Select Search - 12/6/2005 9:54:41   
So this would replace the

fp_sQry="SELECT * FROM Results WHERE (Area_Number IN (::Area_Number::) AND Type_Number IN (::Type_Number::)) ORDER BY ID DESC"

row? Thanks, Tim

(in reply to Spooky)
BeTheBall

 

Posts: 6381
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: Check Box Multi Select Search - 12/6/2005 13:52:06   
Does adding default values solve it? For example:

fp_sDefault="Type_Number=1,2,3,4,5,6,7,8,9&AreaNumber=1,2,3"

_____________________________

Duane

Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.

(in reply to nettop)
nettop

 

Posts: 212
Joined: 2/9/2004
Status: offline

  		RE: Check Box Multi Select Search - 12/6/2005 20:45:19   
YES, you are BRILLIANT!!! Check it out at http://www.paramountbusinessbrokers.com/12_default.asp and note that it works GREAT!!!! Thanks so much, Tim

(in reply to BeTheBall)
nettop

 

Posts: 212
Joined: 2/9/2004
Status: offline

  		RE: Check Box Multi Select Search - 12/6/2005 20:46:13   
Do you have any suggestions on adding a 'Select All' checkbox and a 'DeSelect All' checkbox to this page? Thanks, Tim

(in reply to nettop)
BeTheBall

 

Posts: 6381
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: Check Box Multi Select Search - 12/6/2005 23:00:35   
You will need to do that in javascript.

Here's one:

http://www.shiningstar.net/articles/articles/javascript/checkboxes.asp?ID=AW

Here's another:

http://javascript.internet.com/forms/check-all-toggle-switch.html

If neither of these meet your needs, do a google on javascript check all.

_____________________________

Duane

Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.

(in reply to nettop)
BeTheBall

 

Posts: 6381
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: Check Box Multi Select Search - 12/6/2005 23:06:23   
One other little tip. It is a bit annoying that one has to scroll down to see the results of the search. To remedy this, change this line:

<form BOTID="0" METHOD="POST" action="12_default.asp">

to:

<form BOTID="0" METHOD="POST" action="12_default.asp#results">

Then edit these lines:

<input TYPE="Submit"><input TYPE="Reset"></form>
<table width="100%" border="1">

to:

<input TYPE="Submit"><input TYPE="Reset"></form>
<a name="results"></a>
<table width="100%" border="1">

That should cause the page to jump to the results when the form is submitted.

_____________________________

Duane

Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.

(in reply to BeTheBall)
Page:   [1]

All Forums >> Web Development >> ASP and Database >> Check Box Multi Select Search 		Page: [1]
Jump to: 1





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts


Back to top

  Microsoft Corporation in no way endorses or is affiliated with "OutFront."
  OutFront is published and edited by Thomas Brunt.
  440 Great Circle Dr., St. Matthews, SC 29135.
  © 2008 All Rights Reserved
  Click here to view our privacy statement.