CodeCharge Studio
search Register Login  

Web Reports

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

YesSoftware Forums -> CodeCharge Studio -> Perl

 query problem

Print topic Send  topic

Author Message
Luis Sandoval
Posted: 06/29/2004, 2:28 PM

Hi there,

I have a problem every time I run my query. I do the following code and I still can't get the data from the field. Here is the query, I do a criteria Like "*Name*", and I get nothing.
can you please give an Idea.
Thank you so much
Luis Sandoval
Posted: 06/29/2004, 2:29 PM

Quote Luis Sandoval:
Hi there,

I have a problem every time I run my query. I do the following code and I still can't get the data from the field. Here is the query, I do a criteria Like "*Name*", and I get nothing.
can you please give an Idea.
Thank you so much
Luis Sandoval
dhempy


Posts: 40
Posted: 06/29/2004, 3:13 PM

Quote Luis Sandoval:
Hi there,

I have a problem every time I run my query. I do the following code and I still can't get the data from the field. Here is the query, I do a criteria Like "*Name*", and I get nothing.
can you please give an Idea.
Thank you so much

I think you're trying to use * as a wildcard. In SQL , you'll want the % character as a multi-character wildcard.

Try this: like "%Name%"

That will find records where "Name" appears anywhere in the field, with optional stuff before or after it.


Hope this helps,
-dave

_________________
David Hempy
Director of Broadcast and Education Technology
Kentucky Educational Television
800-333-9764
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.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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