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]