mlapl1
Posts: 66
|
| Posted: 10/15/2006, 8:55 PM |
|
Hello
I have just returned to codecharge after leaving it behind for some years. I would like to know if it is possible to do searches for "words" rather than strings. For instance, if the database contains the sentence: "My dog Albert went to the beach", searching for "Albert" and "beach" (two words which appear in the sentence but which are not consecuitve) would return the record containing my sentence. I think that the mysql textsearch function (or whatever it is called) is capable of doing that, but is it built into codecharge - or maybe there is some other way of doing it. At the moment, it looks to me as though the search functions in codecharge only recognize strings of consecutive characters.
I have upgraded to the latest version.
Your help would be truly appreciated
Andrew
|
 |
 |
peterr
Posts: 5971
|
| Posted: 10/15/2006, 11:18 PM |
|
I think that this depends on the database. Here is one such answer: http://forums.codecharge.com/posts.php?post_id=76065
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
mlapl1
Posts: 66
|
| Posted: 10/16/2006, 4:49 PM |
|
Thanks Peter -
Yes I am aware of the full text indexing possibilities - HOWEVER I do not know how to get codecharge to generate such searching (once the database is correctly set up) OR else where in the code generated automatically by codecharge I should manually substitute mysql's match function for whatever happens to be there now.
Hope this makes sense - Thanks - Andrew
|
|
|
|
peterr
Posts: 5971
|
| Posted: 10/16/2006, 5:30 PM |
|
Andrew, you can do this in your grid's data source - by using a Table, Stored Procedure or SQL as your grid's datasource. For example once you use the Grid or Search Builder and your basic search works OK, then you can open your grid's Data Source property and in Visual Query Builder change "Table" to "SQL". Then you will automatically see the default SQL statement and can modify it.
For example I see such SQL statement:
SELECT * FROM employees WHERE emp_name LIKE '%{s_name}%'
and I assume that I can change it per above instructions to:
SELECT * FROM employees WHERE MATCH(column1, column2) AGAINST('{s_name}')
(athough I'm shooting in the dark as I'm not familiar with that SQL syntax)
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
mlapl1
Posts: 66
|
| Posted: 10/16/2006, 5:57 PM |
|
Great - that is really precious information - All the best - Andrew
|
|
|
|
|
