[Zope] Editing SQL methods from Emacs (+ FTP server)?

[Steve Spicklemire]

> I'm trying to get a list of lists using ZSQL Methods...
> 
> I have two related tables, hounds and items.
> 
> I want to get the hound_id in items like this but can't work out how to pass
> the hound_id variable...
> 
> <dtml-in get_hounds>
> 
> <b><dtml-var name> <dtml-var id></b>
> 
> <dtml-in "get_items(hound_id='id')">

<dtml-in "get_items(hound_id = id)">

should work. Be careful... id is an unfortunate field name for your
database.. there may be a namespace collision with the Zope notion of
id. If this turns out to be a problem, post again and we can suggest
some work-arounds.... 

-steve

> <dtml-var title><br>
> 
> </dtml-in>
> </dtml-in>
> 
> 
> _______________________________________________
> 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 )
>