[ZWeb] dtml-var sql_delimiter
Mike Tran
mtran@shufflemasterrd.com
Tue, 21 May 2002 08:27:49 -0600
Thanks. I've read quite a few online docs, howtos, and examples on
sql_delimiter but none of them mention that. Most of them said that
sql_delimiter is use like a semicolon in SQL.
On Mon 20 May 02 20:03, you wrote:
> On Mon, 20 May 2002, Mike Tran wrote:
> > I was able to do each select statement seperately, but when combined I
> > get a Query Error: "Multiple select schema not allowed"
>
> This error is explicit. What it doesn't tell you is what subsystem
> generated the error. That is, the problem isn't in mysql or the
> DA, the issue is that ZSQL methods can only handle one select
> statement at a time. You can have multiple non select statements
> (eg: multiple updates or inserts), but at most one select.
>
> You might want to subscribe to zope@zope.org (see mailing lists
> under resources). This quesiton is appropriate for that forum.
>
> --RDM
--
Mike Doanh Tran
Shuffle Master Gaming Inc.