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>

            >

          </xsp:logic>

        </esql:no-results>

      </esql:execute-query>

    </esql:connection>

 

Cheers

 

Tom

 

 

Reply via email to