Hello Kevin, Yeah, I'll probably do what you suggested below. There's just a lot of possible blank fields from the query getting returned and I was looking for a shortcut from having to type a bunch of cfif's for every field output.
Also, thanks to all the others who responded, I appreciate it. -- Chris Montgomery [EMAIL PROTECTED] Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-3249/888-745-7603> You can't change the value of a query result (I think) Tuesday, May 21, 2002, 3:40:25 PM, you wrote: > Scope your variable. #Company# in the query is different from company > set using <cfset> one is in the variables scope the other is in the > scope of the query. > Why not do this: > <cfif company neq ""> > Blah Blah > <cfelse> > #company# > </cfif> ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
