query2excel

hi eric, i tried that as well but didnt work, same error was coming up >It looks like my postings aren't making it to the list again...your problem >was that you had the +1 inside the # signs ie #query.recordcount+1# when it >should be #query.recordcount#+1  The first is looking for a variable named >"query.recordcount+1" that doesn't exist. > >Eric > >/*-----Original Message----- >/* >/*Sent: Tuesday, April 15, 2008 3:14 PM >/*To: CF-Talk >/*Subject: Re: query2excel >/* >/*GOT IT!!! >/* >/*i managed to fool it seeing as the + 1 wasn't working >/* >/*i added an empty row into the query <cfset queryaddrow(finalQuery)> >/* >/*and it then had the same affect as finalQuery.recordcount+1 and it went >/*through fine :) >/* >/*thanks for all your help and suggestions, this must be a bug in this >/*component and i will def look at the other component suggested on here for >/*enhanced flexibility >/* >/*thanks again >/* >/*