cocoon / xsp / esql

[Kirula Leelasena <ki...@db.com>]

Hi,
Kindly advise why the following isn't working? I get null result when I expected xxxx.
I am simply trying to assign a variable to a resulting data from a Database Query.
Many Thanks.
Kirula

My .xsp code sniplet :-
....
  <xsp:logic>
    String myVar = null;
  </xsp:logic>

 <esql:connection>
         <esql:pool>myconn</esql:pool>
         <esql:execute-query>
                 <esql:query>
                    select 'xxxx' ID from dual
                 </esql:query>
                 <esql:row-results>
                    <xsp:logic>
                       myVar = <esql:get-string column="ID"/>;
                    </xsp:logic>
                 </esql:row-results>
         </esql:execute-query>
  </esql:connection>
<para>myVar = <xsp:expr>myVar</xsp:expr></para>
...


-----------------------------------------------
Kirula Leelasena
Global Markets Technology
Institutional Client Group

Phone:  +44  (0) 20 7545 9580
Fax :       +44  (0) 20 7545 1559
Internet email:    Kirula.Leelasena@db.com
(Embedded image moved to file: pic26308.pcx)


--

This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.