ASP Search Result

V

vdvalsit

I am trying to sort a page. I use Frontpage 2003 and use Access DB.
http://www.vdvalist.com/locate.asp I would like to have a person first
select by Zip than by category. What I am trying to do is see if there is a
way when a person selects the Zip if I can give them only the choices that
are available for that zip in Category. As it stands if you don't know what
catagory is in what zip it gives you a "no records found".

Any help will be greatly appreciated.
 
D

Don

You Might want to check out
http://www.spiderwebwoman.com/tutorials/doubledropdown.htm

HTH

Don
=============================
|I am trying to sort a page. I use Frontpage 2003 and use Access DB.
| http://www.vdvalist.com/locate.asp I would like to have a person first
| select by Zip than by category. What I am trying to do is see if there is
a
| way when a person selects the Zip if I can give them only the choices
that
| are available for that zip in Category. As it stands if you don't know
what
| catagory is in what zip it gives you a "no records found".
|
| Any help will be greatly appreciated.
 
V

vdvalsit

I've try this solution, but my seach page now shows all listings regardless
of which dropdowns I select.
 
D

Don

Hummmm...

You should only be presented with one dropdown at a time..

What does the query look like??

Don
======================
| I've try this solution, but my seach page now shows all listings
regardless
| of which dropdowns I select.
|
| "Don" wrote:
|
| > You Might want to check out
| > http://www.spiderwebwoman.com/tutorials/doubledropdown.htm
| >
| > HTH
| >
| > Don
| > =============================
| > | > |I am trying to sort a page. I use Frontpage 2003 and use Access DB.
| > | http://www.vdvalist.com/locate.asp I would like to have a person
first
| > | select by Zip than by category. What I am trying to do is see if
there is
| > a
| > | way when a person selects the Zip if I can give them only the
choices
| > that
| > | are available for that zip in Category. As it stands if you don't
know
| > what
| > | catagory is in what zip it gives you a "no records found".
| > |
| > | Any help will be greatly appreciated.
| >
| >
| >
 
D

Don

See if this Helps you some...

http://www.xmas-i-am.com/how_to_filter_drop-down.htm

This is just sorting to a drop-down and then to a table but if you can get
it this far-- you will then see on the second page, (that in page 4 of the
wizard) you can just select another drop-down and then the next page you can
use the table...

One of the key things is using a custom query..

SELECT* FROM Sample (TO)
SELECT DISTINCT Order FROM Sample

In the custom Query

Clear as mud...

HTH

Don
==========================
| Hummmm...
|
| You should only be presented with one dropdown at a time..
|
| What does the query look like??
|
| Don
| ======================
| || I've try this solution, but my seach page now shows all listings
| regardless
|| of which dropdowns I select.
||
|| "Don" wrote:
||
|| > You Might want to check out
|| > http://www.spiderwebwoman.com/tutorials/doubledropdown.htm
|| >
|| > HTH
|| >
|| > Don
|| > =============================
|| > || > |I am trying to sort a page. I use Frontpage 2003 and use Access DB.
|| > | http://www.vdvalist.com/locate.asp I would like to have a person
| first
|| > | select by Zip than by category. What I am trying to do is see if
| there is
|| > a
|| > | way when a person selects the Zip if I can give them only the
| choices
|| > that
|| > | are available for that zip in Category. As it stands if you don't
| know
|| > what
|| > | catagory is in what zip it gives you a "no records found".
|| > |
|| > | Any help will be greatly appreciated.
|| >
|| >
|| >
|
|
 
V

vdvalsit

The one on your site works great. But on my site it seems that the "Posting"
doesn't work. For instance I choose zip code 94080 on first page. When I go
to next page it shows Network Systesm in first choice and 94015 in zip. In
zip 94080 I only have 1 category "supplier".

Shouldn't page 2 show Suppler in first choice and show "94080" in the second
block?
 
V

vdvalsit

I followed your script, but I notice in FP03 you can't do much editing, due
to the webbots. I printed out your script and compaired it to what comes out
on my site they seem to be the same.
This is locatepro1 script:
<form method="POST" action="locatepro2.asp">
<p align="left">
<input type="submit" value="Submit"
name="B1"><nobr><select NAME="zip" SIZE="1">

<option>94015</option>

<option>94080</option>

<option>94541</option>

<option>94945</option>

<option>95648</option>

</select></nobr></p>
</form>

This is #2

<form method="POST" action="locatepro3.asp">
<p align="center">
<input type="submit" value="Submit" name="B1"
style="float: left"><nobr><select NAME="listingcat" SIZE="1">

<option>Network Systems</option>

<option>Phone Systems</option>

<option>Supplier</option>

<option>Wire and Cable Installer</option>

</select><select NAME="zip" SIZE="1">

<option>94015</option>

<option>94080</option>

<option>94541</option>

<option>94945</option>

<option>95648</option>

</select></nobr></p>
</form>

and #3
<thead>
<tr>
<th><b><font size="2">Company</font></b></th>
<th><b><font size="2">Phone Number</font></b></th>
<th><b><font size="2">Fax Number</font></b></th>
<th><b><font size="2">Email</font></b></th>
<th><b><font size="2">Comments</font></b></th>
</tr>
</thead>
 
K

Kathleen Anderson [MVP - FrontPage]

vdvalsit said:
I followed your script, but I notice in FP03 you can't do much
editing, due to the webbots.
Click to expand...

You can do a lot of editing if you switch to Code view, make sure to work
with the gray colored code and save your changes while you are still in Code
view.

I printed out your script and compaired
it to what comes out on my site they seem to be the same.
This is locatepro1 script:
<form method="POST" action="locatepro2.asp">
<p align="left">
<input type="submit" value="Submit"
name="B1"><nobr><select NAME="zip" SIZE="1">

<option>94015</option>
Click to expand...

That's not the script generated by the wizard. That's what you see when you
do a View | Source on the web page from Internet Explorer.
 
Top