On 26/09/2008 14:40, Stephan Szabo wrote:
> Actually, I think the function probably isn't at fault here, string
> literals should be surrounded with ' not ".
Yes, that's true. In addition to that, however, if you look at your
SELECT statement you're selecting all users in the table; the argument
passed to the function isn't used anywhere.
In fairness, you did say that what you posted was a shortened version of
your real function, so maybe something got lost in the shortening...
Ray.
------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------