that's what I was guessing. is username read from a previous query or
some place else?
peter
On Fri, 11 Mar 2005 21:02:32 -0500, Mike Buzzetti
<[EMAIL PROTECTED]> wrote:
> 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]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
