I dont have the code any more, I have done it direct using a data adpter. To get the code out of the door.
I will return to this at a later date, as i want everthing to go throught he persitance model.
To get free text working with MYSQL you must select the table type to MyISAM then build a FULLTEXT index on the fields you want to search agains. It works quite well too .
Basically the MATCH critera above goes after the were, unless you want to retrieve the relievance rating then you need to put the MATCH critera into your field list.
Will let you know when I come back around to this code :D
Cheers
Jon
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi
I am have the need to do a free text search within my applications.
I need to add the following to my where clause.
"MATCH (product.Keywords) AGAINST ('" & Critera & "')"
I have battled with ProcessDirectSql and ProcessPureSql, the ProcessDirectSql kept returning nothing in the record cursor
And ProcessPureSql I could not figure out how to expose the connection to the method !!
Can anybody help me please :)
I didn't event know that was an option in MySQL. Shows how much I've read the docs :-)
Can you post the code you're using? I'll see if I can tell you where you've gone wrong and what needs to be changed.
Cheers for replying Rich
I dont have the code any more, I have done it direct using a data adpter. To get the code out of the door.
I will return to this at a later date, as i want everthing to go throught he persitance model.
To get free text working with MYSQL you must select the table type to MyISAM then build a FULLTEXT index on the fields you want to search agains. It works quite well too .
Basically the MATCH critera above goes after the were, unless you want to retrieve the relievance rating then you need to put the MATCH critera into your field list.
Will let you know when I come back around to this code :D
Cheers
Jon