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.
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
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
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
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
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
-
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
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
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
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?
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
11 matches
Mail list logo