Problem concatenating a string
Posted on 2006-04-05
what i need to do is that when I loop through a recordset i get some ids.
These Ids are in a lump (Start and end)
For each lump(eg numberC_Start and numberC_END )I need to get all the number from start to end
and concatanate it in a string .
How can I do it?
dim numberA_Start as long
dim numberB_Start as long
dim numberC_Start as long
dim numberA_END as long
dim numberB_END as long
dim numberC_END as long
dim strResult as string
EG of a loop
Dim tempFirstNumber as long,tempLastNumber as long,tempStrResult as string
dim rs as adodb.Recorset,Delimiter as string
do while not rs.eof
'//calcuLate all the numbers within first and last and concatanate in a string
Thanks a lot in advance