CodeCharge Studio
search Register Login  

Visual Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> ASP.NET - InMotion Framework

 Error: Checkbox and MS SQL bit field

Print topic Send  topic

Author Message

Posts: 3
Posted: 03/17/2009, 6:21 AM

I'm trying to build a form that checks a bit field to select the correct records, and the generated form does not work.

=> Invalid Column Name 'False'

So I thought ok it's trying to be smart and converting the value of no to false,
I then tried:
=> Invalid Column Name 'True'

Yep, it's doing what I think...

So, how do I make this work with MS SQL?

Any advice appreciated.

- Anthony

CCS 4.2
MS SQL 2005 using native client
ASP.NET - C# with inmotion.
View profile  Send private message

Posts: 3
Posted: 03/17/2009, 12:31 PM

Nevermind, found it by chance.

Connections-> Connection1->edit->server->boolean format

Set that to 1;0
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

Internet Database

Visually create Web enabled database applications in minutes.

Home   |    Search   |    Members   |    Register   |    Login

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