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
dnelson@stripped
