I am trying to turn certain fields of a Gridview control invisible based on the the values from a certain data field within my database.
In order to do so I require a bool value, however the value indicating if it should be visible or not is an integer.
I was trying to convert the value, within my sql statement, as I do not have direct access to the database in order to
insert the value I need.
The field "MyValue" will return a value between 0 and 5. If it is 0 it should return "False" if anything else it should be "True"/
This is my sql statement:
CODE
SELECT name, city, mallName, companyName, contactName, projectID, substantialcompletiondate, worktype, IF(MyValue>0, "TRUE", "FALSE") FROM dbo.qryProjectsListForWebsite WHERE (province = @province) ORDER BY name
I get an except from this, due to the if(,) branching.
Any help would be appreciated.
Forum Index:
Programming Help |
C and C++ |
VB6 |
Java |
VB.NET |
C# |
ASP.NET |
PHP |
ColdFusion |
Perl and Python |
Ruby |
Databases |
Other Languages |
Game Programming |
Mobile Development |
Software Development |
Computer Science |
Industry News |
Programming Tutorials |
C++ Tutorials |
Visual Basic Tutorials |
Java Tutorials |
VB.NET Tutorials |
C# Tutorials |
Linux Tutorials |
PHP Tutorials |
ColdFusion Tutorials |
Windows Tutorials |
HTML/JavaScript Tutorials |
CSS Tutorials |
Flash Tutorials |
Web Promotion Tutorials |
Graphic Design & Photoshop Tutorials |
Software Development Tutorials |
Database Tutorials |
Other Language Tutorials |
ASP.NET Tutorials |
Game Programming Tutorials |
WPF & Silverlight Tutorials |
| 
