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