It works. I put in an extra comma before the WHERE statement.
At 02:35 PM 6/19/2002 -0500, you wrote:
>In the last episode (Jun 19), Won Lee said:
> > Hi everyone,
> > I'm slowly starting to learn the nuances of MySQL. I searched the
> > HTML docs on mysql.com but the subject matter is so broad that I'm
> > flooded with possible matches. I read through some of the docs but I
> > still don't have a solution.
> > UPDATE RFSMs
> > SET
> > approved = 1,
> > WHERE RFSMID IN (#variables.approvedID#)
> > While this should works in MSSQL Server, I haven't tested it out yet,
> > I know it won't work in mySQL.
>That should work, assuming "#variables.approvedID#" is with a single
>integer, or a list of comma-dalimited ones. What mysql does not
>support is WHERE .. IN ( SELECT ... ) - i.e. subselects.
> Dan Nelson