Searching Grid with Logical/Boolean Criteria

CodeCharge Studio

Web Reports

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

YesSoftware Forums -> CodeCharge Studio -> General/Other

Searching Grid with Logical/Boolean Criteria

Author

Message

Spikey

Posts: 1

Posted: 04/04/2005, 8:23 AM

I have a SQL list in a Grid with Search page that contains a logical/boolean field "Sold". I have the s_sold field in my Search region but cannot retrieve any records when I use it.

The Grid shows the records' "Sold" field as "Yes" or "No". I have tried to put Yes, No, True, 1, 0, Y, N, and checkBox values in the s_sold search field and no records are returned.

Can anyone tell me the trick to making this work? Thanks.

--Spikey

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