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 Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db