Skip to main content
A
Anonymous
August 26, 2008
Question

Looking for help to develop data search form

  • August 26, 2008
  • 1 reply
  • 337 views
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
This topic has been closed for replies.

1 reply

N
Newsgroup_User
Inspiring
August 26, 2008
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
>

A
Anonymous
August 26, 2008
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
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices