Advanced Search

Death by Concatenation

/ Published in: ASP
Save to your folder(s)
Building a SELECT statement this way obscures the meaning.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  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


Comments

You need to login to view comments.