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: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>