[thelist] ASP: More Selective Select

rudy r937 at interlog.com
Thu Jul 3 20:02:25 CDT 2003

> 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...

i put every CFQUERY into a CFINCLUDE whether it needs it or not

that way, i can reuse a query easily

it makes the surrounding code easier to read, too

plus, of course, there is query caching, and i will modify the queries to
make this easier to achieve

for example, if two separate pages need similar data, i will "supersize" the
queries so that both pages can share the same query

i.e. if page 1 wants SELECT A,B,C  and page 2 wants SELECT B,C,D then i will
write the query as SELECT A,B,C,D and let both pages CFINCLUDE it

and in a case where all pages need the same query, like the query that
fetches the nav bar, it is obvious that CFINCLUDEing the identical query on
every page makes query caching simple (since even a slight difference in the
sql makes it a different query)

yes, i've done global search and replace myself too, but hardly ever on sql


More information about the thelist mailing list