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

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


dean,

><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> 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

http://evolt.org/
jeff at members.evolt.org
http://members.evolt.org/jeff/





More information about the thesite mailing list