Re: set_sql and like '%$searchTerm%'

[prev] [thread] [next] [Date index for 2004/09/15]

On Tue, Sep 14, 2004 at 03:03:49PM -0500, Michael Jensen wrote:
> Any ideas?

Hi Michael,

Have you tried running that SQL statement directly via a database shell
(e.g., psql or mysql)? If that seems to work, then my next step is to
turn on database tracing and see what is actually being returned. There
is a recipe on the wiki[1] with an example.


Good luck,
William

[1] http://class-dbi.com/cgi-bin/wiki/index.cgi?SeeAllSQL

        -- 
        Knowmad Services Inc.
http://www.knowmad.com