How to I create blank columns using QueryAddColumn?

Hi:

I need to dymanically create a number of columns using the queryAddColumn function.

I was going to use the loop below. That way each column would have a generic dynamically created name.

The problem I'm encountering is that when running that code I get an error that says: "The column name (Detail1) that you specified already exists in this query".

I'm guessing something isn't quite right since apparently on the second iteration of this loop the column name isn't updating to "Detail2".

Any ideas? As always, thanks in advance!! =)

re: How to I create blank columns using QueryAddColumn?

...or perhaps the query already has a column named Detail1. Is this.RecordSet an empty query before the loop?

re: How to I create blank columns using QueryAddColumn?

Try this:

Or try dynamic variables - lookup Evaluate function.

Good luck - CM

re: How to I create blank columns using QueryAddColumn?

cymark, welcome to Bytes and thanks for your contribution.

You could do away with the pound signs in the cfset statement, i.e.
In this case, however, the code that you've posted won't make a difference because it does recognise "#I#" to be 1 (see error message).

re: How to I create blank columns using QueryAddColumn?

Hi,

Sorry was a bit quick there.

The following seems to work OK:

Creates cols with Detail1, .. to Detail5

Hope it helps...