Am 17.06.2007, 00:14 Uhr, schrieb Ken Winter <[EMAIL PROTECTED]>:
<dtml-comment>
title: Method to delete one Person by id
connection_id: dhatabase
arguments:
person_id
</dtml-comment>
delete from person
where person_id = <dtml-var person_id>
"
When I tried to delete a couple of People using this I got the error
message:
"
ProgrammingError: column "none" does not exist
You should be using <dtml-sqlvar person_id type="int"> here but in any
case no argument is being passed in: the error is coming from the DTML
rendering of a missing key argument.
I don't know about your file system product for this as all my ZSQL's live
in the ZODB but I assume all the meta-data is contained in the
<dtml-comment> section. Any chance you can test your stuff on a standard
Zope (non-filesystem) setup? I think that's where the problem is. FWIW you
might want to call the query or execute methods directly on the DA
connection object if they are supported.
Charlie
--
Charlie Clark
eGenix.com
Professional Python Services directly from the Source
Python/Zope Consulting and Support ... http://www.egenix.com/
mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/
mxODBC, mxDateTime, mxTextTools ... http://python.egenix.com/
________________________________________________________________________
:::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,MacOSX for free ! ::::
eGenix.com Software, Skills and Services GmbH Pastor-Loeh-Str.48
D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
Registered at Amtsgericht Duesseldorf: HRB 46611
_______________________________________________
Zope-DB mailing list
[email protected]
http://mail.zope.org/mailman/listinfo/zope-db
