473,395 Members | 1,968 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

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

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.getText does not exist"

Expand|Select|Wrap|Line Numbers
  1.  
  2.  
  3. String query1 = "SELECT * FROM clipdetails WHERE MATCH(clipTitle, clipAuthor, clipDate, clipNewspaper, clipSubject) AGAINST (srchTxfld.getText())";
  4.  
  5.  
...then we tried converting the content of textfield to a string but doesn't return any result.

Expand|Select|Wrap|Line Numbers
  1.  
  2.  
  3. String x = srchTxfld.getText();
  4.  
  5. String query1 = "SELECT * FROM clipdetails WHERE MATCH(clipTitle, clipAuthor, clipDate, clipNewspaper, clipSubject) AGAINST (x)";
  6.  
  7.  

Any suggestions? Thanks!
Dec 2 '10 #1
1 2339
Dheeraj Joshi
1,123 Expert 1GB
Check this out.

Regards
Dheeraj Joshi
Dec 16 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Google Mike | last post by:
I have RH9 and am using the PHP and MySQL that came with it. I was doing fine with all manner of my web pages for this app until I started having this very strange problem. It's a work order...
2
by: Martin | last post by:
I can't find a newsgroup dedicated to MySQL - is it appropriate to post a question about it here? Most anything I try to do (explain table, drop table, drop database) results in "Error 2013 -...
1
by: Shreyas Kulkarni | last post by:
hi there, recently i have got a problem regarding calculation of sum of digits in a floating point or precision number. the weird behaviour of compiler/language is preventing me from calculating...
1
by: Atul Sharma | last post by:
hi friends i m getting problem regarding wht assemblies are? why they r used? & how they r created?
17
by: Ashwin | last post by:
hi guys, i have overloaded the << operator.as shown below. ostream& operator<<(ostream &out, const student &a) { out<<a.idno; out<< " " ; // out<< a.name; out<< " " ; // out<< a.marks...
0
by: PowerLifter1450 | last post by:
Hi everyone, hoepfully someone can help me with this problem, as I am new to Linux and not so sure how to troubleshoot this problem. I installed MySQL 4.1.21 on Fedora Core two without receiving...
0
by: ravinder1983 | last post by:
Hi All This is the first time I am posting something on discussion. Hopefully I will receive an answer. In MySQL 4.1 I have dates field like start date, close date etc which are of data type...
6
by: ashokfig | last post by:
Hi All, I'm facing problem regarding Accessing secure web page. I tried to connect page through progamming & want access data from web page. I passed Login credentials & also certificate which...
0
by: mahesh123 | last post by:
Hi, I am new to use the crystal reports8.0. I am facing the problem regarding the database connection through the ADO Connection. Suppose my database name is "sample.pra"(due to some security...
30
by: Einstein30000 | last post by:
Hi, in one of my php-scripts is the following query (with an already open db-connection): $q = "INSERT INTO main (name, img, descr, from, size, format, cat, host, link, date) VALUES ('$name',...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.