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.
|
|
|
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
|
|
|
|