[Zope] Generating sequence UID?

[LD Landis]

Hi,

  I have a ZSQL method db_sequence(name) which increments the 'id' of
  sequence 'name'...  When run ('view') it prompts for the name, and
  returns a result that has the title 'id' and the next value.  So far so
  good.

  Now, I want to have another db_contact() method that gets its stuff from
  REQUEST, which I have working, but I have been unable to get db_contact()
  to call db_sequence('contact_id').  I've tried various syntactic things
  and haven't won yet...

  The following is not any of the variety of things I've tried, but I hope
  suggests what I want:

    db_sequence(name)			(What I have works, even if not
      update sequence set id = id + 1	 exactly this)
      where name = <dtml-sqlvar name type=string>

    db_category(--no parameters--)
      insert into category (category_id, name, field...field) values (
      <dtml-call db_sequence('category')>,
      <dtml-with REQUEST>
      <dtml-sqlvar name type=string>,
      <dtml-sqlvar ...  type=string>,
                   ...
      <dtml-sqlvar ...  type=string>
      </dtml-with>
    )

--
Cheers,
	--ldl
-----------------------------------------------------------------------------
LD Landis ldl@HealthPartners.Com N0YRQ    Voice 612/883-5511 Fax 612/883-6363
HealthPartners, 8100 34th Avenue So, PO Box 1309, Minneapolis, MN  55440-1309
Shape your life not from your memories, but from your hopes.       (Borrowed)
-----------------------------------------------------------------------------