Hit here. I'v 2 databases (GadFly) that have different data. I wish to join some data using a ZSQL method. I have something like: SELECT table1.colum1, table2.colum1 FROM table1, table2 WHERE table1.colum1 = table2.colum1 Until this step everything is working fine... The problem appears when I want to compare the result of the above query (taht is working ok) with some data that only exists in the table2 and in table1. I want to get some data from the table1 that I compare in table2 (table1.colum1 = table2.colum1) and them I only want the data that the in the table1.colum1 is equal to 1 and 2 and in the table2 where above 0 (zero) in the colum2 and the colum3 < than the actual date. I try to put something like: SELECT table1.colum1, table2.colum1 FROM table1, table2 WHERE table1.colum1 = table2.colum1 AND table2.colum2 > 0 AND table2.colum3 < <dtml-var expr="_.float(_.DateTime())"> AND table1.colum1 = 1 OR table1.colum1 = 2 This query is getting ZOPE to time out and it only works again with a restart... Can anyone help me with this? Thanks a lot, José Monte P.S. - sorry for my extremely bad english. _________________________________________________________________ Express yourself with cool new emoticons http://www.msn.co.uk/specials/myemo
On Jan 14, 2005, at 21:42, José Monte wrote:
Hit here.
I'v 2 databases (GadFly) that have different data. I wish to join some data using a ZSQL method.
Have you considered switching to a *real* database? Gadfly is not recommended for anything beyond playing. Try PostGreSQL or MySQL instead. jens --------------- Jens Vagelpohl jens@zetwork.com Software Engineer +49-(0)441-36 18 14 38 Zetwork GmbH http://www.zetwork.com/
On Jan 14, 2005, at 22:23, Jens Vagelpohl wrote:
Have you considered switching to a *real* database? Gadfly is not recommended for anything beyond playing. Try PostGreSQL or MySQL instead.
Don't. Try FrontBase instead: http://www.frontbase.com/ Not open source, but they have a free license (E-Starter). Runs pretty much everywhere as well. Cheers -- PA http://alt.textdrive.com/
On Jan 14, 2005, at 22:30, PA wrote:
On Jan 14, 2005, at 22:23, Jens Vagelpohl wrote:
Have you considered switching to a *real* database? Gadfly is not recommended for anything beyond playing. Try PostGreSQL or MySQL instead.
Don't. Try FrontBase instead:
Not open source, but they have a free license (E-Starter).
Runs pretty much everywhere as well.
Getting kickbacks from those folks, eh? LOL jens
On Jan 14, 2005, at 22:46, Jens Vagelpohl wrote:
Getting kickbacks from those folks, eh?
Even though they provide a free license, I wish I could get some "referral" fees :o)
LOL
Just had too much pain and suffering dealing with all those odd MySQL/PostgreSQL idiosyncrasies. FrontBase is a no-brainer to use and, as an added bonus, is fully SQL 92 compliant. It even knows what Unicode is :) Cheers -- PA http://alt.textdrive.com/
You didn't SELECT table2.colum2 or table2.column3 so it probably doesn't exist for your comparison. I don't know if the DateTime may be giving any problem. On Fri, 2005-01-14 at 15:42, =?UNKNOWN?Q?Jos=E9?= Monte wrote:
Hit here.
I'v 2 databases (GadFly) that have different data. I wish to join some data using a ZSQL method.
I have something like:
SELECT table1.colum1, table2.colum1 FROM table1, table2 WHERE table1.colum1 = table2.colum1
Until this step everything is working fine... The problem appears when I want to compare the result of the above query (taht is working ok) with some data that only exists in the table2 and in table1.
I want to get some data from the table1 that I compare in table2 (table1.colum1 = table2.colum1) and them I only want the data that the in the table1.colum1 is equal to 1 and 2 and in the table2 where above 0 (zero) in the colum2 and the colum3 < than the actual date.
I try to put something like:
SELECT table1.colum1, table2.colum1 FROM table1, table2 WHERE table1.colum1 = table2.colum1 AND table2.colum2 > 0 AND table2.colum3 < <dtml-var expr="_.float(_.DateTime())"> AND table1.colum1 = 1 OR table1.colum1 = 2
This query is getting ZOPE to time out and it only works again with a restart...
Can anyone help me with this?
Thanks a lot,
Jos Monte
P.S. - sorry for my extremely bad english.
_________________________________________________________________ Express yourself with cool new emoticons http://www.msn.co.uk/specials/myemo
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
participants (4)
-
Jens Vagelpohl -
Jos� Monte -
PA -
Thomas Bennett