Exclude a URL from a Query

[papostolos]

I want to exclude the page url contained in a variable called SentURL from my query but I have been unsuccessful This is my sql statement

<SQL ROW MAX=4
"select 'http://' + Url Url, Depth, Title, Body, length(Body) Size,
id, $$rank r
from html
where Title\Meta\Body likep $q
and Title like $tq
and Url matches $uq
and Depth <= $dq
">

I thought just to insert

and URL != $SentURL

at the end but that doesn't work I get an error

SQLExecute() failed with -1 in the function execntexis

Please help

[mark]

That should work, except that the Url field name is not all caps. If you still have problems please supply exactly what you did that produced the error.