CodeCharge Studio
search Register Login  

Visual Web Reporting

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

YesSoftware Forums -> Archive -> GotoCode Archive

 Like Operator Problems

Print topic Send  topic

Author Message
Aaron
Posted: 08/06/2002, 11:05 AM

I am using CodeCharge JSP w/ Templates. I have set up my search (on the same problem as the grid) to use like '...%' on my builder field. This should allow me to search for k and get all builders starting with k, how ever this is not how it is acting. It won't allow me to use k* to do this same search either. I want to be able to search using wildcards. Currently in order to find the records I need I have to enter the exactly correct character string for the record. I really need a way to use wildcards.

thanks for your help,
Shackelton
Posted: 08/06/2002, 11:04 PM

Maybe your database is case sensitive in which case k would not return k. Also, the values you enter in a search form are used as literals when creating the SQL query for the search so you can't enter wildcards like *. In other words, k* would only work if you have a field in the database as "k*".

   


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.