If you have a new question you’d like our support staff to post a response to, please visit our customer community, GoAnywhere Insiders, to pose the question in our Discussion Boards. We have a thread “Ask Our Tech Experts” that our support team monitors on a regular basis, or you can start a new discussion where other GoAnywhere users and support staff can weigh in. Log in or create your new account at https://insiders.goanywhere.com
If you need an immediate response, please create a support ticket or contact our support team by email at [email protected]
- 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”