Server.CreateObject("ADODB.RecordSet") within JavaScript 1

[raywesterhoff]

I am modifying code from another company and they use JavaScript EVERYWHERE. I need to hit the DB and build a <select> list. I get a &quot;Object Expected&quot; error when the code runs. A snip follows:

var payTypeSQL = &quot;SELECT PayTypeID, PayTypeName FROM VProfile WHERE &quot;;
payTypeSQL += &quot;Project_ID = '1-3-5-1-0-1'&quot;;
var payTypeRS = Server.CreateObject(&quot;ADODB.RecordSet&quot;
payTypeRS.Open (payTypeSQL, conn, 1, 1);
payTypeRS.MoveFirst();
while (!payTypeRS.EOF)

The errors points to the last line. The SELECT is OK. Remember the language used is JavaScript.

Lost for now.

Ray W.

 

[TheInsider]

You should check to make sure that the recordset is not EOF or RecordCount is not = 0, before using the MoveFirst() method.

i.e.

payTypeRS.MoveFirst();
while (!payTypeRS.EOF)

should be:

if (payTypeRS.RecordCount != 0)
{
 payTypeRS.MoveFirst();
 while (!payTypeRS.EOF)
 {
  ...
 }
}