Native Task arguments without quotes?

[boheron]

Hello,

I am executing a program from the Native Task command with an argument like "MailJob1" (without the quotes). I am storing this value in a variable and using the variable as the argument. This argument is supposed to match a field from an SQL table with the same name, again without quotes. When I debug the GA project, I get the following error: No JobID found in [SQLTable] for '"MailJob1"'. As you can see, there is an extra set of double quotes around MailJob1, and the program is erroring looking for a SQL field with a value that contains the quotes.

Is there a way to provide an argument for a native task without these double quotes being automatically added? Or any other non-intrusive work around?

Thanks in advance for any help.

[Support_Rick]

boheron,

Where you're seeing the double quotes is where the logging function wraps double quotes around the value in question, it it already has double quotes, then it appears and 2 double quotes.

If this is the case, then I believe that MSSQL (and most SQL Engines) will consider a double quoted field as a variable, not a value. For string literals, you'll need to use the single quotes surrounding the value you're trying to retrieve.

HTH