Thanks fo the info!  I had seen those How-Tos... but
was really asking.. How can I use APIs directly
instead of having an External ZSQL method.  I have
created a product and would like to be able to do sql
queries in order to populate members of my class.  For
this example, I have the creation of  a selection box
as a member and the options will be generated by a
select statement.
I have gone through the product creation how to and
was able to add, etc, my object.  I can display html,
make dtml on the fly, etc.. from an object, just
wanted to do a query as well.   .. would like to be
able to do something like the Connection class without
management interface, etc, or use pieces, just not
sure how

--- Jim Penny <[EMAIL PROTECTED]> wrote:
> On Wed, Jun 20, 2001 at 08:54:41AM -0700, Tom Brown
> wrote:
> > I would like to make an SQL query directly from
> python
> > code.  Do I have to make a 
> > ZSQL Method dynamically, or is there another way
> > without making the class database 
> > dependent (i.e. Gadfly, PoPy, etc), utilizing an
> > existing db_con?  Suppose I am using the ZPoPy DA
> and 
> > have established a database connection externally.
> > How can I access this database 
> > and submit a query from my own class?
> You can use an established connection.
> If it is ZSQL based, you will have to deal with the
> results
> object. 
> A good overview of the results object is
> You might also look at the somewhat dated
> This would work from Script (Python), as well.
> Jim Penny 
> > 
> > Thanks,
> > Tom Brown
> > 

Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail

Zope-Dev maillist  -  [EMAIL PROTECTED]
**  No cross posts or HTML encoding!  **
(Related lists - )

Reply via email to