 |  |  |  |  |  |  |  |
passing the recordset data into an Array
Please support our ASP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
information u provided is very less, but hope this will help
lets consider
"Con" is ur dbase cnnection
Dim Array1() --->keep it open for dynamic use
then
set Rs=con.execute("select * from tablename") --> it is ur table recordet
linecount=0
while not Rs.eof
linecount=linecount+1
redim preserve Array1(LineCount)
Array(1)=rs.fields("fieldname")
Rs.movenext
wend
now Array1 is your array and as it is dynamic so no need to worry about the no of records or array size as well
lets consider
"Con" is ur dbase cnnection
Dim Array1() --->keep it open for dynamic use
then
set Rs=con.execute("select * from tablename") --> it is ur table recordet
linecount=0
while not Rs.eof
linecount=linecount+1
redim preserve Array1(LineCount)
Array(1)=rs.fields("fieldname")
Rs.movenext
wend
now Array1 is your array and as it is dynamic so no need to worry about the no of records or array size as well
|
Similar Threads
- Passing data from forms from one page to another (JavaScript / DHTML / AJAX)
- Modify arrays passed by reference (C++)
- How do I pass data from a recordset on asp page towards an array on js file (HTML and CSS)
- How do I pass data from a recordset on asp page towards an array on js file (JSP)
- input data from a file into an Array (C)
- adding data into an char array (C++)
- passing arrays in visual basic (Visual Basic 4 / 5 / 6)
Other Threads in the ASP Forum
- Previous Thread: Seagate Crystal reports ODBC
- Next Thread: printing throug asp
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest ASP Posts
- Today's Posts
- Unanswered Threads
archive asp asp.net aspandmssqlserver2005 aspandmssqlserver2005connection aspconnection connection database databaseconnection dreamweaver excel fso iis msmsql mssql2005 mssqlserver2005 mssqlserver2005andasp mssqlserverandasp opentextfile record searchbox selectoption single specfic sqlserver sqlserverconnection windows7
