taking data from a database and putting it into an array

pthompson2002 · 08-16-2002, 11:49 AM

I have a table called "Broadcast" and would like to take the contents of the "Title" column and put it into an array. This array will then be displayed in a javascript scroll bar which I already have working.
My problem is I don't know how to get the data from the database into the Array using ASP.

Can anyone help?

thanks Pete

P.S the javascript just uses a straightforward array at the moment to display the messages.

Spudhead · 08-16-2002, 05:00 PM

ok, this is JSCRIPT, which probaly isn't much help, but...

Code:

<@LANGUAGE=JSCRIPT%>

<%
//get a recordset populated. I assume you have one already

%>

<html>

<head>

<script language="JavaScript">

var myArray=new Array();


<%
var counter=0
while (!myRecordSet.EOF){
%>

myArray[counter]="<%=rs.Fields("myColumnName")%>";

<%
counter++
rs.MoveNext;
}
%>

</script>

</head>

<body>


<script language="JavaScript">

for(i=0;i<myArray.length;i++){
 document.write(myArray[i]);
}
</script>

</body></html>

Roy Sinclair · 08-16-2002, 08:14 PM

At the appropriate place where you define the javascript array loop through the recordset and have it response.write the values to fill the array. Think of it as having the server side ASP code writing the client side javascript code.

whammy · 08-19-2002, 12:53 AM

Roy's suggestion is a good way to go. I do that all the time!

pthompson2002 · 08-19-2002, 08:49 AM

cheers, that worked fine.

thanks for the help

Pete