[Zope] Weird ZOracle Error: Invalid Character
Satheesh Babu
vsbabu@csoft.net
Thu, 9 Mar 2000 19:19:40 -0500
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