Mailing-List: contact users-help@cocoon.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@cocoon.apache.org
Received-SPF: pass (herse.apache.org: domain of jdwilliams@austin.rr.com
 designates 24.93.47.41 as permitted sender)
Subject: RE: Authentication Framework and database
From: "J.D. Williams" <jdwilliams@austin.rr.com>
To: users@cocoon.apache.org
In-Reply-To: <00c501c75bd9$8d716c00$a6a4269e@win.uninett.no>
References: <1172588115.28880.9.camel@jdw-desktop>
	 <20070227152529.GC23750@localhost.localdomain>
	 <1172606231.29875.11.camel@jdw-desktop>
	 <00c501c75bd9$8d716c00$a6a4269e@win.uninett.no>
Content-Type: text/plain
Date: Thu, 01 Mar 2007 08:52:41 -0600
Message-Id: <1172760761.5709.0.camel@jdw-desktop>
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit

Thanks for your effort, though.

On Thu, 2007-03-01 at 09:13 +0100, Armaz Mellati wrote:
> Hi
> 
> 
> It seems to me you are doing this wrong : 
> 	<sql:substitute-value name="request-param:username"/> 
> Replace that with
> 	<sql:substitute-value name="username"/>
> 
> 
> Look carefully at http://cocoon.apache.org/2.1/userdocs/sql-transformer.html right bbelow "Substitution".
> 
> Hope it helps.
> 
> Regards
> Armaz 
> 
> > -----Original Message-----
> > From: J.D. Williams [mailto:jdwilliams@austin.rr.com] 
> > Sent: Tuesday, February 27, 2007 8:57 PM
> > To: users@cocoon.apache.org
> > Subject: Re: Authentication Framework and database
> > 
> > Thought it might be some whitespace from careless XSL 
> > writing, but I got rid of the superfluous whitespace (I 
> > think) and still no luck.
> > 
> > I could use another set of eyes on this to help me see what I 
> > am missing.
> > 
> > The login page is the one from the authentication framework sample in
> > 2.1.9
> > 
> > The only changes I have made to the sitemap are the 
> > authentication resource, as follows:
> > 
> >     <map:pipeline internal-only="true">
> >        <map:match pattern="authenticate">
> >        <map:generate src="docs/sql-page.xml"/>
> >        <map:transform type="sql">
> >           <map:parameter name="use-connection" value="sandbox"/>
> >           <map:parameter name="show-nr-of-rows" value="true"/>
> >           <map:parameter name="username"
> > value="{request-param:username}"/>
> >        </map:transform>
> >         <map:transform src="stylesheets/sql2xml.xsl">
> >           <map:parameter name="use-request-parameters" value="true"/>
> >         </map:transform>
> >         <map:serialize type="xml"/>
> >       </map:match>
> >     </map:pipeline>
> > 
> > Using this query in the sql-page.xml:
> > 
> > <page>
> >   <content>
> >     <sql:execute-query xmlns:sql="http://apache.org/cocoon/SQL/2.0">
> >       <sql:query>select * from user where name = 
> > '<sql:substitute-value name="request-param:username"/>'</sql:query>
> >     </sql:execute-query>
> >   </content>
> > </page>
> > 
> > And using this XSL:
> > 
> > <?xml version="1.0"?>
> > 
> > <xsl:stylesheet version="1.0"
> >                 xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
> >                 xmlns:sql="http://apache.org/cocoon/SQL/2.0">
> > 
> >   <xsl:template match="/page/content/sql:rowset/sql:row">
> >         <authentication
> > xmlns:session="http://apache.org/cocoon/session/1.0">
> >           <xsl:apply-templates select="sql:name"/>
> >         </authentication>
> >   </xsl:template>
> >   
> > <xsl:template match="sql:name">
> >   <ID>
> >   <xsl:value-of select="."/>
> >     </ID>
> > </xsl:template>
> >   
> > </xsl:stylesheet>
> > 
> > 
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> > For additional commands, e-mail: users-help@cocoon.apache.org
> > 
> > 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org


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