On Sunday 12 February 2006 23:48, Derek Hohls wrote:
>
> You description here is a little limited, but, I assume
> you have sucessfully authenticated a user and have an
> ID for them.
Yes, that is correct. The user is authenticated using the
DatabaseAuthenticatorAction and two variables (sid and survey) are stored in
the session using the tosession attribute (as strings).
> You could then call a flow script, which picks up the ID
> from the session; the SQL could be run from inside flow
> and the result then stored in a new session attribute.
> You are correct in saying there is a not a single description
> of this activity in the docs; but you will be able to find the
> info you need by looking at the samples, and also searching
> the mail archives.
Thanks for pointing me to the samples. They helped but didn't solve my
problem.
Here are the details.
Sitemap Pipeline Matcher:
<map:match pattern="test/query">
<map:act type="mod-db-sel">
<map:parameter name="descriptor"
value="web/system/db/descriptor.xml"/>
<map:parameter name="table-set" value="students"/>
<map:parameter name="output" value="session"/>
<map:call resource="debug-params">
<map:parameter name="param1" value="{session-attr:sid}"/>
<map:parameter name="param3" value="{session-attr:survey}"/>
<map:parameter name="param4" value="Success!"/>
<map:parameter name="param5"
value="{session-attr:students.survey}"/>
</map:call>
</map:act>
<map:call resource="debug-params">
<map:parameter name="param1" value="{session-attr:sid}"/>
<map:parameter name="param3" value="{session-attr:survey}"/>
<map:parameter name="param4" value="Failure!"/>
<map:parameter name="param5"
value="{session-attr:students.survey}"/>
</map:call>
</map:match>
The debug-params resource simply displays these parameter names and values.
I learned from the samples that you can pass an output parameter to the
modular database actions. What about the input?
Database Descriptor:
<?xml version="1.0" encoding="UTF-8"?>
<root>
<connection>cacsurvey</connection>
<table name="students0506">
<keys>
<key name="sid" type="int"/>
</keys>
<values>
<value name="survey" type="boolean"/>
</values>
</table>
<table-set name="students">
<table name="students0506"/>
</table-set>
</root>
{session-attr:sid} and {session-attr:survey} were set from the initial
authentication. The survey field for this particular SID gets updated in the
database using an Original Database Update action. What I am trying to do is
to use {session-attr:sid} to query the database record, retrieve the latest
survey column value, and store it into {session-attr:survey}. It doesn't
matter whether I use Original or Modular actions but I would like to use
actions as opposed to flowscript.
- Pasha
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
