[Zope] Weird ZOracle Error: Invalid Character

9 Mar 2000

      I'm getting a weird invalid character error on my ZSQL Method using
ZOracle... If anyone could help, I would appreciate it:

I have a method with the following params:

    id username password firstname lastname title deskphone cellphone
pagerphone emailaddr soffice_id sprdarea_id

And the following query text:

    insert into suser
      (id, username, password, firstname, lastname,
       title, deskphone, cellphone, pagerphone,
       emailaddr, soffice_id, sprdarea_id)
    values
      (<dtml-var id>,
       '<dtml-var username>',
       '<dtml-var password>',
       '<dtml-var firstname>',
       '<dtml-var lastname>',
       '<dtml-var title>',
       '<dtml-var deskphone>',
       '<dtml-var cellphone>',
       '<dtml-var pagerphone>',
       '<dtml-var emailaddr>',
       <dtml-var soffice_id>,
       <dtml-var sprdarea_id>);

When I test it with example feild values, it renders the following
error:

    Error, oci.error: (911, 'ORA-00911: invalid character\012')

With this SQL Used (which if you try in SQL*Plus, is perfectly valid):

    insert into suser
      (id, username, password, firstname, lastname,
       title, deskphone, cellphone, pagerphone,
       emailaddr, soffice_id, sprdarea_id)
    values
      (15476,
       'kkinder',
       'foo',
       'Ken',
       'Kinder',
       'Database & Web Guru',
       '303 381 7631',
       'None',
       'None',
       'kkinder@messagemedia.com',
       0,
       0);

Any words of wisdom?

--
Ken Kinder
303.381.7631