Are you sure that the {request-param:username} in the sitemap
actually contains a value; what happens if you put actual data
in there  eg.

  <map:parameter name="username" value="me"/> 
  <map:parameter name="password" value="secret"/>



>>> [EMAIL PROTECTED] 2004/09/20 10:20:38 PM >>>
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] 


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
MailScanner thanks transtec Computers for their support.


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

Reply via email to