cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tom Place" <psyt...@nottingham.ac.uk>
Subject Retrieving a String from the database in XSP
Date Tue, 11 Feb 2003 11:36:14 GMT
I am trying to retrieve a string from the database an place it into a
variable (should be simple I know)
However I am getting a compilation error
 
I am trying to insert the string value correctly? 
 
String myString = null;
   
 <esql:connection><esql:pool>autorevs_pool</esql:pool>
      <esql:execute-query>
        <esql:query>select * from user_info where
USERNAME='<xsp:expr>username</xsp:expr>' and
PASSWORD='<xsp:expr>password</xsp:expr>'</esql:query>
        <esql:results>
              <xsp:logic>
                style = "<esql:get-string column="STYLE"/>";
              </xsp:logic>
        </esql:results>
        <esql:no-results>
          <xsp:logic> 
            style = "";
          </xsp:logic>
        </esql:no-results>
      </esql:execute-query>
    </esql:connection>
 
Cheers
 
Tom
 
 

Mime
View raw message