Dreamweaver - how to make good search page

Author

how to make good search page

newbeenewbee

2004-04-21, 2:28 pm

I'm wanting to create a search page that has a simple search box at the top of
the page and then when submitted shows all matching records below the search
form on the same page. How do I restrict the recordset from trying to show any
records when the page is first opened. I'm thinking this will cause an
annoying pause everytime the page is first opened(and the search hasn't been
submitted yet).

choc.vicp.net

2004-04-21, 2:28 pm

??you need a search engine !!
or use others search engine.
eg.: google.com

newbeenewbee

2004-04-21, 2:28 pm

i should have explained a little more. sorry. i'm making a simple search page
to search records in a particle database table. i'd like to have the search
box and search results listed all on the same page. but there are going to be
close to 1 million records so i don't have the search results to list any
records until the search has actually been submitted.

choc.vicp.net

2004-04-21, 2:28 pm

i think u must sort ur database by categories.i cant image greater than 1million records in 1 table.:(
and add a select list on ur search box ,

middletree

2004-04-21, 2:28 pm

If you are using SQL Server, do a search in their help (BOL) on "Full-Text
search". I am am undertaking this task right now and don't have any answers
yet, but this seems to be the way to go.

"choc.vicp.net" <webforumsuser@macromedia.com> wrote in message
news:c5eblr$fj$1@forums.macromedia.com...
> i think u must sort ur database by categories.i cant image greater than
1million records in 1 table.:(
> and add a select list on ur search box ,

Mad Dog

2004-04-21, 2:28 pm

I don't understand where the problem is. Nothing is searched until the user
hits the "search" button, so why would anything be displayed? I think you
need to read the sections in DW Help about using a database with DW. It's
not really that difficult. Here's an example that's probably similar to what
you want to do, though it uses an Access database:
www.silvermanstockfootage.com/search.asp . After you search the results page
has another search area built in.

MD

newbeenewbee wrote:
> i should have explained a little more. sorry. i'm making a simple
> search page to search records in a particle database table. i'd like
> to have the search box and search results listed all on the same
> page. but there are going to be close to 1 million records so i
> don't have the search results to list any records until the search
> has actually been submitted.

newbeenewbee

2004-04-21, 2:29 pm

mad dog. the page you suggested looking at does not include the search form
and results in the same page. the search form submits to another page which
displays the results. i'm looking for the best way to display both on the same
page so users don't have to go back and forth to searches/results, they will
just be presented on the same page.

matt_12511

2004-04-21, 2:29 pm

You need a page that has an if statement.

If user-submitted = "Yes" then

**enter code for DB search
**Show form for a new search

else

** display search form and make user-submitted = "Yes"

end if

Then just have the form submit to the same page.

<form action="search.asp" method="post">

I haven't done this but I don't see why it wouldnt work.

Matt

ps. If you try this, let me know if it works.

Mad Dog

2004-04-21, 2:31 pm

Did you try a search on that page I sent you to? The results are returned on
a page that includes another search form so you can do a new search. Unless
I'm not understanding you corrrectly, that's what you were trying to do,
right?

MD

newbeenewbee wrote:
> mad dog. the page you suggested looking at does not include the
> search form and results in the same page. the search form submits to
> another page which displays the results. i'm looking for the best
> way to display both on the same page so users don't have to go back
> and forth to searches/results, they will just be presented on the
> same page.

newbeenewbee

2004-04-21, 2:49 pm

yes, results link with search and results is what i'm trying to do. i've
created a page that does something similar but the you can tell there's a bit
of a pause because the recordset searches on default values even before the
form is submitted(when the page first loads up). how do i have it so it that
the recordset doesn't run until the form is submitted(all on one page).