Unanswered Question
Jul 19th, 2008


Is it possible to use CRS script variables as a SQL column name in an DB Write??

The script bellow does not work but if I replace $String_DBColumn with "COLUMN" all works fine.

update "SESSIONS"

set $String_DBColumn = $String_Status

where "SESSIONID" = $int_SessionID

If I try to run the script with $String_DBColumn the exception in the attachement is thrown.

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
b.hsu Thu, 07/24/2008 - 13:38

You can't use Column name as a value which will be decided at runtime, it should be given while writing scripts.


This Discussion