[Zope] Weird ZOracle Error: Invalid Character

Ken Kinder kkinder@messagemedia.com
Thu, 09 Mar 2000 16:05:33 -0700


This is a multi-part message in MIME format.
--------------DF857783C8AAE0DAAD14BD31
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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


--------------DF857783C8AAE0DAAD14BD31
Content-Type: text/x-vcard; charset=us-ascii;
 name="kkinder.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Ken Kinder
Content-Disposition: attachment;
 filename="kkinder.vcf"

begin:vcard 
n:Kinder;Ken
tel;pager:888.639.9337
tel;work:303.381.7631
x-mozilla-html:FALSE
url:http://www.messagemedia.com/
org:Messagemedia, Inc.;Data Services
adr:;;6060 Spine Road;Boulder;CO;80301;US
version:2.1
email;internet:kkinder@messagemedia.com
title:Database Developer
fn:Ken Kinder
end:vcard

--------------DF857783C8AAE0DAAD14BD31--