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.
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]
