Lloyd Kvam writes:
 > .... 
 >   T. J. Mannos has written
 > how to apply wrappers to html to turn them into DTML Documents.  I could not
 > find any equivalent description for Z SQL Methods.
A Z SQL Method uses a template (in fact a DTML template with additional
commands) to construct a command (in fact a sequence of commands)
to a database from the arguments provided and its context.

Thus, you have 2 options:

  1.  if your operations fall into well defined classes
      easily described by a DTML template with arguments,

      then you define a Z SQL method for each of these templates.


      Arguments: TableName ColumnName ColumnType

        MODIFY <dtml-var TableName>
        ADD COLUMN <dtml-var ColumnName> <dtml-var ColumnType>

  2.  otherwise, you define a very general Z SQL method

      Arguments: command
        <dtml-var command>

      and build your "command" with any appropriate tool
      (e.g. an external method or Python script)
      and pass it as a parameter.

      Be *VERY* careful, not to make such a Z SQL method accessible
      from the Internet, as it allows very malicious operations
      on your system!

You will probably go for option 1.


Zope maillist  -  [EMAIL PROTECTED]
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-dev )

Reply via email to