[Zope] Multiple Inserts Using Sybase DAV

[tgraham@speakeasy.net]

I'm not 100% sure with Sybase, but it sounds like you need to use the <dtml-var sql_delimiter> between the two insert 
statements.

For example 

Insert into table_one (values)
       <dtml-sqlvar values type="string">

<dtml-var sql_delimiter>

Insert into table_two (values)
       <dtml-sqlvar values type="string">



On 24 Jan 2002, Kia A. Arab wrote:

> Hi, I'm creating a web application where users
> can submit and retrieve library resources
> online. The backend of this application is a
> Sybase database. I use two tables: one that
> stores a unique id, title, author, name, etc.
> And another that stores keywords related to
> the resource for searching purposes. All this
> information is captured on one form. The
> keywords are captured in a list by way of the
> Python cgi module.
>
> The problem I'm having is inserting this
> information into the two tables. I can easily
> insert the title, author, etc info into one
> table. But, when I try to put the keywords in
> a separate table, it fails.
>
> Seems like a simple task but I'm at a loss.
> Does anyone have any suggestions. And please
> also email me directly since I'm not
> subscribed to this list. Thank you, Kia
>
> Here is my insertAction. The appropriate
> parameters are in the argument list:
>
> INSERT into lib_entry ( submitter, office_num,
> resource_type, resource_title,
> resource_author, resource_pubdate,
> resource_abstract) VALUES ( <dtml-sqlvar
> submitter type="string">, <dtml-sqlvar
> office_num type="string">, <dtml-sqlvar
> resource_type type="string">, <dtml-sqlvar
> resource_title type="string">, <dtml-sqlvar
> resource_author type="string">, <dtml-sqlvar
> resource_pubdate type="string">, <dtml-sqlvar
> resource_abstract type="string">)
>
> After this, how do I insert the keywords?
>
> _____________________________________________-
> __
> Zope maillist - Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope **
> No cross posts or HTML encoding! ** (Related
> lists - http://lists.zope.org/mailman/listinf-
> o/zope-announce http://lists.zope.org/mailman-
> /listinfo/zope-dev )