questor
|
| Posted: 02/21/2002, 5:03 PM |
|
how i can search in notes in bookstore....
whaterver - how i can buikd good serach engine with CC ?
in this search have no deep
|
|
|
|
Nicole
|
| Posted: 02/22/2002, 2:44 AM |
|
Hello,
you can search on Memo type fields the same way as on any other text type field.
To create powerful search engine you can provide search on several fields (look at advSearch page in BookStore example) and you may improve it with "search within result" feature (look for the related article on this site).
|
|
|
|
questor
|
| Posted: 02/22/2002, 6:37 PM |
|
yes i know this article, but is not what i want to build with codecharge...
i want to build multiple search ..want to put keyword in one txtbox (without choice in combo or list box)and get result in page...(example - search with description and notes, and news etc)
if you know how i can do it, i will be verry happy, if post reply with description here
|
|
|
|
Nicole
|
| Posted: 02/23/2002, 1:57 AM |
|
Hello,
to search on several table fields using one search field, create one search field, but add as many input parameters for result Grid form as many table fields you want to search on. Note that the name of Input parameters should be the same and match with search field name. But Input parameters should be assigned to different fields.
Refer to Forum example:
Search form: index page/search form has one search field only.
Result Grid form: searches page/Messages form. Look at its Input tab. There're two input parameters and the search is implemented on "topic" and "message" fields. Like:
select * from table_name where topic like '%search%' or message like '%search%'
|
|
|
|
|
|
