advcomputer
Posts: 68
|
| Posted: 06/13/2006, 7:47 AM |
|
Here is an odd question, and I would like to know how to accomplish it with CCS 3.0
On a search page, I would like to be able to put multiple criteria such as on google.
As an example if I have a table that has a column called description see below.
Tab Folder Definition
Folder Cover Sheet
FF Recommendation on sale
NY Recommendation to Board
NY Approval to Sell Property
Property Summary
I would like to enter in the search field the following; NY Property
and have it display in the grid;
NY Approval to Sell Property
Any ideas would be appreciated.
-jeff Goldstein
|
 |
 |
DonB
|
| Posted: 06/14/2006, 3:45 PM |
|
Consider implementing a 'full text' index. How you do this (or whether you
even CAN) is dependent upon your database.
IN MySQL you could query
SELECT columns FROM table WHERE MATCH(fulltext columns) AGAINST('NY
Property')
and get the result you want.
--
DonB
http://www.gotodon.com/ccbth
"advcomputer" <advcomputer@forum.codecharge> wrote in message
news:6448ed00252064@news.codecharge.com...
> Here is an odd question, and I would like to know how to accomplish it
with CCS
> 3.0
>
> On a search page, I would like to be able to put multiple criteria such as
on
> google.
>
> As an example if I have a table that has a column called description see
> below.
>
> Tab Folder Definition
> Folder Cover Sheet
> FF Recommendation on sale
> NY Recommendation to Board
> NY Approval to Sell Property
> Property Summary
>
> I would like to enter in the search field the following; NY Property
> and have it display in the grid;
>
> NY Approval to Sell Property
>
> Any ideas would be appreciated.
>
> -jeff Goldstein
>
>
>
>
> _________________
> Jeff Goldstein
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
|
