Glad that fixed the problem.

Here is the thing, back to your original problem, the way that you have your method setup right now, it will execute everytime you make a call to it. (Which I am sure you know)

Here is the thing though, to do what you are asking can't be done with 1 update statement UNLESS all columns of all rows are being updated with the same data.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

Oh, yes ... I found that out! (the updating all rows thing)

I added the appropriate WHERE clause and it works much better.

Thanks again,
Karen