Thanks Jonah ! Yes, I think you are right, but how do I add columns to the request$init_string ? In your example I end up only with the last column from request$Ttext in the request$init_string. If I'm right it's not possible to add columns with @assign, only rows.
What I am trying to do is to give the user an array for Excel that’s different from the table structure of the database. I don't know the numbers of columns for the Excel array before the user search the database. Best regards Bengt Bredin ----------------------------------------------------------------------- LabIT Solutions AB SWEDEN ----------------------------------------------------------------------- -----Ursprungligt meddelande----- Från: Jonah Simpson [mailto:[EMAIL PROTECTED] Skickat: den 22 december 2003 16:20 Till: [EMAIL PROTECTED] Ämne: Re: Witango-Talk: Array With the code you're using, you're building an array with a comma-delimited list, which is all well and good, but to the best of my knowledge <@var request$Ttext[1,*]> will not output in a comma-delimited format that you need. You should probably just create a new variable and iterate through the cols in Ttext, adding each column as it occurs. <@cols array="request$Ttext"> <@assign request$init_string value=",<@var request$Ttext[1,<@curcol>]>"> </@cols> <@assign name='Excel' value="<@ARRAY VALUE='Sample,Station,Date,Unr/Bnr,Sample_Number,Location,Reference <@var request$init_string>"> Good luck! Cheers, Jonah Simpson [EMAIL PROTECTED] ----- Original Message ----- From: "Bengt Bredin" <[EMAIL PROTECTED]> To: "Witango-Talk" <[EMAIL PROTECTED]> Sent: Monday, December 22, 2003 8:12 AM Subject: Witango-Talk: Array | | Hey list ! | | I would like to say Merry Christmas to you all and at the same time ask | for some help concerning a problem I have. | | I have a one row array <@var TText> with x numbers of columns in it. | Then I would like to create a new array, also one row with 7 named | columns and the <@var TText> columns added. | What happens is that I only get the <@var TText> columns in the new | array. | | <@assign name='Excel' value="<@ARRAY VALUE='Sample,Station,Date,Unr/Bnr, | Sample_Number,Location,Reference,<@var request$Ttext[1,*]>'> "> | | What am I doing wrong ? | | | Best regards | | Bengt Bredin | ----------------------------------------------------------------------- | LabIT Solutions AB | SWEDEN | ----------------------------------------------------------------------- | | | ________________________________________________________________________ | TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf