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]