[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