[Zope] ZSQLMethods

2000-12-04 Thread Tom Deprez
Hi, I'm wondering how the following can be done. I've 2 databases. I want to do a 'join' with 2 tables, both in a different database. Is it possible to retrieve data of both tables with a ZSQLMethod and then do a programatically join? What's the easiest python way? Thanks, Tom.

Re: [Zope] ZSQLMethods

2000-12-04 Thread Chris Gray
You want something along these lines: dtml-in selectFromTable1 dtml-in expr="selectFromTable2(id=_['id'])" display record /dtml-in /dtml-in This would be more efficient than pulling out the whole of two tables. Chris On Mon, 4 Dec 2000, Tom Deprez wrote: Hi, I'm

Re: [Zope] ZSQLMethods

2000-12-04 Thread Tom Deprez
to query database2 Is there another way to do this? (more efficient?, ie less database query) Tom. - Original Message - From: "Chris Gray" [EMAIL PROTECTED] To: "Tom Deprez" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, December 04, 2000 3:45 PM Subject: Re: [Zope

Re: [Zope] ZSQLMethods

2000-12-04 Thread Chris Gray
ber 04, 2000 3:45 PM Subject: Re: [Zope] ZSQLMethods You want something along these lines: dtml-in selectFromTable1 dtml-in expr="selectFromTable2(id=_['id'])" display record /dtml-in /dtml-in This would be more efficient than pulling out the whole of tw

Re: [Zope] ZSQLMethods

2000-12-04 Thread Chris Gray
ot; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, December 04, 2000 3:45 PM Subject: Re: [Zope] ZSQLMethods You want something along these lines: dtml-in selectFromTable1 dtml-in expr="selectFromTable2(id=_['id'])" display reco

Re: [Zope] ZSQLMethods

2000-12-04 Thread Phil Harris
MAIL PROTECTED] Sent: Monday, December 04, 2000 3:21 PM Subject: Re: [Zope] ZSQLMethods Try something like: dtml-in selectFromTable1 dtml-in selectFromTable2 dtml-if idFromTable1 = idFromTable2 display parts of the two records /dtml-if /dtml-in /dtml-in Thi

Re: [Zope] ZSQLMethods

2000-12-04 Thread Tom Deprez
- From: "Phil Harris" [EMAIL PROTECTED] To: "Chris Gray" [EMAIL PROTECTED]; "Tom Deprez" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, December 04, 2000 5:06 PM Subject: Re: [Zope] ZSQLMethods Depending on the number of records in the tables this could g

Re: [Zope] ZSQLMethods

2000-12-04 Thread Chris Gray
mber 04, 2000 3:21 PM Subject: Re: [Zope] ZSQLMethods Try something like: dtml-in selectFromTable1 dtml-in selectFromTable2 dtml-if idFromTable1 = idFromTable2 display parts of the two records /dtml-if /dtml-in /dtml-in This keeps it to tw

Re: [Zope] ZSQLMethods

2000-12-04 Thread Stefan H. Holek
On Mon, 4 Dec 2000, Tom Deprez wrote: Thanks, is this code still efficient if the tables relate to 1:1 and you need to show a list of all records in a tabulare table? eg key, NAME, ALIAS, where NAME is from database1 and ALIAS is from database2 The code below would impact that

Re: [Zope] ZSQLMethods

2000-12-04 Thread Dieter Maurer
Tom Deprez writes: I'm wondering how the following can be done. I've 2 databases. I want to do a 'join' with 2 tables, both in a different database. Is it possible to retrieve data of both tables with a ZSQLMethod and then do a programatically join? What's the easiest python way?

RE: [Zope] ZSQLMethods

2000-12-04 Thread Richard Folwell
I've 2 databases. I want to do a 'join' with 2 tables, both in a different database. Is it possible to retrieve data of both tables with a ZSQLMethod and then do a programatically join? What's the easiest python way? If you are using ODBC then the EasySoft SQL Engine might solve your