You can always use an "ISNULL" in your query...different for each database... to make sure it has a value even if the field is blank.
-----Original Message----- From: Valerie L. Criswell [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 1:19 PM To: CF-Talk Subject: Re: variables not let go I have noticed this in a nested loop/query situation. I just had to make a workaround for it. ~Val ----- Original Message ----- From: "Tony Weeg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 02, 2002 2:28 PM Subject: variables not let go > has anyone noticed when they have a query > that returns lets say for example the variable called > CompanyName, and on the 3rd loop through the results > the variable CompanyName is undefined and then > value of CompanyName from the 2nd row shows > up as the value of the 3rd row? > > ..tony > > Tony Weeg > Senior Web Developer > Information System Design > Navtrak, Inc. > Fleet Management Solutions > www.navtrak.net > 410.548.2337 > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
