mysql view not visible in query builder

CodeCharge Studio

Web Reports

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

YesSoftware Forums -> CodeCharge Studio -> PHP

mysql view not visible in query builder

Author

Message

jokecoat

Posts: 43

Posted: 12/12/2013, 8:36 AM

Hi there,

i have
- ccs 5.1.1.18990,
- php 5.3.9
- mysql 5.0.8

in the connection with mysql i have checked all table/view list options, but still in the queyr builder, even after a refresh, the view(s) won't show. Any idea?

jokecoat

Posts: 43

Posted: 12/12/2013, 8:44 AM

And in addition..
when i use the view in the sql, the review data works fine, but the live page gives a syntax error: near 'asc' at line 3

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

PHP Reports

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

Home | Search | Members | Register | Login