Re: [SQLObject] Search for Full Name

[Oleg B. <ph...@ph...>]

Please reply to the list, not to personal address.

On Wed, Apr 14, 2010 at 01:43:22PM -0500, ji...@ql... 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/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.