>What is the value of is_pod?
>
>>Hi everybody,
>>
>>I am not sure why I am getting the error 'can not implicitly convert string booking type to Boolean') when I try to apply C# iif as in this command
>>
>>
>>sqlCommand.CommandText = "SELECT * FROM dbo.b_sched WHERE " + columnName +
>> @" = @columnValue and start_time IS NOT NULL
>> AND layer < 7 and is_pod" + ("POD"== bookingType)?">0":"=0";
>>
>>bookingType defined as String.
>>
>>Do you see what is wrong in this expression and why C# doesn't like it?
is_pod is part of the string - I am using @ for long strings that span multiple lines.
is_pod is a tinyint column in the table.
UT syntax color parsing can not figure this out, but the AND layer part is the continuation of the string.
If it's not broken, fix it until it is.
My Blog