I have the following function which returns a number of values in a string format
Function DBConn(sConnStr, sQuery)
' Set SQL String
set rs = Connect.execute (sql,,adcmdtext)
' Process Record Set
do while not rs.eof = true
' This will display the returned record
returns e.g. invoice name address tel amount
with all the spaces in between. I would like to store each individual value into a dynamic array, how can I Accomplish this task.
Thanks in advance.
TheArray = split(returnedrecord, " ", -1, 1)
There ya go [img]images/icons/smile.gif[/img]
I'm not a complete idiot - some parts are missing.