Sorry about that test letter earlier, I guess the to has been changed from
the old [EMAIL PROTECTED] to this new one.
Anywho ....
Can one use placeholders in a update on the Microsoft SQL 7.0 server?
I have an example (from http://w3.one.net/~jhoffman/sqltut.html) and it only
shows updating one row with one value. But in my configuration, I may have
as many as 30 rows to update. So I am trying to figure out how this would be
done.
The example from earlier shows the following:
UPDATE ANTIQUES SET PRICE= 500.00 WHERE ITEM = 'Chair';
But mine will be more like
UPDATE ROW1, ROW2, ROW3 WHERE ITEM = 'row1','row2','row3';
I don't think the above is even a valid SQL statement. Does anyone have
experience in dealing with this multiple update stuff?
thanks
Scott Purcell
