[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