forum.vdsworld.com Forum Index forum.vdsworld.com
Visit VDSWORLD.com
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 


FYI: Getting column info from TABLE element (VDS5)

 
Post new topic   Reply to topic    forum.vdsworld.com Forum Index -> Knowledge Base
View previous topic :: View next topic  
Author Message
NathanH
Valued Newbie


Joined: 05 Sep 2001
Posts: 32

PostPosted: Thu Jul 17, 2003 5:17 pm    Post subject: FYI: Getting column info from TABLE element (VDS5) Reply with quote

It took me an hour to work out some TABLE issues, and thought I'd jot down my findings, as the help file and sample script don't go into any detail on getting the data of each column into variables.

The code is simply...

Code:
OPTION FIELDSEP,@TAB()
PARSE "%%COLUMN1;%%COLUMN2;%%COLUMN3",@ITEM(TABLE1)
OPTION FIELDSEP,|


What threw me was not setting the FIELDSEP option back. If you don't, then the LIST ADD command... ie

Code:
LIST ADD,TABLE1,%%COLUMN1@TAB()%%COLUMN2@TAB()%%COLUMN3


...will only add the first column into the table.

If I fix up the tabletest demo script included with VDS5, would Commercial Research be interested in using it in future updates so people have a better example to go by?

Hope that helps someone Wink

Nathan
Back to top
View user's profile Send private message
Serge
Professional Member
Professional Member


Joined: 04 Mar 2002
Posts: 1480
Location: Australia

PostPosted: Sat Sep 13, 2003 8:59 am    Post subject: Reply with quote

thanks nathanh...just what i was looking for Smile

serge

_________________
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
Display posts from previous:   
Post new topic   Reply to topic    forum.vdsworld.com Forum Index -> Knowledge Base All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum

Twitter@vdsworld       RSS

Powered by phpBB © 2001, 2005 phpBB Group