[Zope-dev] External method pulling data from an SQL method?

[Michel Pelletier]

> -----Original Message-----
> From: julian@zereau.net [mailto:julian@zereau.net]
> Sent: Friday, March 05, 1999 9:31 AM
> To: zope-dev@zope.org
> Subject: [Zope-dev] External method pulling data from an SQL method?
> 
> 
> I am using PostgreSQL's array system for a "categories" field 
> in a database, it
> return records in a format like:
> '{"foo"}'
> '{"foo","bar"}'
> '{"foo"}'
> 
> I am trying to extract the list of unique categories - in 
> this example:
> ["foo","bar"]
> 
> This would be a complete nuisance to do in DTML. I have 
> decided to read the SQL
> method's results into an external method and edit them there 
> - but first I need
> to know how to call a SQL method without the "in" DTML tag.
> 

An SQL method is like any other method.  If you want to call it from an
external method, you could try this:

<untested>

<!--#var "myExternalMethod(this())"-->

...

def myExternalMethod(self):
	self.mySQLMethod()

</untested>

This is just a sketch, but I hope you get the idea.  You don't need the
#in tag to call an SQL method, you can even call it with a #var tag, if
you don't mind the output.

-Michel

> Or maybe there is a simpler solution to all this, for any 
> PostgreSQL gurus out
> there??
> 
> ---
> Julian Morrison
> Programmer (Zereau Ltd)
> 
> _______________________________________________
> Zope-Dev maillist  -  Zope-Dev@zope.org
> http://www.zope.org/mailman/listinfo/zope-dev
>