Am 17.06.2007, 00:14 Uhr, schrieb Ken Winter <[EMAIL PROTECTED]>:

  title: Method to delete one Person by id
  connection_id: dhatabase
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
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 Clark

Professional Python Services directly from the Source
Python/Zope Consulting and Support ...
mxODBC.Zope.Database.Adapter ...   
mxODBC, mxDateTime, mxTextTools ...

:::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,MacOSX for free ! :::: 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

Reply via email to