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

Dean Mah dmah at shaw.ca
Wed Feb 6 14:29:00 CST 2002


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


Daniel J. Cody writes:

> ORA-00904: invalid column name
>
>
> SQL = "SELECT content.contentid, content.contentname, content.synopsis,
> content.datemod, content.rating, content.ratings, content.replies,
> content.signoff, users.userid, users.who, users.email, categorys.category,
> categorys.categoryid, (SELECT Count(*) FROM replies WHERE contentid =
> content.contentid AND datemod > '18-Jan-02') AS newcomments FROM content,
> users, categorys WHERE content.categoryid = categorys.categoryid AND (
> Lower(content.synopsis) LIKE '%information design%' OR
> Lower(content.contentname) LIKE '%information design%' OR Lower(users.who)
> LIKE '%information design%' OR Lower(users.email) LIKE '%information
> design%' OR content.contentid = INF ) AND content.userid = users.userid AND
> content.signoff = 1 ORDER BY content.datemod DESC"



More information about the thesite mailing list