Page: http://wiki.cocoondev.org/Wiki.jsp?page=Lenya , version: 19 on Sat Jun 14 00:21:35 2003 by BillHumphries
+ * [LenyaCreatePageWalkthrough] Page: http://wiki.cocoondev.org/Wiki.jsp?page=DataypesOfDatabaseActions , version: 1 on Sat Jun 14 00:35:34 2003 by AntonioGallardo New page created: + Both types of [Database Actions] support the follwing data types to interact with Databases. + + All supported Datatypes by group: + + ||Group||Data Types|| + |datetime|{{date}}, {{time}}, {{timestamp}}, {{now}}| + |images related| {{image}}, {{image-width}}, {{image-height}}, {{image-size}}, {{image-mime-type}}| + |large Objects|{{ascii}}, {{binary}}| + |literal|{{byte}}, {{string}} + |numeric|{{big-decimal}}, {{double}}, {{float}}, {{int}}, {{long}}, {{short}}| + + + List of Dataypes in alphabethical order + + ||Type||Description|| + |{{ascii}}|an ASCII input stream, a CLOB input| + |{{big-decimal}}|A {{java.math.BigDecimal}} value. a Big Integer| + |{{binary}}|A binary input stream, a BLOB input| + |{{byte}}|A Byte| + |{{string}}|A String| + |{{date}}|A Date| + |{{double}}|A Double| + |{{float}}|A Float| + |{{int}}|A Integer| + |{{long}}|A Long| + |{{short}}|A Short| + |{{time}}|A Time| + |{{time-stamp}}|A Timestamp| + |{{now}}|A Timestamp with the current day/time--the form value is ignored.| + |{{image}}|A binary image file, we cache the attribute information| + |{{image-width}}|The width attribute of the cached file attribute. "NOTE: param attribute must equal the param for image with a __-width__ suffix."| + |{{image-height}}| The width attribute of the cached file attribute "NOTE: param attribute must equal the param for image with a __-height__ suffix." + |{{image-size}}|The size attribute of the cached file attribute. "NOTE: Param attribute must equal the param for image with a __-size__ suffix."| + Page: http://wiki.cocoondev.org/Wiki.jsp?page=ModularDatabaseActions , version: 7 on Sat Jun 14 00:56:56 2003 by AntonioGallardo - The descriptor file resembles the one for the [Original Database Actions]. Note the absence of {{dbcol}} and {{param}} attributes. + The descriptor file resembles the one for the [Original Database Actions]. Note the absence of {{dbcol}} and {{param}} attributes. See the [list of supported data types| DataypesOfDatabaseActions]. It has 2 new attributes: - * The new {{name}} attribute specifies the database column name and corresponds to the old {{dbcol}} attribute. ? -------- ^^^^^^^^^ ^ ^^^^^ + * {{name}} - Specifies the database column name. Corresponds to the old {{dbcol}} attribute. ? ^ ^ + ^ - * The {{autoincrement}} attribute indicate if a column is of this type. Autoincrement columns will be handled differently on insert operations. ? ---- ^^^^^^^^^ ^ + * {{autoincrement}} - Indicate if a column is of this type. Autoincrement columns will be handled differently on insert operations. ? ^ ^ - Everything said above about the __Key Columns__ applies to value columns as well. Except for the __autoincrement__ attribute. + Everything said above about the __Key Columns__ applies to value columns as well. Except for the __autoincrement__ attribute. See the [list of supported data types| DataypesOfDatabaseActions]. ? +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Page: http://wiki.cocoondev.org/Wiki.jsp?page=OriginalDatabaseActions , version: 5 on Sat Jun 14 00:36:49 2003 by AntonioGallardo + * {{type}} -- the [type | DataypesOfDatabaseActions] of the column. - * {{type}} -- the type of the column (see below) - - !Supported database types: - - Here is the list of all supported Datatypes: - - ||Group||Data Types|| - |binary|{{binary}}| - |literal|{{ascii}}, {{byte}}, {{string}} - |datetime|{{date}}, {{time}}, {{timestamp}}, {{now}}| - |numeric|{{big-decimal}}, {{double}}, {{float}}, {{int}}, {{long}}, {{short}}| - |images related| {{image}}, {{image-width}}, {{image-height}}, {{image-size}}, {{image-mime-type}}| - - Detailed Description of Dataypes - - ||Type||Description|| - |{{ascii}}|an ASCII input stream, a CLOB input| - |{{big-decimal}}|A {{java.math.BigDecimal}} value. a Big Integer| - |{{binary}}|a binary input stream, a BLOB input| - |{{byte}}| A Byte| - |{{string}}| A String| - |{{date}}|A Date| - |{{double}}| A Double| - |{{float}}| A Float| - |{{int}}| A Integer| - |{{long}}| A Long| - |{{short}}| A Short| - |{{time}}| A Time| - |{{time-stamp}}|A Timestamp| - |{{now}}|a Timestamp with the current day/time--the form value is ignored.| - |{{image}}|a binary image file, we cache the attribute information| - |{{image-width}}|the width attribute of the cached file attribute. NOTE: param attribute must equal the param for image with a "-width" suffix.| - |{{image-height}}| The width attribute of the cached file attribute NOTE: param attribute must equal the param for image with a "-height" suffix. - |{{image-size}}|The size attribute of the cached file attribute. NOTE: Param attribute must equal the param for image with a "-size" suffix.| Page: http://wiki.cocoondev.org/Wiki.jsp?page=DatabaseActions , version: 7 on Sat Jun 14 00:21:44 2003 by AntonioGallardo - The actions can be combined into an [ActionSet], or can be referenced directly from a pipeline. If the action succeeds then it's contents are evaluated. + The actions can be combined into an [ActionSet], or can be referenced directly from a [pipeline]. If the action succeeds then it's contents are evaluated. ? + + + See also: + * [Dataypes of Database Actions] list of all the Datatypes supported by both types of Database Actions. - See also [Form Validation Using Cocoon] before you send the record to the database. ? ^^^^^^^^ + * [Form Validation Using Cocoon] before you send the record to the database. ? ^
