How to match text with FULL-TEXT search using a string returned from a function?

[Kathleen Reyes]

We wanted to get the text from the textfield to match it with our database and so we did this code but unfortunately we get a runtime error saying "FUNCTION srchTxfld.getTe xt does not exist"

 

String query1 = "SELECT * FROM clipdetails WHERE MATCH(clipTitle, clipAuthor, clipDate, clipNewspaper, clipSubject) AGAINST (srchTxfld.getText())";

...then we tried converting the content of textfield to a string but doesn't return any result.

 

String x = srchTxfld.getText();

String query1 = "SELECT * FROM clipdetails WHERE MATCH(clipTitle, clipAuthor, clipDate, clipNewspaper, clipSubject) AGAINST (x)";

Any suggestions? Thanks!

[Dheeraj Joshi]

Check this out.

Regards
Dheeraj Joshi