Hi

Someone please help me out with this:

I am passing a string in this format (215,216) from the python script to
the Zsql method.
The SQl query should have the following form:
select * from employees where id in (215,216)
but is as follows:
select * from employees where id in '(215,216)' which does not give the required result.The id is of data type string/nb. It doesnt accept integer values.



A sample usage is given in the Zope documentation **************************************** select * from employees <dtml-sqlgroup where> <dtml-sqltest salary op="gt" type="float" optional> <dtml-and> <dtml-sqltest first type="nb" multiple optional> <dtml-and> <dtml-sqltest last type="nb" multiple optional> </dtml-sqlgroup>

If first=Bob and last=Smith, McDonald it renders:

select * from employees
where
(first='Bob'
and
last in ('Smith', 'McDonald')
)

*****************************************8
But it is not working when I tried it. I get the following result

select * from employees
where
(first='Bob'
and
last = 'Smith,McDonald'
)

Please help me out!!Is there any other type for declaring the database fields other than int,float,string and nb.I am using Zope version 2.5.1 . The documentation covers Zope 2.5.

Thanks
Anitha

_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail



_______________________________________________
Zope-Dev maillist - [EMAIL PROTECTED]
http://mail.zope.org/mailman/listinfo/zope-dev
** No cross posts or HTML encoding! **
(Related lists - http://mail.zope.org/mailman/listinfo/zope-announce
http://mail.zope.org/mailman/listinfo/zope )

Reply via email to