asp solution?

[Bob Barrows]

1. SELECT VALUES FROM TABLE A WHERE ID=5

2. I create an array x(0,n), and I populate n with the values based on
select above.

What I have... I have x(0,1)
x(0,2)
x(0,3)... and so on.

Result:> I need to have variable called
varx that should consist all the values from x(0,1), x(0,2), x(0,n).

So I need to declare varx = x(0,1) & "," & x(0,2) & etc.

1. question. I don't know how many elements I would have, coz they
depends on "select".
2. Can someone give me example how I can dynamicly create (parse) this
values in single variable, so I can send this values to pageB.asp

This demonstrates using GetRows to create your array and also shows how to
process the resulting array. For more detail, see ADO online help at
msdn.microsoft.com.

dim cn,sConnect,sSQL,rs,ar, iRow, iCol
sSQL = "SELECT VALUES FROM TABLE A WHERE ID=5"

'for debugging purposes:
response.write sSQL
'you can get rid of this line when debugging is complete

sConnect = "<valid connection string>"
' - see www.able-consulting.com/ado_conn.htm - concentrate on the
'OLEDB connection examples for your database
set cn=server.createobject("adodb.connection")

cn.open sConnect
set rs=cn.execute(sSQL,,1)
if not rs.eof then ar=rs.getrows
rs.close
set rs=nothing
cn.close
set cn=nothing
if isarray(ar) then
for iRow=0 to ubound(ar,2)
for iCol = 0 to ubound(ar,1)
response.write ar(iCol,iRow) & "; "
next
response.write "<br>"
next
else
response.write "no records were returned"
end if

HTH,
Bob Barrows

 

[Dave Anderson]

1. SELECT VALUES FROM TABLE A WHERE ID=5

[snip]

http://www.aspfaq.com/5005


--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.

 

[only_me]

Try the "join" function
Description
Returns a string created by joining a number of substrings contained in an
array.
Syntax
Join(list[, delimiter])
The Join function syntax has these parts:

 

[Need_help]

1. SELECT VALUES FROM TABLE A WHERE ID=5

2. I create an array x(0,n), and I populate n with the values based on
select above.

What I have... I have x(0,1)
x(0,2)
x(0,3)... and so on.

Result:> I need to have variable called
varx that should consist all the values from x(0,1), x(0,2), x(0,n).

So I need to declare varx = x(0,1) & "," & x(0,2) & etc.

1. question. I don't know how many elements I would have, coz they depends
on "select".
2. Can someone give me example how I can dynamicly create (parse) this
values in single variable, so I can send this values to pageB.asp