Please reply to the list, not to personal address.
On Wed, Apr 14, 2010 at 01:43:22PM -0500, j...@qlf.com wrote:
> Thanks for the response. Unfortunately, I'm using MySQL
With MySQL, use function CONCAT:
from sqlobject.sqlbuilder import func
Contact.select(func.CONCAT(Contact.q.name, ' ', Contact.q.surname) == 'Test1
One')
SELECT id, name, surname FROM contact WHERE ((CONCAT(name, ' ', surname)) =
('Test1 One'))
I replaced CONTAINSSTRING with an equality test, just for example.
Oleg.
--
Oleg Broytman http://phd.pp.ru/ p...@phd.pp.ru
Programmers don't die, they just GOSUB without RETURN.
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
