[Zope-DB] A new DA

[Julián Muñoz]

I am developping a new Zope DA, for dbtcp (see
http://www.fastflow.it/dbtcp/).

I am basing in the ZMysqlDA, well in fact I am not very experimented.

Now, the DA is working, I can do queries from the "test" tab, but not yet
from a ZSQL Method.

For something so simple as calling a method like:

select * from ClientesTabla
where (
CliCodPostalProvin='<dtml-sqlvar prov type=nb>'
)


I have the following error. I have no idea for what is the string_literal
method.



Error, exceptions.AttributeError: string_literal SQL used:

Could not render the query template!

[Powered by Zope]

[Powered by Zope]

Traceback (innermost last):
  File /home/julian/Zope2/lib/python/ZPublisher/Publish.py, line 223, in
publish_module
  File /home/julian/Zope2/lib/python/ZPublisher/Publish.py, line 187, in
publish
  File /home/julian/Zope/lib/python/Zope/__init__.py, line 226, in
zpublisher_exception_hook
    (Object: test_z)
  File /home/julian/Zope2/lib/python/ZPublisher/Publish.py, line 171, in
publish
  File /home/julian/Zope/lib/python/ZPublisher/mapply.py, line 160, in
mapply
    (Object: manage_test)
  File /home/julian/Zope2/lib/python/ZPublisher/Publish.py, line 112, in
call_object
    (Object: manage_test)
  File /home/julian/Zope/lib/python/Shared/DC/ZRDB/DA.py, line 400, in
manage_test
    (Object: test_z)
  File /home/julian/Zope/lib/python/Shared/DC/ZRDB/DA.py, line 378, in
manage_test
    (Object: test_z)
  File /home/julian/Zope/lib/python/Shared/DC/ZRDB/DA.py, line 486, in
__call__
    (Object: test_z)
  File /home/julian/Zope/lib/python/DocumentTemplate/DT_String.py, line
546, in __call__
    (Object: <string>)
  File /home/julian/Zope/lib/python/Shared/DC/ZRDB/sqlvar.py, line 206, in
render
    (Object: prov)
  File /home/julian/Zope2/lib/python/Products/ZdbtcpDA/DA.py, line 130, in
sql_quote__
    (Object: RoleManager)
  File /home/julian/Zope2/lib/python/Products/ZdbtcpDA/db.py, line 343, in
string_literal
AttributeError: (see above)







-- 

      __o
    _ \<_
   (_)/(_)

Saludos de Julián
EA4ACL
-.-

Foro Wireless Madrid
http://opennetworks.rg3.net