[thesite] evolt's search is blowing up (fwd)

.jeff jeff at members.evolt.org
Thu Feb 7 12:27:01 CST 2002


> From: Dean Mah
> Just a guess... but the ColdFusion code for searching
> has something like:
>    WHERE ...
>       OR content.contentid = #Val(keyword)#
> It seems to me that it is trying to take each searched
> keyword and compare it against the contentid.  When the
> keyword has 'inf' in it, the Val function appears to
> take this as infinite or something and messes up the
> SQL.
> I don't know why the contentid is being compared to the
> keyword when most likely the keyword is a string.

it was an attempt to allow searching by keyword, but not really necessary.


jeff at members.evolt.org

More information about the thesite mailing list