You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Gerry Kaplan <gk...@prolifics.com> on 2004/10/28 19:33:08 UTC

Modular Database Question

Below is the database definition for a single simple database. In the
application, the user can click on an image to delete a specific record in
the database. Prior to deletion, a "delete confirm" page is generated and
displayed. In that page, I only need to show a few of the fields, and want
to avoid putting the blob field in the request. Is it possible to create a
tableset that is based on a table but only with a few of the fields in it?

Also, if several modes are specified for a field, are they all executed? I
really could use a few good examples of how an application can leverage
modular database actions.


<root>
	<connection>imweb</connection>
	<table name="reports" alias="reports">
		<keys>
			<key name="ReportId" type="int"
autoincrement="true">
				<mode name="auto-mysql" type="autoincr"/>
			</key>
		</keys>
		<values>
			<value name="UserId" type="string">
				<mode name="session-attr" type="all">
					<parameter>userId</parameter>
				</mode>
			</value>
			<value name="ReportRef" type="string"/>
			<value name="PatName" type="string"/>
			<value name="CreationDate" type="time-stamp">
				<mode name="date" type="all"/>
			</value>
			<value name="ModifiedDate" type="time-stamp">
				<mode name="date" type="all"/>
			</value>
			<value name="ExamDate" type="date"/>
			<value name="ReportXML" type="blob"/>
		</values>
	</table>
	<table-set name="add-report">
		<table name="reports"/>
	</table-set>
</root>


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org