Return-Path: 
 <cocoon-users-return-44246-apmail-xml-cocoon-users-archive=xml.apache.org@xml.apache.org>
Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org
Received: (qmail 44035 invoked by uid 500); 23 Dec 2002 07:29:19 -0000
Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:cocoon-users-help@xml.apache.org>
list-unsubscribe: <mailto:cocoon-users-unsubscribe@xml.apache.org>
list-post: <mailto:cocoon-users@xml.apache.org>
Reply-To: cocoon-users@xml.apache.org
Delivered-To: mailing list cocoon-users@xml.apache.org
Received: (qmail 44024 invoked from network); 23 Dec 2002 07:29:19 -0000
Subject: Authentication and
To: cocoon-users@xml.apache.org
X-Mailer: Lotus Notes Release 5.0.10  March 22, 2002
Message-ID: 
 <OF09C355C8.4A3E9C25-ONC1256C98.00286826-C1256C98.002926CD@viaginterkom.de>
From: Johannes.Becker@o2.com
Date: Mon, 23 Dec 2002 08:29:28 +0100
MIME-Version: 1.0
X-MIMETrack: Serialize by Router on MUC0LM05/SPOKE/o2-Germany(Release 5.0.11
  |July 24, 2002) at
 12/23/2002 08:29:28 AM,
	Itemize by SMTP Server on MUC8LX02/SPOKE/VIAGInterkom(Release 5.0.8 |June
 18, 2001) at 23.12.2002 08:29:28,
	Serialize by Router on MUC8LX02/SPOKE/VIAGInterkom(Release 5.0.8 |June 18,
 2001) at
 23.12.2002 08:29:28,
	Serialize complete at 23.12.2002 08:29:28
Content-type: text/plain; charset=us-ascii
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

Hi,

I'm trying out the sample "protected area".
The auth.xml looks like this:

<?xml version="1.0" encoding="UTF-8"?>

<!--
This file is used for description of auth process
you specify here all columns that should be retrieved from specified
database table and to which request parameters they should be compared.
Values you specify can be automatically propagated to the created session
-->
<auth-descriptor>
  <connection>personnel</connection>
  <table name="employee">
    <!--
    because dbcol user has also matching request parameter, it will be used
    for actual authentication, department_id will not be compared with
    anything, it will just be along with username propagated to the session
    -->
    <select dbcol="name" request-param="username" to-session="username"/>
    <select dbcol="department_id" to-session="department_id" type="long"/>
  </table>
</auth-descriptor>
<!-- vim: set et ts=2 sw=2: -->

Let's say I want a select-statement like that: "SELECT userid  from
employee WHERE userid='FirstParameter' AND password='SecondParameter'"
How would this look like in the "<select dbcol" row. Can I do that in one
row, or do I have to do that in two rows? Or what else?


Regards
Jonny

----------------------------------------------------------------------------------------------------

This electronic message contains information from the mmo2 plc Group which
may be
privileged or confidential. The information is intended to be for the use
of the
individual(s) or entity named above. If you are not the intended recipient
be aware
that any disclosure, copying, distribution or use of the contents of this
information
is prohibited. If you have received this electronic message in error,
please notify
us by telephone or email (to the numbers or address above) immediately.




---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>