[Zope-DB] Using ZSQL in ZSQL Methods

Phil Harris phil.harris@zope.co.uk
Fri, 14 Sep 2001 00:50:31 +0100


You can do this with pure sql, you don't need any Zope trickery,

insert into my_table select key, other_data from key_tables where
somecriteria='something';

hth

Phil
----- Original Message -----
From: "James Davis" <davija@wwc.edu>
To: <zope-db@zope.org>
Sent: Friday, September 14, 2001 12:18 AM
Subject: [Zope-DB] Using ZSQL in ZSQL Methods


> I need to be able to run a select statement in a zsql method and use the
> results from that select in the same method.
>
> for example...
>
> select key from key_tables
> <dtml-var sql_delimiter>
> insert into my_table values(
> [key from above select statement],
> other_data
> )
>
>
>
> --------------------------------------------------------------------------
----
> James Davis
> WarChild@Null.net
>                                                     WarTech Software &
Computers
>                                                     210 N. College Ave #1
>                                                     College Place,WA 99324
>                                                     509.526.7624
> http://cs.wwc.edu/~davija
>
>
> _______________________________________________
> Zope-DB mailing list
> Zope-DB@zope.org
> http://lists.zope.org/mailman/listinfo/zope-db