CodeCharge Studio
search Register Login  

Visual Web Reporting

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

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

 Error: Checkbox and MS SQL bit field

Print topic Send  topic

Author Message
fonzyco

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.

http://mssql/StaffDirectory/Default.aspx?s_TeamID=2&s_Disabled=No
=> 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:
http://mssql/StaffDirectory/Default.aspx?s_TeamID=2&s_Disabled=Yes
=> 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

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

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 http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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