CodeCharge Studio
search Register Login  

Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> General/Other

 Menubuilder and where in SQ causes issue

Print topic Send  topic

Author Message
icp4all

Posts: 37
Posted: 03/28/2012, 11:11 AM

Hi (again ;-))

another point i found is a problem with where clauses in the querry and Menues made with menubuilder.

I have 2 fields in my table (user_level, activ) to controll access and/or activate menuitems in the backend.
So everything is ok with menues til i add something to the where clause.
(ie. ....wehre user_level <= GroupID and activ = 1)
Now the correct Items are selected, but the first inactiv Submenu is also shown.

i will report this to the support.

Hans
View profile  Send private message
clayhmn

Posts: 20
Posted: 03/28/2012, 1:33 PM

Have you tried working around this by building a view of the data that only includes the menu items? The Data Dictionary in CCS5 makes it a snap to build a query to use.
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.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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