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

Dean Mah dmah at shaw.ca
Thu Feb 7 10:57:01 CST 2002

Just a guess... but the ColdFusion code for searching has something

   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.


Michele Foster writes:

> Why does it happen on info or information ?  but I can get results
> just fine on many other query combinations?
> The curious one,
> Mich
> ----- Original Message -----
> From: "Dean Mah" <dmah at shaw.ca>
> | For some reason, the content.contentid is being checked for INF (check
> | the second last line of the query).  INF is not a valid column name.
> |
> | Dean

More information about the thesite mailing list