[Zope] Trouble with ZSQL method

[Tom Jenkins]

Devin L. Ganger wrote:
[snip]
> Yes, servicename is defined as a parameter.
> 
[snip]
> 
>   <dtml-var expr="sql.test_select_single()">
> 

doesn't look like to me that you are passing the method any parameters. 
  what happens if you do...

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

>   </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?
> 
> 



-- 
Tom Jenkins
devIS - Development Infostructure
http://www.devis.com