[thelist] ASP: More Selective Select

[Ken Schaefer]

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Lonnie" <kr43m0r at earthlink.net>
Subject: Re: [thelist] ASP: More Selective Select


: rudy, et al:
:
: : you can only use a table name in sql syntax where a table name
: is allowed
:
: I can relate one situation where hungarian notation for
: tables/fields IS valuable. Suppose you change one of
: those names and need to do a GSR on a whole site. e.g.
: I had a table called "addresses", that was changed (don't
: ask why). Had I named it tblAddresses, my global search
: and replace would have been much easier.
:
: 2 cents,
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

This kinda assumes that you have all your SQL statements embedded within
your other code (eg your presentation stuff)

If you had your queries stored in your database, or, some kind of separate
layer (or even just separate files) for your data manipulation, then it
probably would have been easier...

My $0.02 :-)

Cheers
Ken