Gino, I played around with your test plan, and I could not get it to
work with the newest nightly build. Basically the error is that
${Username} is not getting changed to the value of the username.
I don't know why, but I believe that is the problem. ( I am not 100%
positive since I only looked at it for about an hour)
anyone have any ideas?
On Fri, 11 Mar 2005 14:29:13 -0600, Craig S. Wilson <[EMAIL PROTECTED]> wrote:
> Gino Gargiulo wrote:
> > 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]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
