[Zope] Weird ZOracle Error: Invalid Character

[Satheesh Babu]

That would be the last semi-colon ";". Remove it and use in the ZSQL method.
Additionally, instead of <dtml-var  ...>, you might want to consider using
<dtml-sqlvar >, which will assist you in properly SQLising the data.
----- Original Message ----- 
From: Ken Kinder <kkinder@messagemedia.com>
To: <zope@zope.org>
Sent: Thursday, March 09, 2000 6:05 PM
Subject: [Zope] Weird ZOracle Error: Invalid Character


> 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
> 
> 

__________________________________________
NetZero - Defenders of the Free World
Get your FREE Internet Access and Email at
http://www.netzero.net/download/index.html