Hello,
thanks for reply
On Tuesday 09 March 2004 15.13, JD Daniels wrote:
> Not sure how those semi colons got there... odd...
I get it from this link:
http://www.mail-archive.com/[EMAIL PROTECTED]/msg09607.html
>
> Try taking the session set-attribute right out.. it is not needed as the
> user info is stored in the session with the authentication.
Yes here is my code, but it doesn�t works (can you send me a really working
version?):
<?xml version="1.0"?>
<xsp:page language="java"
xmlns:xsp="http://apache.org/xsp";
xmlns:esql="http://apache.org/cocoon/SQL/v2";
xmlns:xsp-request="http://apache.org/xsp/request/2.0";
xmlns:xsp-session="http://apache.org/xsp/session/2.0";
xmlns:source="http://apache.org/cocoon/source/1.0";
xmlns:util="http://apache.org/xsp/util/2.0";
xmlns:log="http://apache.org/xsp/log/2.0";
>
<!-- create-session="true" -->
<authentication>
<esql:connection>
<esql:pool>portal</esql:pool>
<esql:execute-query>
<esql:query>
SELECT usrid, firstName, lastName, email, role_id, role
FROM authenticate ('<xsp-request:get-parameter
name="username"/>',
'<xsp-request:get-parameter
name="password"/>')
LIMIT 1;
</esql:query>
<esql:results>
<esql:row-results>
<ID><esql:get-int column="usrid"/></ID>
<role><esql:get-string column="role"/></role>
<data>
<xsp-session:set-attribute name="userId">
<esql:get-string column="usrid"/>
</xsp-session:set-attribute>
<xsp-session:set-attribute name="userRole">
<esql:get-string column="role"/>
</xsp-session:set-attribute>
<xsp-session:set-attribute name="userFirstName">
<esql:get-string column="firstName"/>
</xsp-session:set-attribute>
<xsp-session:set-attribute name="userLastName">
<esql:get-string column="lastName"/>
</xsp-session:set-attribute>
<xsp-session:set-attribute name="userEmail">
<esql:get-string column="email"/>
</xsp-session:set-attribute>
<ID>
<esql:get-int column="usrid"/>
</ID>
<role>
<esql:get-string column="role"/>
</role>
<firstname>
<esql:get-string column="firstName"/>
</firstname>
<lastname>
<esql:get-string column="lastName"/>
</lastname>
<email>
<esql:get-string column="email"/>
</email>
</data>
<source:insert>
<source:source>context://module-files/auth/stats/
<util:time format="yyyy/MM/dd"/>.xml
</source:source>
<source:path>/log</source:path>
<source:fragment>
<logon>
<date><util:time format="yyyy/MM/dd"/></date>
<time><util:time format="hh:mm:ss a"/></time>
<user-agent><xsp-request:get-header
name="user-agent"/></user-agent>
<remote-addr><xsp-request:get-remote-address/></remote-addr>
<remote-host><xsp-request:get-remote-host/></remote-host>
<userFirstName><xsp-session:get-attribute
name="userFirstName"/></userFirstName>
<userLastName><xsp-session:get-attribute
name="userLastName"/></userLastName>
</logon>
</source:fragment>
</source:insert>
<esql:error-results><b>Error Results</b></esql:error-results>
</esql:row-results>
</esql:results>
<esql:no-results>
<source:insert>
<source:source>context://module-files/auth/stats/<util:time
format="yyyy/MM/dd"/>.xml
</source:source>
<source:path>/log</source:path>
<source:fragment>
<logonfail>
<date><util:time format="yyyy/MM/dd"/></date>
<time><util:time format="hh:mm:ss a"/></time>
<user-agent><xsp-request:get-header
name="user-agent"/></user-agent>
<remote-addr><xsp-request:get-remote-address/></remote-addr>
<remote-host><xsp-request:get-remote-host/></remote-host>
<userFirstName><xsp-session:get-attribute
name="userFirstName"/></userFirstName>
<userName><xsp-request:get-parameter
name="username"/></userName>
</logonfail>
</source:fragment>
</source:insert>
</esql:no-results>
</esql:execute-query>
</esql:connection>
</authentication>
</xsp:page>
--
thx,
Zoltan Zidarics programmer
PTE University Pecs, Hungary
icq: 43288694
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
