SQL data into array

[Igal]

hay, i'm new to ASP, worked mostly with php, so here's my question.

i take data from the sql server like this:

....
set con=Server.CreateObject("adodb.connection")
set rs=Server.CreateObject("adodb.recordset")

SqlExp = "SELECT * FROM content"
rs.Open SqlExp,con,3,3

Response.Write rs("PageName")
....

now, sure it works nice with only one row, but if i have several row in
my Table, my guess i need to put data into an array?

so, how do i put my fields into an array and display them?

 

[Slim]

hay, i'm new to ASP, worked mostly with php, so here's my question.

i take data from the sql server like this:

...
set con=Server.CreateObject("adodb.connection")
set rs=Server.CreateObject("adodb.recordset")

SqlExp = "SELECT * FROM content"
rs.Open SqlExp,con,3,3

Response.Write rs("PageName")
...

now, sure it works nice with only one row, but if i have several row in
my Table, my guess i need to put data into an array?

so, how do i put my fields into an array and display them?

you can simply loop thought the recordset like this

do until rs.eof
reponse.write rs("PageName")
rs.MoveNext
loop


or you can put the records set into a array like this

myArray = rs.gerRows()

 

[Bob Barrows [MVP]]

hay, i'm new to ASP, worked mostly with php, so here's my question.

i take data from the sql server like this:

...
set con=Server.CreateObject("adodb.connection")
set rs=Server.CreateObject("adodb.recordset")

SqlExp = "SELECT * FROM content"
rs.Open SqlExp,con,3,3

Response.Write rs("PageName")
...

now, sure it works nice with only one row, but if i have several row
in my Table, my guess i need to put data into an array?

so, how do i put my fields into an array and display them?

My advice would be to avoid the recordset loop and use the GetRows, or
GetString approach whenever possible:
http://databases.aspfaq.com/database/should-i-use-recordset-iteration-or-getrows-or-getstring.html