[thelist] SQL Query Review

Joshua Olson joshua at waetech.com
Tue Apr 22 12:29:31 CDT 2008


> -----Original Message-----
> From: Randal Rust
> Sent: Tuesday, April 22, 2008 1:23 PM
> 
> >  >   $entryTitle=$rs->fields[1];
> >
> > i don't do php, but i think you're leaving yourself open 
> > for disaster if you ever change the sequence of the columns 
> > in the SELECT clause
> 
> ok, i see what you are saying. and yes, i would tend to agree with
> you, but if i change the order of the select, then i always make sure
> to run it though the test environment first. this ensures that
> something like that doesn't happen.

I agree wholeheartedly with Rudy.  Coding in a manner that necessitates
extra debugging... Well, there's just gotta be a better way.

Joshua

<><><><><><><><><><>
Joshua L. Olson
WAE Technologies, Inc.
Augusta, Georgia Web Design
http://www.waetech.com/
Phone: 706.210.0168
Fax: 707.988.0168
Private Enterprise Number: 28752

Portfolio:
http://www.waetech.com/design/portfolio/

Monitor bandwidth usage on IIS6 in real-time:
http://www.waetech.com/services/iisbm/ 



More information about the thelist mailing list