Search CFC

[Tobie29]

Has anyone done up a Search CFC for a dynamic site before? The Verity search is not working correctly on the clients server, which runs CFMX 6.1. It is pulling secure information, and not indexing all of the dynamic content. This site is 95% dynamic, all page content resides in either a SQL database that the client maintains in-house or in Access database which the client maintains through a CMS.

Is it possible to create up a search CFC to search for the same keywords in all tables, then combine them into one page results? I tried searching here for any help with this, but I did not see any previous thread that dealt with a similar situation.

Thanks!

 

[TruthInSatire]

are you talking about doing a verity AND a db search? if the site is that dynamic I wouldn't bother with a verity and just search the tables.



We've heard that a million monkeys at a million keyboards could produce the complete works of Shakespeare; now, thanks to the Internet, we know that is not true.

 

[Tobie29]

I scraped the verity search since it really messed everything up. Just searching the tables. Is there an easy way to capture all matches from a number of tables from a SQL database and an Access database and have it output to one clean list?

 

[TruthInSatire]

You've got Access AND sql?

you can either
1) link the other database and do a join
2) use 2 data sources then query of query

We've heard that a million monkeys at a million keyboards could produce the complete works of Shakespeare; now, thanks to the Internet, we know that is not true.

 

[Tobie29]

Thanks! I will try it out. I have about 20 tables to search through. So much fun!

Yea, the client had intranet data on an in-house SQL server, bought their own web server with CF 6.1, and wanted us to build the rest of the site in Access databases. Nice and confusing, eh?

 

[TruthInSatire]

Got to love clients. Especially the ones that give requirements when they can't tell microsoft from macromedia

We've heard that a million monkeys at a million keyboards could produce the complete works of Shakespeare; now, thanks to the Internet, we know that is not true.

 

[Tobie29]

How many database tables can I include in a QoQ? I have only done it with two before, but I have approximately 20 tables to work with here.

 

[TruthInSatire]

I don't know that there is a limit. you can check livedocs.

http://livedocs.macromedia.com

We've heard that a million monkeys at a million keyboards could produce the complete works of Shakespeare; now, thanks to the Internet, we know that is not true.

 

[Tobie29]

Thanks! I check those out again. I'll post the solution once I have one.