Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Community Member

CRS SQL

Hello

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.

1 REPLY
Silver

Re: CRS SQL

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

402
Views
0
Helpful
1
Replies
CreatePlease to create content