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

rudy limeback r937 at interlog.com
Fri Jul 7 09:05:11 CDT 2000


> The students select a course line number from a drop-down list 
> and enter their Colleague ID numbers into a text box
>
><cfquery datasource="Evaluation">
>    UPDATE #url.LineNumber#
>    SET    Accessed = '1'
>    WHERE  ColleagueID = #url.ColleagueID#
></cfquery>

hi minh

i'm guessing you need to do something like

    UPDATE yourTable
    SET    Accessed = '1'
    WHERE  LineNumber = #url.LineNumber#
          AND ColleagueID = #url.ColleagueID#


rudy.limeback
r937.com
evolt.org





More information about the thelist mailing list