I am trying to tie together a series of SQL processors that are processing
a query then an update and using Xupdate to update the instance with the
key from the query and the status of the insert.
If on the XUpdate processor, I set the input named 'data' to the instance
and 2 additional inputs to be the outputs of the SQL processors, the SQL
processors are not executing according to the debug events within the
Studio.
If I change the 'data' input to the output of the first SQL processor and
'newKey' to the instance
The first SQL processor executes and returns a valid key. But now the
output of my processor is only the key and not the updated instance with
the key.
<p:otherwise>
<p:processor name="oxf:sql">
<p:input name="data" href="#instance" />
<p:input name="config">
<sql:config>
<sql:connection>
<sql:datasource>
DB</sql:datasource>
<sql:execute>
<sql:query>
....
</sql:query>
<sql:results>
<sql:row-results>
<info>
<key>
<sql:get-column type=
"xs:string" column="Key"/>
</key>
</info>
</sql:row-results>
</sql:results>
</sql:execute>
</sql:connection>
</sql:config>
</p:input>
<p:output name="data" id="newKey"/>
</p:processor>
<p:processor name="oxf:sql">
<p:input name="data" href="#newKey"/>
<p:input name="config">
<sql:config>
<sql:connection>
<sql:datasource>
DB</sql:datasource>
<sql:execute>
<sql:update>
....
</sql:update>
</sql:execute>
<status>Inserted new</status>
</sql:connection>
</sql:config>
</p:input>
<p:output name="data" id="insertOutput" />
</p:processor>
<p:processor name="oxf:xupdate"
xmlns:p="http://www.orbeon.com/oxf/pipeline";>
<p:input name="config">
...
</p:input>
<p:input name="data" href="#instance"/>
<p:input name="newKey" href="#newKey"/>
<p:input name="insertStatus" href="#insertOutput"/>
<p:output name="data" ref="data" debug=
"instanceWithKeyAndStatus"/>
</p:processor>
</p:otherwise>
Thanks
Wes Smoak
Computer Scientist
Exceed Development
CSC
803 333 6025
----------------------------------------------------------------------------------------
This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery. NOTE: Regardless of content, this e-mail shall not operate to
bind CSC to any order or other contract unless pursuant to explicit written
agreement or government initiative expressly permitting the use of e-mail
for such purpose.
----------------------------------------------------------------------------------------
-------------------------------------------------------
This SF.Net email is sponsored by: InterSystems CACHE
FREE OODBMS DOWNLOAD - A multidimensional database that combines
robust object and relational technologies, making it a perfect match
for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8
_______________________________________________
orbeon-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/orbeon-user
