469,602 Members | 1,984 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,602 developers. It's quick & easy.

Subscript out of range during execution Select statement

I am getting a Subscript out of range after executing the following command
Set oRstPick = connTemp.Execute(sSQL)

It is a simple query:
sSQL = "SELECT idCategory, categoryDesc, idParentCategory FROM categories WHERE idCategory <> 1;"

My connection string looks like this:

connString = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" &server.MapPath("../database/comersus.mdb")&";"
set connTemp=server.createobject("adodb.connection")
connTemp.Open connString

I am allocating like this:
Dim sSendBack, sSQL, sCurItem, connString
Dim oRstPick, oCats, connTemp, sValueName

It works as long as the number of rows in the Access database is less than 112 rows. When I have 112 rows or more I get the 'Subscript out of range'

Any ideas?


Sep 18 '06 #1
0 1990

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

51 posts views Thread by Pedro Graca | last post: by
reply views Thread by ssims | last post: by
6 posts views Thread by josh | last post: by
6 posts views Thread by Andy | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.