CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> PHP

 Big Problems in Query Builder of CCS5

Print topic Send  topic

Author Message
Seichobob

Posts: 55
Posted: 06/12/2012, 6:05 AM

hi folks,

please could anyone have a look on the following image



i dont understand why i get an mysql error... can anyone help me?

{id} works great but {gruppierung} doenst. its an url integer value so i thought it should work without " " and without ' '.

hopefully someone has an idea.

btw: my mysql odbc connector is newest version 32 bit (even i have a 64 bit os)

greetings
View profile  Send private message
Lucius

Posts: 220
Posted: 06/12/2012, 3:04 PM

Try surrounding {gruppierung} with quotes (double quotes). I don't know if it's the same thing, but PostgreSQL has an issue with CCS query builder, that some parameters are working ok, but some will throw SQL error, and only by surrounding in double quotes it goes away...

Anyway, this is only Query Builder issue (at least in PostgreSQL) and if you build and launch your page it should work fine and without error.
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.