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

Minh Lee Goon v7ac at sdsumus.sdstate.edu
Fri Jul 7 09:39:58 CDT 2000


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>




More information about the thelist mailing list