[Zope] Problem setting values for Z SQL Method

[Michael Bailey]

Hi all,

I'm trying to set a value to be used in a Z SQL method.
I added the following lines to a dtml page but the
method does not see the values 'artist_id'.

<!--#with "_.namespace(artist_id='Fred Nerks')"-->
<!--#in show_artist -->
  <!--#in sequence-item-->
    <!--#var sequence-item-->
  <!--#/in-->
<!--#/in--> 
<!--#/with-->

I tried setting 'artist_id' as a folder property but
that didn't work either. 

I am getting artist_id from another SQL method
as it is an auto_increment value and I need to
use it to add a row to a joining table.

thanks,

Mike Bailey