Looking for help to develop data search form

[Guest]

I have built a SQL Query that produces a data set of approximately 60,000 records which includes last_names, First_names, ID_numbers, Office_Names, Association_Names, and Member_Type fields. I have created a table that displays ten records at a time (in alphabetical order by last, first name). I want to (1) be able to search for a specific person in the dataset, and then once I find him/her, (2) be able to click on their ID_Number to select it and then go to another page with their ID_Number.

I have not been able to find documentation on conducting searches of datasets. I am using classic ASP for server side scripting (though I am brand new at this).

Any assistance you might be able to provide will be most gratefully appreciated.

Thanks very much,
Austin

[Newsgroup_User]

Have the search trigger ANOTHER data set that is filtered on the last, first
names.

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================


"AustinMoran" <webforumsuser@macromedia.com> wrote in message
news:g912kd$p59$1@forums.macromedia.com...
>I have built a SQL Query that produces a data set of approximately 60,000
> records which includes last_names, First_names, ID_numbers, Office_Names,
> Association_Names, and Member_Type fields. I have created a table that
> displays ten records at a time (in alphabetical order by last, first
> name). I
> want to (1) be able to search for a specific person in the dataset, and
> then
> once I find him/her, (2) be able to click on their ID_Number to select it
> and
> then go to another page with their ID_Number.
>
> I have not been able to find documentation on conducting searches of
> datasets.
> I am using classic ASP for server side scripting (though I am brand new at
> this).
>
> Any assistance you might be able to provide will be most gratefully
> appreciated.
>
> Thanks very much,
> Austin
>

[Guest]

Thank you Murray for your kind response. I am not entirely sure how to do this. I suspect if I create a simple form with First and Last Name Fields and a Submit button and then POST the content of that form to a 'processor' page this is a good place to start???????

But I am not entirely sure how to insert those two items into the query on the processor page. Can you point me to any documentation or tutorial that might help me along with this?

I am sorry to be such a bother with this. I have a handful of books, but none of them touch on this and I am at a loss.

Thanks again for your kind helpfulness.

Austin

[Newsgroup_User]

> Thank you Murray for your kind response. I am not entirely sure how to do
> this. I suspect if I create a simple form with First and Last Name Fields
> and
> a Submit button and then POST the content of that form to a 'processor'
> page
> this is a good place to start???????

That would surely work.

> But I am not entirely sure how to insert those two items into the query on
> the
> processor page. Can you point me to any documentation or tutorial that
> might
> help me along with this?

The search form posts its results to the processor page. The processor page
retrieves those form values from the $_POST array, and uses them to
formulate a new SQL SELECT statement, identical to the old one, except with
the inclusion of the first and last name values from the $_POST array in the
WHERE statement.

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================


"AustinMoran" <webforumsuser@macromedia.com> wrote in message
news:g914dr$rig$1@forums.macromedia.com...
> Thank you Murray for your kind response. I am not entirely sure how to do
> this. I suspect if I create a simple form with First and Last Name Fields
> and
> a Submit button and then POST the content of that form to a 'processor'
> page
> this is a good place to start???????
>
> But I am not entirely sure how to insert those two items into the query on
> the
> processor page. Can you point me to any documentation or tutorial that
> might
> help me along with this?
>
> I am sorry to be such a bother with this. I have a handful of books, but
> none
> of them touch on this and I am at a loss.
>
> Thanks again for your kind helpfulness.
>
> Austin
>

[Guest]

Thanks again, Murray! I can't begin to thank you enough. I will go to work on it and see how it plays out.

[Newsgroup_User]

If you know enough to understand what I posted, you should do just fine!
Good luck....

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================


"AustinMoran" <webforumsuser@macromedia.com> wrote in message
news:g9164o$k6$1@forums.macromedia.com...
> Thanks again, Murray! I can't begin to thank you enough. I will go to
> work on it and see how it plays out.

[Guest]

Hi Murray! I truly hate to be a pain, and it's not like I haven't tried, but I am just not getting it for some reason. Here's what I've done so far in an effort to simplify things. I have a page titled, GETNAME.ASP with a form, a text field and a submit button into which the user enters a last name and clicks on SUBMIT. This POSTS the last name to the processor page which is entitled LOOKUP.ASP.

On the LOOKUP.ASP page, I have a simple text field which displays the last name that was entered on the previous page (just to make sure it is posting correctly - and that works). On this page I have a recordset which consists of a SQL Query which pulls several fields from a couple of different tables. I was under the impression that I could simply include the following code as part of the "WHERE" statement in the SQL query:

AND dbo.Member.Last_Name=Request.Form("Last_Name")

But this is not working. I have created a binding to the previous page form and field. I am lost here. Obviously, "Request.Form....etc" is foreign to the SQL database. Any ideas would be most greatly appreciated. Sorry to bother you yet again with this, but any help would be terrific. Thanks again!

Austin