select query with like

[jacek]

It should be:

QSqlQuery query2("SELECT title * from mediadetails where title LIKE '%' || :title || '%' ");

QSqlQuery query2("SELECT title * from mediadetails where title LIKE '%' || :title || '%' ");

To copy to clipboard, switch view to plain text mode 

or

query2.bindValue(":title" "%" + LEdit1 + "%");

query2.bindValue(":title" "%" + LEdit1 + "%");

To copy to clipboard, switch view to plain text mode 

[sinha.ashish]

its not working ........
plzzzzzzzzzzz check again for any problem..if there??

[ag.sitesh]

thanks for reply

check this again

this not working properly

[jacek]

this not working properly

Indeed, there's another mistake. It should be:

QSqlQuery query2;
query2.prepare(...); 
query2.bindValue( ... );
...

QSqlQuery query2;
query2.prepare(...); 
query2.bindValue( ... );
...

To copy to clipboard, switch view to plain text mode 

QSqlQuery::QSqlQuery( const QString & ) constructor executes the query, so you can't use it with placeholders.

[mazurekwrc]

I think that problem is in SELECT

QSqlQuery query2("SELECT title * from mediadetails where title LIKE '%' || :title || '%' ");

QSqlQuery query2("SELECT title * from mediadetails where title LIKE '%' || :title || '%' ");

To copy to clipboard, switch view to plain text mode 

it should be comma before '*'

[jacek]

it should be comma before '*'

Yes, that's the third problem.

[Lykurg]

query2.bindValue(":title" "%" + LEdit1 + "%");

query2.bindValue(":title" "%" + LEdit1 + "%");

To copy to clipboard, switch view to plain text mode 

... and there a comma is missing ;-)

query2.bindValue(":title", "%" + LEdit1 + "%");

query2.bindValue(":title", "%" + LEdit1 + "%");

To copy to clipboard, switch view to plain text mode 

And by the way, I guess that the || is only understood by oracle. If using MySql use the CONCAT function.

Lykurg

[sinha.ashish]

its not working guys........
its shows error unable to fetch data...........
can u write and test any small code on any of ur table in mysql and then post it here plzzz.....
becoz its a basic search only ...!!!
which must be done...