>-----Original Message-----
>From: Leona Slepetis [mailto:[EMAIL PROTECTED]
>Sent: Montag, 2. Mai 2005 20:18
>To: [email protected]
>Subject: storing result of <esql:get-xml>
Try the following:
>I would like: (what is the type of myVar?)
>...
String myVar;
><esql:execute-query>
> <esql:query>
> select text
> from sur_response
> </esql:query>
> <esql:results>
> <esql:row-results>
> <xsp:logic>
> myVar = <esql:get-xml column="text"/>;
myVar = <esql:get-string column="text"/>;
> </xsp:logic>
> </esql:row-results>
> </esql:results>
></esql:execute-query>
><TABLE>
> <TR>
> <TD><xsp:expr>myVar</xsp:expr></TD>
<TD><util:include-expr xmlns:util="http://apache.org/xsp/util/2.0";
expr="myVar"/></TD>
> </TR>
> <TR> ... some other queries go here ... </TR>
> <TR>
> <TD><xsp:expr>myVar</xsp:expr></TD>
> </TR>
></TABLE>
>...
>
>Thanks,
>Leona
HTH, Alfred.
This message is for the named person's use only. It may contain confidential,
proprietary or legally privileged information. No confidentiality or privilege
is waived or lost by any mistransmission. If you receive this message in error,
please notify the sender urgently and then immediately delete the message and
any copies of it from your system. Please also immediately destroy any
hardcopies of the message. You must not, directly or indirectly, use, disclose,
distribute, print, or copy any part of this message if you are not the intended
recipient. The sender's company reserves the right to monitor all e-mail
communications through their networks. Any views expressed in this message are
those of the individual sender, except where the message states otherwise and
the sender is authorised to state them to be the views of the sender's company.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
