Post any question you may have in regards to GoAnywhere MFT and let our talented support staff and other users assist you.
- Posts: 2
- Joined: Wed Jul 01, 2015 3:01 pm
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.
- Posts: 592
- Joined: Tue Jul 17, 2012 2:12 pm
- Location: Phoenix, AZ
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.
Lead Solutions Consultant
Return to “Community Forum”