Tekkishodan
Member
I am trying to use another control in the message body of a scheduled email. I am using the following code:
My scheduled task connects and processes against the directors table. I am trying to get a list of tasks for each director and send them each a mail.
{artsqltable
query="select taskname from tasks where director = {directors___id_raw}"} {/artsqltable}
When this processes, I get the error:
Error executing query select taskname from tasks where director=1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '}' at line 1 SQL=select taskname from tasks where director=1
If i replace {directors___id_raw} with a number then it displays correctly.
Any ideas guys?
My scheduled task connects and processes against the directors table. I am trying to get a list of tasks for each director and send them each a mail.
{artsqltable
query="select taskname from tasks where director = {directors___id_raw}"} {/artsqltable}
When this processes, I get the error:
Error executing query select taskname from tasks where director=1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '}' at line 1 SQL=select taskname from tasks where director=1
If i replace {directors___id_raw} with a number then it displays correctly.
Any ideas guys?