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

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

Dean


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