Ok. But I still get an error :
org.apache.cocoon.components.language.LanguageException:
Line 827, column 27: ':' expected.
Java file :
Line 825 this.characters("\n\t\t\t\tselect * from Actions where
at_ID = ");
Line 826
Line 827 this.characters(""?"");
Line 828
Line 829 this.characters("\n ");
-----Original Message-----
From: Christian Haul [mailto:[EMAIL PROTECTED]
Sent: Monday, March 10, 2003 11:12 AM
To: [EMAIL PROTECTED]
Subject: Re: Multiple ancestors
On 10.Mar.2003 -- 10:46 AM, [EMAIL PROTECTED] wrote:
> > From: Christian Haul [mailto:[EMAIL PROTECTED]
> > Sent: Monday, March 10, 2003 10:43 AM
> > To: [EMAIL PROTECTED]
> > Subject: Re: Multiple ancestors
> >
> >
> > On 10.Mar.2003 -- 10:36 AM, [EMAIL PROTECTED] wrote:
> > > Is it possible to have four "ancestor" like bellow? Because here I
> > > get
> >
> > > errors for each "esql:get-string"
> > >
> > > <esql:execute-query>
> > > <esql:query>
> > > Select * From Process_Actions Where (pa_process =
> > > <xsp-request:get-parameter name="MyID"/>)
> > > </esql:query>
> > > <esql:results>
> > > <esql:row-results>
> > > <esql:execute-query>
> > > <esql:query>
> > > select * from Actions where at_ID = <esql:get-int
> > > column="pa_atid" ancestor="1" />
> > > </esql:query>
> > > <esql:results>
> > > <esql:row-results>
> > > <tr>
> > > <td><esql:get-string column="at_name"/></td>
> > > <td><select><xsp:attribute
> > > name="name">usrname<xsp:expr>mynum</xsp:expr></xsp:attribute>
> > > <esql:execute-query>
> > > <esql:query>
> > > select * from Users
> > > </esql:query>
> > > <esql:results>
> > > <esql:row-results>
> > > <option><esql:get-string
> > > column="ur_name"/></option>
> > > </esql:row-results>
> > > ...
> >
> > Try to use esql:parameter around esql:get-int in an esql:query. You
> > really should do the same with the xsp-request:get-parameter.
> Do you mean "<esql:parameter column="pa_atid" ancestor="1"/>"?
No :
<esql:parameter type="int"><esql:get-int column="pa_atid" ancestor="1"
/></esql:parameter>
Chris.
Please follow up summarizing your problem and which suggested solution /
information worked for you when you consider your problem solved. Add
"SUMMARY: " to the subject line. This will make FAQ generation and
searching the list easier. In addition, it makes helping you more fun.
Thank you.
And if you are really cool, add a page at http://wiki.cocoondev.org
--
C h r i s t i a n H a u l
[EMAIL PROTECTED]
fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08
---------------------------------------------------------------------
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]
