The sql is fine, I sent in the same request replacing the ${Username} with a value 'test' and the statement ran fine.
Are there any samples of this where it is working?
I have user variables and property variables in JDBC SQL statements.
Examples of the SQL I use:
delete from job where job.id = media_title.id and media_title.account_id >= ${__property(deleteaccountjdbc.accountnamestart)};
select job_status_id from job where media_title_id = ${mtid};Usually, when an SQL operation fails for me it is because I have some syntax error.
--
---------------------------------------
Craig S. Wilson [EMAIL PROTECTED]
WaveFront Communications, Inc.
1677 Lake Valentine Road
Arden Hills MN 55112-2840
1.651.638.9594 1.612.865.8794
===============================
Note: If you send me HTML-mail, it will
probably end up in my SPAM bucket.
---------------------------------------
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
