Search and ASP

[moose]

We are developing our Intranet site and are including a search capability. We also have asp pages that are populated by a database using queries. I am fairly new to ASP programming. Is it possible to have a search feature that would return values that are populated on the ASP page?

Any help is appreciated.

[moose]

Does anyone know the answer to my question? Please help!!

We are developing our Intranet site and are including a search capability. We also have asp pages that are populated by a database using queries. I am fairly new to ASP programming. Is it possible to have a search feature that would return values that are populated on the ASP page?

Any help is appreciated

[Clunietp]

Since the ASP pages are populated with data at runtime, you can't seach on the content of the ASP pages using the Content Indexer because your ASP files will not contain data at the time of the indexing by that service. If you want to search your database you need to create a custom searching mechanism to facilitate this

[moose]

Thanks Clunietp. I was thinking this would be the case but was not sure. It looks like I will be having fun creating a search engine of my own!!!

Surely if all the information on the pages is ripped from a database then can't you just create a sql statement to get the infor you need then display it with the asp pages like normal?

Use something like:

SELECT * FROM Articles WHERE Content LIKE '%latest news%';

in the Open argument of a recordset to return only the records that match your search...

I'd have thought it would only take a few modifications to integrate this into your current pages (ooh...see those buzz words!! )