U++ framework: U++ SQL » Issue with sql.execute(const String&)

Home » U++ Library support » U++ SQL » Issue with sql.execute(const String&)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Issue with sql.execute(const String&) [message #28410]

Tue, 31 August 2010 22:20

BioBytes
Messages: 312
Registered: October 2008
Location: France

Senior Member

Hi all,

I have a question regarding the command sql.Execute. This is an example from my source code. the query works perfectly if the query is passed as below:

if(sql.Execute("select * from codetechnic where(codefamille='cat' and product='hemoglobin')")PromptOK("query is executed");

In case the query is built using parameters obtained from droplists controls as follows:

String query;

query<<"select * from codetechnic where(codefamille=";
query<<"'";
query<<mydroplist1.GetData().ToString();
query<<"'";
query<<" and product=";
query<<"'";
query<<mydroplist2.GetData().ToString();
query<<"'";
query<<")";

The expression if(sql.execute(query))returns false (????) and true as above.

Is anybody could explain to me how to pass runtime query ?

thank you for your help

regards
Biobytes

Report message to a moderator

[Message index]

		Issue with sql.execute(const String&) By: BioBytes on Tue, 31 August 2010 22:20
		Re: Issue with sql.execute(const String&) By: zsolt on Wed, 01 September 2010 21:27
		Re: Issue with sql.execute(const String&) By: BioBytes on Thu, 02 September 2010 21:38
		Re: Issue with sql.execute(const String&) By: zsolt on Thu, 02 September 2010 23:07
		Re: Issue with sql.execute(const String&) By: BioBytes on Sat, 04 September 2010 19:07

Previous Topic:	SQlite3: my problem or bug?
Next Topic:	Compiling error for mysql

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Nov 15 09:50:44 GMT+1 2026

Total time taken to generate the page: 0.00626 seconds