On 10.Mar.2003 -- 11:20 AM, [EMAIL PROTECTED] wrote:
> > 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>
>
> 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 ");
This looks weird. Which version are you using? Could you please post
your entire XSP?
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]
