Postgresql Query.
hi, I'd like to learn a bit more on how to do a SQL query on a postgres DB from Zope. Like how to do it, what is better DTML or Python for it, and how would I do it in DTML (I can probably get python working fine). j. ...................... ..... Jason C. Leach ... University College of the Cariboo. ..
+-------[ Jason C. Leach ]---------------------- | hi, | | I'd like to learn a bit more on how to do a SQL query on a postgres DB | from Zope. Like how to do it, what is better DTML or Python for it, and | how would I do it in DTML (I can probably get python working fine). You have to use a ZSQL Method to access databases from Zope. You don't necessarily need to use ZSQL Methods from Python Products, but, in reality this turns out to be rather more convenient. Normally, I would tell you to visit; http://www.zope.org/Documentation/ but, some monkey has designed the interface w/o actually testing it, since there's no direct references to the online ZSQL Reference there any more, and the online dtml reference shoves you into dtml-var. Go to there, and then expand Zope Help in the left hand pane, and then near the bottom there will be some stuff on ZSQL Methods. Pretty poor compared to the online reference that used to be available. There also used to be direct links to downloadable PDF docs -- also gone. I know a lot of people weren't happy with the level of documentation, but, removing useful (even if it wasn't the best) information from the documentation pages isn't the solution. -- Totally Holistic Enterprises Internet| P:+61 7 3870 0066 | Andrew Milton The Internet (Aust) Pty Ltd | F:+61 7 3870 4477 | ACN: 082 081 472 ABN: 83 082 081 472 | M:+61 416 022 411 | Carpe Daemon PO Box 837 Indooroopilly QLD 4068 |akm@theinternet.com.au|
Looks like all the guides are still available at http://www.zope.org/Documentation/Guides (although, agreed, no one would ever suspect such a thing). ----- Original Message ----- From: "Andrew Kenneth Milton" <akm@mail.theinternet.com.au> To: "Jason C. Leach" <jleach@mail.ocis.net> Cc: <zope@zope.org> Sent: Wednesday, January 17, 2001 1:33 AM Subject: Re: [Zope] Postgresql Query.
+-------[ Jason C. Leach ]---------------------- | hi, | | I'd like to learn a bit more on how to do a SQL query on a postgres DB | from Zope. Like how to do it, what is better DTML or Python for it, and | how would I do it in DTML (I can probably get python working fine).
You have to use a ZSQL Method to access databases from Zope. You don't necessarily need to use ZSQL Methods from Python Products, but, in reality this turns out to be rather more convenient.
Normally, I would tell you to visit;
http://www.zope.org/Documentation/
but, some monkey has designed the interface w/o actually testing it, since there's no direct references to the online ZSQL Reference there any more, and the online dtml reference shoves you into dtml-var.
Go to there, and then expand Zope Help in the left hand pane, and then near the bottom there will be some stuff on ZSQL Methods. Pretty poor compared to the online reference that used to be available.
There also used to be direct links to downloadable PDF docs -- also gone.
I know a lot of people weren't happy with the level of documentation, but, removing useful (even if it wasn't the best) information from the documentation pages isn't the solution.
-- Totally Holistic Enterprises Internet| P:+61 7 3870 0066 | Andrew Milton The Internet (Aust) Pty Ltd | F:+61 7 3870 4477 | ACN: 082 081 472 ABN: 83 082 081 472 | M:+61 416 022 411 | Carpe Daemon PO Box 837 Indooroopilly QLD 4068 |akm@theinternet.com.au|
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
--On Wednesday, January 17, 2001 04:33:25 PM +1000 Andrew Kenneth Milton <akm@mail.theinternet.com.au> wrote:
Normally, I would tell you to visit;
http://www.zope.org/Documentation/
but, some monkey has designed the interface w/o actually testing it, since there's no direct references to the online ZSQL Reference there any more, and the online dtml reference shoves you into dtml-var.
Monkey fix! bannana? -- ethan mindlace fremen zopatista community liason
+-------[ ethan mindlace fremen ]---------------------- | --On Wednesday, January 17, 2001 04:33:25 PM +1000 Andrew Kenneth Milton | <akm@mail.theinternet.com.au> wrote: | | > Normally, I would tell you to visit; | > | > http://www.zope.org/Documentation/ | > | > but, some monkey has designed the interface w/o actually testing it, | > since there's no direct references to the online ZSQL Reference there | > any more, and the online dtml reference shoves you into dtml-var. | | Monkey fix! bannana? No banana for you! Bad Monkey! And stop breaing into the female monkey cages... -- Totally Holistic Enterprises Internet| P:+61 7 3870 0066 | Andrew Milton The Internet (Aust) Pty Ltd | F:+61 7 3870 4477 | ACN: 082 081 472 ABN: 83 082 081 472 | M:+61 416 022 411 | Carpe Daemon PO Box 837 Indooroopilly QLD 4068 |akm@theinternet.com.au|
On Thursday 18 January 2001 07:45, Andrew Kenneth Milton wrote:
+-------[ ethan mindlace fremen ]----------------------
| --On Wednesday, January 17, 2001 04:33:25 PM +1000 Andrew Kenneth Milton | | <akm@mail.theinternet.com.au> wrote: | > Normally, I would tell you to visit; | > | > http://www.zope.org/Documentation/ | > | > but, some monkey has designed the interface w/o actually testing it, | > since there's no direct references to the online ZSQL Reference there | > any more, and the online dtml reference shoves you into dtml-var. | | Monkey fix! bannana?
No banana for you! Bad Monkey! And stop breaing into the female monkey cages...
now, *this* should be in the Andy's quote ssite LOL -- http://www.kedai.com.my/kk http://www.kedai.com.my/eZine use Zope? then you got HOPE!
On Tuesday 16 January 2001, at 21 h 37, the keyboard of "Jason C. Leach" <jleach@mail.ocis.net> wrote:
I'd like to learn a bit more on how to do a SQL query on a postgres DB from Zope.
I find it well explained in the Zope Book: http://www.zope.org/Members/michel/ZB/RelationalDatabases.html
participants (6)
-
Andrew Kenneth Milton -
Bak@kedai -
Chris McDonough -
ethan mindlace fremen -
Jason C. Leach -
Stephane Bortzmeyer