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