CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> General/Other

 Visual Query Builder Where Like Statement

Print topic Send  topic

Author Message
jav

Posts: 8
Posted: 10/02/2007, 6:38 AM

In Visual Query Builder under table model, is it possible to have a where condition where you have like '..'. I want my users to enter in there own wildcard characters dynamically and there doesn't seem to be an option for that.

I tried setting the like statement in the expression however it doesn't appear you can use parameters in this section. I tried doing it through sql however it is hard coded so the where statement isn't dropped if no parameter is provided. And, trying to do the custom where statements from this link:
http://docs.codecharge.com/studio3/html/ProgrammingTech...HEREClause.html

Is overly cumbersome to code with the amount of criteria I have since I also have to also start worrying about the recordcount in addition to the custom where. Any help would be appreciated.
Thanks.

Jon
View profile  Send private message
mamboBROWN


Posts: 1713
Posted: 10/02/2007, 6:14 PM

jav
What is your environment configuration (versions)??
View profile  Send private message
jav

Posts: 8
Posted: 10/04/2007, 11:24 AM

I am using CC 3.1.1.0 with JS on client and VB on the server.
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.

PHP Reports

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

Home   |    Search   |    Members   |    Register   |    Login


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