Execute SQL

Dec 13, 2011 at 5:04 PM
Edited Dec 13, 2011 at 5:05 PM

Hi Christian,

Thanks for a great set of activities. One question - I'm executing an SQL insert like this:

INSERT INTO table (Column, Column2) VALUES ('[%Variable:MyValue%]', '[%Variable:MyValue2%]')

Everything works as expected except it looks like backslashes are being stripped from my variables.

So if MyValue = \\this\is\my\path the value inserted into SQL looks like '\thisismypath'

If I build a dynamic string of the INSERT statement and then use that variable as my SQL query for Execute SQL the same thing happens, but if I log the same INSERT statement it appears as it should in the history, with all the backslashes.

Any suggestions? TIA