recordset error

[robertl]

I'm receiving the following error:

Microsoft JScript compilation error '800a03ec'

Expected ';'

/bulk/bookcargo.asp, line 13

set rs=Server.CreateObject("ADODB.RecordSet&quot


when I try to run this code:

<%
//Create a recordset
	set rs=Server.CreateObject(&quot;ADODB.RecordSet&quot;)
//Set up a connection string
	connect=&quot;DSN=name&quot;
//Query String
	SQL = &quot;SELECT commodity_desc FROM Commodities ORDER BY commodity_desc&quot;
//Connect to DB and execute query
	rs.open SQL, connect	
%>

Yet, another site that I designed earlier has similar context for the recordset and it works fine. Infact, I
copied it and only changed the SELECT statement and
DNS name, everything else is constructed the same.

What could be the problem?

Thanks in advance.

 

[luciddream]

jscript is not vbscript.

you cannot set rs to anything in jscript.

var connect = Server.CreateObject("ADODB.Connection"
var rs = Server.CreateObject("ADODB.Recordset"
connect.Open("DSN=;UID=;PWD=;
var SQL = "SELECT commodity_desc FROM Commodities ";
rs.Open(SQL, connect); adam@aauser.com

 

[robertl]

I just check my other site and I did code it in VBScript.

I had recoded my connection strings to a javascript equivalent and want to transverse the records with a

do while not rs.eof

Is this allowed in Javascript? A book I have on Javascript
only addresses while loops, yet a site that I just visited
contains the above do-while-not syntax which is something that I used in VB.
When I try to use the code do-while code, I'm told that a ';' is needed with reference to the while statement.

 

[luciddream]

while(!rs.EOF)
{
//code.
}

or:

do
{
//code
}
while(!rs.EOF)

btw... i'm not sure if do-while loop is valid javascript... it might be the perl in me talking....

adam@aauser.com

 

[robertl]

Thanks for the info.

I'll have to play around with the example you put down, although it works, in that I get more than just one record displayed, an infinate loop occurs with just the first record being displayed.

 

[luciddream]

oh... forgot... you need rs.MoveNext() at the end of the loop. adam@aauser.com

 

[robertl]

I also had to have EOF in smallcase as well.

Thanks.