Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » U++ Library support » U++ SQL » Issue with sql.execute(const String&)
Re: Issue with sql.execute(const String&) [message #28476 is a reply to message #28472] Thu, 02 September 2010 23:07 Go to previous messageGo to previous message
zsolt is currently offline  zsolt
Messages: 698
Registered: December 2005
Location: Budapest, Hungary
Contributor
Put a breakpount there or do a log and check the content of the string or the error message from the SQL backend.

Sorry but I have no exlerience with queries like that, since I use U++.

I create dynamic queries with SqlExp.
SqlBool where = (SOMEFIELD == some_value);
if(!(~some_ctrl).IsNull){
  where = where && OTHERFIELD = ~some_ctrl;
}
if(!(~find).IsNull){
  String s = ~find;
  s << '%';
  where = where && Like(THIRDFIELD, s);
}
sql * Select(SqlAll())
  .From(SOMETABLE)
  .Where(where);
 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: SQlite3: my problem or bug?
Next Topic: Compiling error for mysql
Goto Forum:
  


Current Time: Wed May 15 05:32:08 CEST 2024

Total time taken to generate the page: 0.03448 seconds