[thelist] SQL statement - What's wrong here?

[Minh Lee Goon]

Well, I got it. But thanks to those who helped. All I needed was single
quotes around my #url.ColleagueID# like so:

<cfquery datasource="Evaluation">
    UPDATE #url.LineNumber#
    SET    Accessed = '1'
    WHERE  ColleagueID = '#url.ColleagueID#'
</cfquery>

I know this is a little weird but it works. Any explanations or is this
right?

</ml>