Actions and map pipelines

[beyaRecords - The home Urban music]

hi,
i have looked through many documents now about actions and have found 
nothing helpful. Could anyone show me how to reconstruct the following 
into an action/map-xspaction document:



<xsp:logic>
  // handle the previous page's values.
  String name = <xsp-request:get-parameter name="name"/>;
  String password = <xsp-request:get-parameter name="password"/>;
  int userid;
  <esql:connection>
    <esql:dbpool>mypool</esql:dbpool>
    <esql:execute-query>
      <esql:query>SELECT userid FROM users
        WHERE name=name
        AND password=password</esql:query>
      <esql:row-results>
        <xsp:logic>
          userid = <esql:get-int column="userid"/>
        </xsp:logic>
      </esql:row-results>
      <esql:no-results>
          <xsp-response:send-redirect url="/home"/>
      </esql:no-results>
    </esql:execute-query>
  </esql:connection>
</xsp:logic>
So the logic is return a recordset containing a single column and 
assign the value to a variable, but if the user does not exist then 
redirect the user to another page

regards

Uzo

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]