[Zope] Trouble with ZSQL method

Devin L. Ganger Devin L. Ganger" <devin@thecabal.org
Wed, 5 Sep 2001 19:35:53 -0700


Hello, all.  Apologies in advance for the long lines in the error message.

I'm running Solaris 7, Zope 2.3.3, MySQL 3.23.28-gamma, ZMySQLDA 2.0.7,
and MySQLdb 0.9.0.

I'm trying to get the following ZSQL method name sql_select_single
 to work:

  select servicedesc, serviceid as parentid
  from z_service
  where <dtml-sqltest servicename op=eq type=string>

Yes, servicename is defined as a parameter.

When I test it manually, it's great.  When I try to test it with
the following bit of DTML:

  <dtml-let servicename="'CIP'">

  <p class="bodynorm">
    <dtml-var servicename>
  </p>

  <dtml-var expr="sql.test_select_single()">

  </dtml-let>

I get the following wonderful error:

Zope Error
Zope has encountered an error while publishing this resource.

Error Type: Bad Request
Error Value: ['servicename']

--------------------------------------------------------------------------------

Troubleshooting Suggestions

The URL may be incorrect. 
The parameters passed to this resource may be incorrect. 
A resource that this resource relies on may be encountering an error. 
For more detailed information about the error, please refer to the HTML source for this page. 

If the error persists please contact the site maintainer. Thank you for your patience. 

Traceback (innermost last):
  File /usr/local/src/Zope-2.3.3-solaris-2.6-sparc/lib/python/ZPublisher/Publish.py, line 223, in publish_module
  File /usr/local/src/Zope-2.3.3-solaris-2.6-sparc/lib/python/ZPublisher/Publish.py, line 187, in publish
  File /usr/local/src/Zope-2.3.3-solaris-2.6-sparc/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook
    (Object: Traversable)
  File /usr/local/src/Zope-2.3.3-solaris-2.6-sparc/lib/python/ZPublisher/Publish.py, line 171, in publish
  File /usr/local/src/Zope-2.3.3-solaris-2.6-sparc/lib/python/ZPublisher/mapply.py, line 160, in mapply
    (Object: index_html)
  File /usr/local/src/Zope-2.3.3-solaris-2.6-sparc/lib/python/ZPublisher/Publish.py, line 112, in call_object
    (Object: index_html)
  File /usr/local/src/Zope-2.3.3-solaris-2.6-sparc/lib/python/OFS/DTMLMethod.py, line 189, in __call__
    (Object: index_html)
  File /usr/local/src/Zope-2.3.3-solaris-2.6-sparc/lib/python/DocumentTemplate/DT_String.py, line 540, in __call__
    (Object: index_html)
  File /usr/local/src/Zope-2.3.3-solaris-2.6-sparc/lib/python/OFS/DTMLMethod.py, line 182, in __call__
    (Object: index_docs)
  File /usr/local/src/Zope-2.3.3-solaris-2.6-sparc/lib/python/DocumentTemplate/DT_String.py, line 540, in __call__
    (Object: index_docs)
  File /usr/local/src/Zope-2.3.3-solaris-2.6-sparc/lib/python/DocumentTemplate/DT_Let.py, line 149, in render
    (Object: servicename="'CIP'")
  File /usr/local/src/Zope-2.3.3-solaris-2.6-sparc/lib/python/DocumentTemplate/DT_Util.py, line 339, in eval
    (Object: sql.sql_select_single())
    (Info: sql)
  File <string>, line 0, in ?
  File /usr/local/src/Zope-2.3.3-solaris-2.6-sparc/lib/python/Shared/DC/ZRDB/DA.py, line 476, in __call__
    (Object: sql_select_single)
  File /usr/local/src/Zope-2.3.3-solaris-2.6-sparc/lib/python/Shared/DC/ZRDB/Aqueduct.py, line 150, in _argdata
    (Object: sql_select_single)
Bad Request: (see above)

What am I doing wrong?

-- 
Devin L. Ganger <devin@thecabal.org>
A man, a miss, a car -- a curve,
He kissed the miss and missed the curve -- Burma Shave (1948)