Is there way to do global changes to SQL in ASP pages

[johnston]

We have over 100 asp pages that reference a table (distribution_c omponents).
We added a new column and primary key to that table, so now we have to modify
the where clause to include that column (we have to make the new column = to a
session variable in the page)

The table appears 531 times in our code. Is there some util or method that
allows us to change it globally, other than going to each occurrance, and
adding the new column to the where clause

[johnston]

In article <eu************ **@TK2MSFTNGP10 .phx.gbl>, "Chris Hohmann" <hohmannATyahoo DOTcom> wrote:

That being said, another option available to you is to the following:

1. Call the new table distribution_co mponents_new
2. Create a view/saved query called distribution_ta ble based on the new
table which reproduces the old table with the appropriate where clause
applied.

I don't know what the session variable is but I suspect it's something
available from the database. Could you provide some more details?

the session variable is from the web page, its not in the database.

[Chris Hohmann]

"johnston" <jo******@thot. com> wrote in message
news:3f******** *************** @newscene.com.. .

In article <eu************ **@TK2MSFTNGP10 .phx.gbl>, "Chris Hohmann"

<hohmannATyahoo DOTcom> wrote:

That being said, another option available to you is to the following:

1. Call the new table distribution_co mponents_new
2. Create a view/saved query called distribution_ta ble based on the new
table which reproduces the old table with the appropriate where clause
applied.

I don't know what the session variable is but I suspect it's something
available from the database. Could you provide some more details?

the session variable is from the web page, its not in the database.

What is it? When is it created? Can it be stored in the database?