sql and access question using IN statement

[darrankavanagh]

hi,
i am trying to pull all records from a table using the statement

Select * from messages where message_id in (5,6,7)
(is this correct syntax)
"message_id" is an AutoNumber field

i then update the "message_activated" fields to yes in my database that i get from the above sql.

The problem is that message_id 5 only gets updated.... and nothing happens to 6 and 7
anyone know why

Thanks

 

[r937]

yes, that's the correct syntax, and if it's not updating all three then there's something wrong with your logic that constructs the update statement

but why do you retrieve them first?

why not just update the rows based on the same id numbers without selecting them first?

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts March 6 2005)

 

[PHV]

In access you may try this:
UPDATE messages
SET message_activated = Yes
WHERE message_id In (5, 6, 7);

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244