Native Task arguments without quotes?

Post any question you may have in regards to GoAnywhere MFT and let our talented support staff and other users assist you.
2 posts Page 1 of 1

boheron

Posts: 2
Joined: Wed Jul 01, 2015 3:01 pm

Post by boheron » Wed Dec 09, 2015 4:13 pm
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

Support Specialist
Posts: 592
Joined: Tue Jul 17, 2012 2:12 pm
Location: Phoenix, AZ

Post by Support_Rick » Mon Jan 18, 2016 8:49 am
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
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
2 posts Page 1 of 1