update multiple rows from one table

[kabbi~thkek]

Hi,
I have a Dynamically created formfield. Tgis field shows the attached devices
off a selected device (for instance you have a pc and in the formfields it
shows two attached monitors). The monitors however are in the same database
table. (with an other device_id ofcourse). The page with the pc info is shown
by using the device_id in the URL.

What I want to do is update some fields in this table for the pc but also for
the attached devices....

When I do it like this:

UPDATE dev SET .... etc.
WHERE device_id IN ('#FORM.koppel_2#')

It selects both device id's like this: WHERE dev_volgnr IN ('602,603')
This doesn't work! However in this example the table should be updated for
the devices with device_id 602 and 603.

Is this possible? How would I do that?

Thanks in advance.

Gr, Kabbi

[philh]

Hi kabbi~thkek,


WHERE dev_volgnr IN ('602,603') won't work. If your keys are integers, you
need to get rid of the single quotes. If your keys are characters, you need to
enclose each value in single quotes, not the whole string.

HTH,

[kabbi~thkek]

Thank you! I figured it out...