Re: [Zope] zgadfly and zsql problem
In article <00b201bfdcf9$5bb7e8d0$6200a8c0@longwy>, Luc Tonin writes >i m using da zgadfly database >and i m still trying to use this type of query >SELECT * >FROM table_name >WHERE field_name LIKE 'test' > >but it s seems that zgadfly doesn t support da LIKE sql tag! >anyone have an ID ??? It doesn't AFAIK. -- Regards, Graham Chiu gchiucompkarori.co.nz http://www.compkarori.co.nz/index.php Powered by Interbase and Zope ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] zgadfly and zsql problem
[...] >but it s seems that zgadfly doesn t support da LIKE sql tag! >anyone have an ID ??? >From gadfly FAQ: """ Where is the LIKE predicate? The LIKE predicate for string matching is still not supported at the SQL level. For what it's worth, it is easy to use Python's string matching (regex, re, string.search, etcetera) facilities on the result of a query. Also, for what it's worth, since the gadfly optimizer won't easily be able to optimize for string matching the "by hand" method would essentially be what gadfly would do anyway, without major modifications to the implementation. """ Adam Karpierz [EMAIL PROTECTED] ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] zgadfly and zsql problem
i m using da zgadfly database and i m still trying to use this type of query SELECT * FROM table_name WHERE field_name LIKE 'test' but it s seems that zgadfly doesn t support da LIKE sql tag! anyone have an ID ???