advanced search

We Recommend

ASP.NET 3.5 Unleashed ASP.NET 3.5 Unleashed
ASP.NET 3.5 Unleashed is the most comprehensive book available on the Microsoft ASP.NET 3.5 Framework, covering all aspects of the ASP.NET 3.5 Framework--no matter how advanced.

Posted By

jgmutza on 10/17/06


Tagged

article


Versions (?)


Death by Concatenation

Published in: ASP 

Building a SELECT statement this way obscures the meaning.


Plain TextExpand 
  1. dim sql
  2. sql = "select TagName from IODefinitions where " & _
  3. "StationName = '" & StationName & _
  4. "' and Output = " & iif(StepType=stWaitForInput,"'0'","'1'") & _
  5. " and TagGroup != 'System'"

Report this snippet 

You need to login to post a comment.