true, very true....but...it was a stupid simple one time use page written to scrub a bad db with bad data ;) was trying to do it in as little code as possible the fastest way i could do it !!!
scope tony, scope, YOU IIIIIDIOTTTTT (like ren, or was it stimpy?) -----Original Message----- From: Sean A Corfield [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 4:58 PM To: CF-Talk Subject: Re: state a reserved word in cf? On Thursday, Sep 4, 2003, at 12:16 US/Pacific, Tony Weeg wrote: > using variables.state outputs it fine. > using just state doesn't work...here is the code. > the data had city, state in 1 field with a / at the end > so I had to clean that up...anyway, running that > with state doesn't work, but variables.state works. You have a conflict between your query column names and your variable names! That's why using scope-qualified variable names is better practice! Sean A Corfield -- http://www.corfield.org/blog/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
