>From everyone's silence, I'm guessing this can't be done with the included database action. Can it be done with the modular database actions, or am I going to have to write my own?
Thanks, J -----Original Message----- From: Jacob Arnold [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 02, 2003 2:01 PM To: '[EMAIL PROTECTED]' Subject: Getting Parameters from a Database Action I'm having trouble getting some parameters from a database add action. The key param is passed through fine, but the value param is not. I'm using Cocoon 2.0.3. The pipeline in my sitemap is as follows: <map:match pattern="timesheets/add-activity.html"> <map:act set="process"> <map:parameter name="descriptor" value="descriptors/activity.xml"/> <map:aggregate element="document"> <map:part src="cocoon:/menu.xsp" strip-root="true"/> <map:part src="cocoon:/timesheets/add-activity.xsp?TimesheetDetail_ID={TimesheetDetail _ID}&TimesheetMaster_ID={TimesheetMaster_ID}" strip-root="true"/> </map:aggregate> <map:transform src="stylesheets/encode-html.xsl"/> <map:serialize/> </map:act> <map:aggregate element="document"> <map:part src="cocoon:/menu.xsp" strip-root="true"/> <map:part src="cocoon:/timesheets/add-activity.xsp" strip-root="true"/> </map:aggregate> <map:transform src="stylesheets/encode-html.xsl"/> <map:serialize/> </map:match> A portion of my descriptor is below: <table name="TimesheetDetail"> <keys> <key param="id" dbcol="TimesheetDetail_ID" type="long" mode="manual"/> </keys> <values> <value param="TimesheetMaster_ID" dbcol="TimesheetMaster_ID" type="long"/> </values> </table> So I'm getting TimesheetDetail_ID, but in my core.log I see the following for TimesheetMaster_ID: WARN [core.manager] (/encode/timesheets/add-activity.html) Thread-8/AbstractSitemap: Substitute: value not found for TimesheetMaster_ID while evaluating cocoon:/timesheets/add-timesheet.xsp?TimesheetDetail_ID={TimesheetDetail_ID} &TimesheetMaster_ID={TimesheetMaster_ID} I've tried {../TimesheetMaster_ID} and other variations. Any ideas? I'd rather not switch to modular database actions just yet. Thanks, J --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]> --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>