I am attempting to populate an arra

[rich0335]

I am attempting to populate an array from a MS SQL table. I'm able to make a connection to the database, but I'm not sure I am loading the array correctly because the elements return as null. Does anyone know how to load an array from a table?? Thank you.

Below is my code:

<%
var contTparray = new Array();
var CmdJobTp = Server.CreateObject( &quot;ADODB.Command&quot; );
var Con = Server.CreateObject( &quot;ADODB.Connection&quot; );
Con.Open( Session(&quot;ConnectionString&quot ) ;
CmdJobTp.ActiveConnection = Con;
CmdJobTp.CommandText = &quot;{call ddlbJobTp(?)}&quot;;
CmdJobTp.Parameters.Append( CmdJobTp.CreateParameter( &quot;sMsg&quot;, adChar, adParamOutput, 255, &quot;&quot; ) );
var rsJobTp = CmdJobTp.Execute();
var liCount=rsJobTp.RecordCount
var i=0;
while (! rsJobTp.EOF)

{
contTparray = rsJobTp(&quot;conttp&quot
i++
rsJobTp.moveNext();

}


rsJobTp = null;
CmdJobTp = null;
Con.Close();
Con=null;


%>

 

[link9]

contTparray = rsJobTp(&quot;conttp&quot

just forgot your element there


paul

 

[rich0335]

That was a typo when I created this thread, it still returns a mull value with the after the array name.

 

[lobstah]

with the GetRows method, you can create a 2 dimensional array from your recordset...

contTparray = rsJobTp.GetRows

contTparray(x,y) - x is the field offset per record
y is the record offset for the recordset