select query with like

[mazurekwrc]

this code working hith PostgreSql

QString first_name = "arc";
query.prepare( "SELECT name FROM people WHERE name LIKE :name" );
query.bindValue( ":name", "%" + first_name + "%" );
query.exec();
 
while( query.next() )
{
   ....
}

QString first_name = "arc";
query.prepare( "SELECT name FROM people WHERE name LIKE :name" );
query.bindValue( ":name", "%" + first_name + "%" );
query.exec();

while( query.next() )
{
   ....
}

To copy to clipboard, switch view to plain text mode 

i hope that will help you

[sinha.ashish]

Thanks a lot!!!!!!!!!!!!!!!
thats the way!!!!!!!
now everything fine....

[sinha.ashish]

On a single text search its fine but if i have 3 lineEdits(as search criteria) for 3 columns and user can enter search text in any or every or some of those lineEdits then how to implement it???

I have written this code : but it needs that all the lineEdits must be filled ....leaving blank any lineEdit ,then query fetches every row of the table and i want to search for any text enetered in any lineEdits ....

void MultipleSearch::search()
{


}

[sinha.ashish]

On a single text search its fine but if i have 3 lineEdits(as search criteria) for 3 columns and user can enter search text in any or every or some of those lineEdits then how to implement it???

I have written this code : but it needs that all the lineEdits must be filled ....leaving blank any lineEdit ,then query fetches every row of the table and i want to search for any text enetered in any lineEdits ....

void MultipleSearch::search()
{
QString titletxt=titlesrchTxt->text();
QString composerTxt=composersrchTxt->text();
QString releaseDateTxt=rdatesrchTxt->text();
QSqlQuery query;
QString querytxt="SELECT title FROM mediadetails WHERE title LIKE :title OR composer LIKE :composer OR releasedate LIKE :rdate";
query.prepare(querytxt);
query.bindValue( ":title", "%" + titletxt + "%" );
query.bindValue( ":rdate", "%" + releaseDateTxt + "%" );
query.bindValue( ":composer", "%" + composerTxt+ "%" );
query.exec();
while(query.next())
{
listView->addItem(query.value(0).toString());
}
}

[mazurekwrc]

First of all change this line

QString querytxt="SELECT title FROM mediadetails WHERE title LIKE :title OR composer LIKE :composer OR releasedate LIKE :rdate";

to

QString querytxt="SELECT title, composer, releasedate FROM mediadetails WHERE title LIKE :title OR composer LIKE :composer OR releasedate LIKE :rdate";

QString querytxt="SELECT title, composer, releasedate FROM mediadetails WHERE title LIKE :title OR composer LIKE :composer OR releasedate LIKE :rdate";

To copy to clipboard, switch view to plain text mode 

and try

[sinha.ashish]

sorry ...tahts not the syntex which i was trying to post ...u said right...i just missed to ommit ';' ...but do u have idea to do multiple search????
..

[mazurekwrc]

you missed 'composer' and 'releasedate' not ';'
here is my code which work with multiple search

QString first_name = "arc";
QString surname = "LA";
query.prepare( "SELECT name, surname FROM people WHERE ( ( name LIKE :name ) OR ( surname LIKE :surname ) )" );
query.bindValue( ":name", "%" + first_name + "%" );
query.bindValue( ":surname", "%" + surname + "%" );
query.exec();

QString first_name = "arc";
QString surname = "LA";
query.prepare( "SELECT name, surname FROM people WHERE ( ( name LIKE :name ) OR ( surname LIKE :surname ) )" );
query.bindValue( ":name", "%" + first_name + "%" );
query.bindValue( ":surname", "%" + surname + "%" );
query.exec();

To copy to clipboard, switch view to plain text mode 

[sinha.ashish]

thanks....its working fine...