Expected End Of What?!?!?

[GDX]

I am getting the error: Expected End Of Statement for the following code. What I am trying to do is get the first 5 records from the database.

<%
Set ObjConn = Server.CreateObject(&quot;Adodb.Connection&quot
SQLQry2 = &quot;Select * From Journal&quot;
Objconn.Open (Application(&quot;Datasource&quot)
Set Objrs = Objconn.Execute(SQLQry2)
For I = 1 to 5
Response.write Objrs(&quot;Title&quot
Objrs.Movenext
Next X
%>

I really dont understand why I would get this error, Can someone please explain? Also is there any other wayy of getting the first 5 records like i know how to do a Do WHile not rs.Eof, but is there like a Do while not Rs.Record =>5 or something like that?

Thanks! Gordon R. Durgha
gd@vslink.net

http://www.vslink.net

http://www.brainbench.com/transcript.jsp?pid=1217371

 

[palbano]

Well I don't know VB but this doesn't look right to me...

For I = 1 to 5
Next X

Shouldn't that be
Next I

-pete

 

[GDX]

I changed up the code previously to check something that still wont fix the problem heh sorry about that the new code is...


<%
Set ObjConn = Server.CreateObject(&quot;Adodb.Connection&quot
SQLQry2 = &quot;Select * From Journal&quot;
Objconn.Open (Application(&quot;Datasource&quot)
Set Objrs = Objconn.Execute(SQLQry2)
For I = 1 to 5
Response.write Objrs(&quot;Title&quot
Objrs.Movenext
Next I
%>
Gordon R. Durgha
gd@vslink.net

http://www.vslink.net

http://www.brainbench.com/transcript.jsp?pid=1217371

 

[culshaja]

You should remove the I and jsut use Next.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[caf]

psst my 2 cents

Strange but true. VBScript refuses to acknowledge the variable after the Next statement whereas it's good practice to use as a Visual Basic Coder.

hmmm...nice one microSOFT.

 

[GDX]

Hmm I tried removing the I an am still getting an error, basically i need to get the first 5 records in a table Gordon R. Durgha
gd@vslink.net

http://www.vslink.net

http://www.brainbench.com/transcript.jsp?pid=1217371

 

[froggerIII]

what line number does the error occur on? ray
rheindl@bju.edu

 

[GDX]

I finally solved the problem, I did what James suggested. Thanks

Gordon R. Durgha
gd@vslink.net

http://www.vslink.net

http://www.brainbench.com/transcript.jsp?pid=1217371