This should get you fixed up...
[url]http://www.aspfaq.com/show.asp?id=2257[/url]
Need_help wrote: > 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 ...
Need_help wrote:This demonstrates using GetRows to create your array and also shows how to> 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 (p) this
> values in single variable, so I can send this values to pageB.asp
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 [url]www.able-consulting.com/ado_conn.htm[/url] - 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
This should get you fixed up...
[url]http://www.aspfaq.com/show.asp?id=2257[/url]
"Need_help" wrote:[snip]>
> 1. SELECT VALUES FROM TABLE A WHERE ID=5
[url]http://www.aspfaq.com/5005[/url]
--
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.
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" <nospamnospam.hr> wrote in message
news:uwHVxWfdDHA.1712tk2msftngp13.phx.gbl...> 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 (p) this
> values in single variable, so I can send this values to pageB.asp
>
>
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 (p) this
values in single variable, so I can send this values to pageB.asp
Bookmarks