Get return value from VBScript
Running Version 5.5.2 Premiere
I have a task that is grabbing data from a website, then inserting it into my SQL Database, but I want to cleanse the data from two different variable first through VBScript.
Here is one of my Scripts:
DIM strDesc
strDesc = Wscript.Arguments.Item(0)
strDesc = TRIM(strDesc)
strDesc = REPLACE(strDesc,"'","")
strDesc = REPLACE(strDesc,",","")
I select the "Run Script" task, select the correct location for the script. In the second option I pass the current Variable $ItemName$ and the second option is the set the new variable $ItenNameVal$ with the return value. I run the script, it executes with no errors, but the portion of my SQL DB the writes the return values are blank. (the Variables value are null by default).
Is there something wrong with my script that is not returning the value?
|