CodeCharge Studio
search Register Login  

Web Reporting

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

YesSoftware Forums -> Archive -> GotoCode Archive

 search form problem in CCS

Print topic Send  topic

Author Message
tukapen
Posted: 05/01/2002, 6:11 AM

I have create a search form but how could I customize the where condition. Because it look like let say I need to search for person start with the name A, it will infact return all name contain A

How could I modify the SQL so that SQL look likes this A% rather than %A%
Nicole
Posted: 05/02/2002, 5:58 AM

just open Data Source window from Properties window->Data tab->Data Source. Select input parameter modification and change 'Condition' to "begins with (like'...%')"
tukapen
Posted: 05/02/2002, 6:49 PM

Hi I have tried out but still didn't work as expect
Nicole
Posted: 05/03/2002, 4:48 AM

Ok, how does it work?
BTW, what programming language do you use?

   


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.