GetRows() & Arrays...

[j1c]

I have the following:

dim app_ids, irowloop, icolloop
app_ids = get_app_logins(session("stremail"))
for irowloop = 0 to ubound(app_ids, 2)
for icolloop = 0 to ubound(app_ids, 1)
response.write(app_ids(icolloop, irowloop) & ",")
next 'icolloop
response.write("|")
next 'irowloop

That returns:
0,0,bobsmith,pAssWord,|0,71,tom,tom,|0,71,tomf,pAssWord,|1,5,tom,a1,|
Is it possible to remove the final ',' before the '|' ??

Thanks!

 

[Bob Barrows [MVP]]

I have the following:

dim app_ids, irowloop, icolloop
app_ids = get_app_logins(session("stremail"))
for irowloop = 0 to ubound(app_ids, 2)
for icolloop = 0 to ubound(app_ids, 1)
response.write(app_ids(icolloop, irowloop) & ",")
next 'icolloop
response.write("|")
next 'irowloop

That returns:
0,0,bobsmith,pAssWord,|0,71,tom,tom,|0,71,tomf,pAssWord,|1,5,tom,a1,|
Is it possible to remove the final ',' before the '|' ??

Well, you could avoid writing it in the first place.


for irowloop = 0 to ubound(app_ids, 2)
for icolloop = 0 to ubound(app_ids, 1)
if icolloop = 0 then
response.write app_ids(icolloop, irowloop)
else
response.write ";" & app_ids(icolloop, irowloop)
end if
next 'icolloop
response.write("|")
next 'irowloop

Bob Barrows

 

[j1c]

That'll do.
Thanks Bob.