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]
