this is the authentication resoruce in my application:

                <map:pipeline internal-only="false">
                        <!-- This is the authentication resource -->
                        <map:match pattern="authenticate">
                                <map:generate src="docs/do-login.xml"/>
                                <map:transform type="sql" label="debug1">
                                        <map:parameter name="username" 
value="{request-param:username}"/>
                                        <map:parameter name="password" 
value="{request-param:password}"/>
                                        <map:parameter name="show-nr-of-rows" 
value="true"/>
                                        <map:parameter name="use-connection" 
value="mysql"/>
                                </map:transform>
                                <map:transform src="stylesheets/authenticate.xsl" 
label="debug2"/>
                                <map:serialize type="xml"/>
                        </map:match>
                </map:pipeline>

and this is the xml generated by the generator you can see above:

<authenticate xmlns:sql="http://apache.org/cocoon/SQL/2.0";
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"; >
      <sql:execute-query > 
                <sql:query name="authentication">
                                SELECT 
                                uid,
                                username,
                                password 
                                FROM users 
                                WHERE username= ' <sql:substitute-value 
sql:name="username"/> '  
                                AND password = ' <sql:substitute-value 
sql:name="password"/>'; 
                </sql:query>
      </sql:execute-query>
</authenticate>

why in the sql:substitute-value i cannot get any value?

pleas help me...

-- 
copyright - fabpicca

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

Reply via email to