Re: [Zope] Postgresql Query.

2001-01-17 Thread Stephane Bortzmeyer

On Tuesday 16 January 2001, at 21 h 37, the keyboard of "Jason C. Leach" 
[EMAIL PROTECTED] 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




___
Zope maillist  -  [EMAIL PROTECTED]
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 )




Re: [Zope] Postgresql Query.

2001-01-17 Thread ethan mindlace fremen

--On Wednesday, January 17, 2001 04:33:25 PM +1000 Andrew Kenneth Milton 
[EMAIL PROTECTED] 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

___
Zope maillist  -  [EMAIL PROTECTED]
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 )




Re: [Zope] Postgresql Query.

2001-01-17 Thread Andrew Kenneth Milton

+---[ ethan mindlace fremen ]--
| --On Wednesday, January 17, 2001 04:33:25 PM +1000 Andrew Kenneth Milton 
| [EMAIL PROTECTED] 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|[EMAIL PROTECTED]| 

___
Zope maillist  -  [EMAIL PROTECTED]
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 )




[Zope] Postgresql Query.

2001-01-16 Thread 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).

j.

..
. Jason C. Leach
... University College of the Cariboo.
.. 


___
Zope maillist  -  [EMAIL PROTECTED]
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 )




Re: [Zope] Postgresql Query.

2001-01-16 Thread Andrew Kenneth Milton

+---[ 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|[EMAIL PROTECTED]| 

___
Zope maillist  -  [EMAIL PROTECTED]
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 )




Re: [Zope] Postgresql Query.

2001-01-16 Thread Chris McDonough

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" [EMAIL PROTECTED]
To: "Jason C. Leach" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
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|[EMAIL PROTECTED]|

 ___
 Zope maillist  -  [EMAIL PROTECTED]
 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 )




___
Zope maillist  -  [EMAIL PROTECTED]
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 )