CodeCharge Studio
search Register Login  

Visual Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> PHP

 Problem selecting more than 2 fields in an query after updating to 2.3.1.85

Print topic Send  topic

Author Message
Torben Søemod
Posted: 07/04/2004, 12:47 PM

Im having trouble creating a query containing more than 2 fields. Im using the querybuilder but if im selecting the 3. field im getting this error :

Database error: Invalid SQL: SELECT Destination_ID, Name, Info FROM st_destination LIMIT 0,20
MySQL Error: 1054 (Unknown column 'Info' in 'field list')

If I copy the sql statement from here to my phpmyadmin and runs i there it works fine !!!

I have also tried other names instead of Info.

Has anybody experienced this ?
Torben Søemod
Posted: 07/04/2004, 12:53 PM

Ok i tried just one thing more. I "generated" the commonfiles (i forgot) and it work - 6 hour wasted on a technicality:-(. So kids remember to regenerates the entire project:-)

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.

Web Database

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.