Yes - try running your loop outside the esql tags (as I suggested
before). Build your SQL statement as a String then just do:
<esql:query><xsp:expr>mySqlStatement</xsp:expr></esql:query>
Just a suggestion.
- Brent
On Thu, 29 Jul 2004 21:03:04 -0700, Christina <[EMAIL PROTECTED]> wrote:
> Hi, Jeff,
> that is a good idea. But what if I have another "for" loop inside of the
> "if"?
> What I really want to do is take a list from the request attribute and
> query every entry in that list.
> also i don't know the length of the list beforehand. so I need an "if"
> for the first entry (encase that is a list with zero length) and a "for"
> loop for every one else.
> Any idea how to do it?
> Thanks!
>
>
> ----- Original Message -----
> From: "Jeff Jones" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, July 29, 2004 2:20 PM
> Subject: Re: [esql] xsp:logic doesn't work inside <esql:query>?
>
> >
> > Christina,
> >
> > I can't explain why that doesn't work, but I've never tried it. You could
> do it
> > this way, though:
> >
> > <esql:query>
> > SELECT foo FROM bar
> > WHERE baz = <esql:parameter><xsp:expr>( (test) ? "quux" :
> blort.someMethod()
> > )</xsp:expr></esql:parameter>
> > </esql:query>
> >
> > In other words, replace the "if (test)" statement with the equivalent
> "(test) ?
> > expr1 : expr2" expression. <xsp:expr> should work here, even though
> <xsp:logic>
> > doesn't.
> >
> > </Jeff>
> >
> >
> >
> >
> > "Christina"
> > <[EMAIL PROTECTED] To:
> <[EMAIL PROTECTED]>
> > il.com> cc:
> > Subject: [esql] xsp:logic
> doesn't work inside <esql:query>?
> > 07/29/2004 07:33
> > PM
> > Please respond to
> > users
> >
> >
> >
> >
> >
> >
> > I tried to use if () inside <esql:query> like this:
> > ....
> > <esql:query>
> > <xsp:logic>
> > if (true) {
> > <esql:parameter>...</esql:parameter>
> > }
> > </xsp:logic>
> > </esql:query>
> > ....
> > but every time there is error message on this "if", it is ok if I delete
> > everything before and after the nested <xsp:logic> tag.
> > So <xsp:logic> cannot work inside of <esql:query>? or I did something
> wrong?
> > Thanks!
> >
> >
> >
> >
> >
> > ---------------------------------------------------------------------
> > 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]
