Your Ad Here

advanced code snippet search

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.

Expand | Embed | Plain Text 
  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.