Request object, ASP 0105 (0x80004005) An array index is out of range.

am 26.01.2007 21:57:29 von steve_jackson

I get this error, when I am trying to update a table in an Access DB
through our intranet.

Here is the section of code that is generating the error:

FormItemID = Request.Form("FID")
StoreNo = Request.Form("STNO")
OrderQty = Request.Form("OQTY")

%>
<%
strDBPath = Server.MapPath("\Databases\FirmOrder.mdb")
set cnnSimple = Server.CreateObject("ADODB.Connection")
cnnSimple.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
strDBPath & ";"

For i=1 to Request.Form("OQTY").Count

' IF Request.Form("OQTY" & i) <> "" THEN

mySQL = " INSERT INTO tblFIRMORDER (FormItemID, StoreNo, OrderQty)
VALUES"
mySQL = mySQL & " (" & Request.Form("FID")(i) & ", '" &
Request.Form("STNO")(i) & "', " & Request.Form("OQTY")(i) & ")"
cnnSimple.execute(mySQL)

Can anyone tell me why I am getting the error, and how do i fix it? I
can find alot of references to ASP 105 is an array out of range but
what does that mean and how do I fix it?

Thanks,
OkieMan

Re: Request object, ASP 0105 (0x80004005) An array index is out of range.

am 26.01.2007 22:00:23 von steve_jackson

SORRY, the error occurs in the line of code that starts with:
mySQL=mySQL &
3rd row from the last on the post.

OkieMan

On Jan 26, 2:57 pm, steve_jack...@cox.net wrote:
> I get this error, when I am trying to update a table in an Access DB
> through our intranet.
>
> Here is the section of code that is generating the error:
>
> FormItemID = Request.Form("FID")
> StoreNo = Request.Form("STNO")
> OrderQty = Request.Form("OQTY")
>
> %>
> <%
> strDBPath = Server.MapPath("\Databases\FirmOrder.mdb")
> set cnnSimple = Server.CreateObject("ADODB.Connection")
> cnnSimple.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
> strDBPath & ";"
>
> For i=1 to Request.Form("OQTY").Count
>
> ' IF Request.Form("OQTY" & i) <> "" THEN
>
> mySQL = " INSERT INTO tblFIRMORDER (FormItemID, StoreNo, OrderQty)
> VALUES"
> mySQL = mySQL & " (" & Request.Form("FID")(i) & ", '" &
> Request.Form("STNO")(i) & "', " & Request.Form("OQTY")(i) & ")"
> cnnSimple.execute(mySQL)
>
> Can anyone tell me why I am getting the error, and how do i fix it? I
> can find alot of references to ASP 105 is an array out of range but
> what does that mean and how do I fix it?
>
> Thanks,
> OkieMan

Re: Request object, ASP 0105 (0x80004005) An array index is out of range.

am 26.01.2007 22:20:18 von reb01501

steve_jackson@cox.net wrote:
> I get this error, when I am trying to update a table in an Access DB
> through our intranet.
>
> Here is the section of code that is generating the error:
>
> FormItemID = Request.Form("FID")
> StoreNo = Request.Form("STNO")
> OrderQty = Request.Form("OQTY")
>
> %>
> <%
> strDBPath = Server.MapPath("\Databases\FirmOrder.mdb")
> set cnnSimple = Server.CreateObject("ADODB.Connection")
> cnnSimple.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
> strDBPath & ";"
>
> For i=1 to Request.Form("OQTY").Count
>
> ' IF Request.Form("OQTY" & i) <> "" THEN
>
> mySQL = " INSERT INTO tblFIRMORDER (FormItemID, StoreNo, OrderQty)
> VALUES"
> mySQL = mySQL & " (" & Request.Form("FID")(i) & ", '" &
> Request.Form("STNO")(i) & "', " & Request.Form("OQTY")(i) & ")"
> cnnSimple.execute(mySQL)
>
> Can anyone tell me why I am getting the error, and how do i fix it? I
> can find alot of references to ASP 105 is an array out of range but
> what does that mean and how do I fix it?
>
You verified that OQTY contained multiple values, but you never verified
that STNO contained the same number of values.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Re: Request object, ASP 0105 (0x80004005) An array index is out of range.

am 29.01.2007 15:12:55 von Daniel Crichton

Bob wrote on Fri, 26 Jan 2007 16:20:18 -0500:

> steve_jackson@cox.net wrote:
>> I get this error, when I am trying to update a table in an Access DB
>> through our intranet.
>>
>> Here is the section of code that is generating the error:
>>
>> FormItemID = Request.Form("FID")
>> StoreNo = Request.Form("STNO")
>> OrderQty = Request.Form("OQTY")
>>
>> %>
>> <%
>> strDBPath = Server.MapPath("\Databases\FirmOrder.mdb")
>> set cnnSimple = Server.CreateObject("ADODB.Connection")
>> cnnSimple.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
>> strDBPath & ";"
>>
>> For i=1 to Request.Form("OQTY").Count
>>
>> ' IF Request.Form("OQTY" & i) <> "" THEN
>>
>> mySQL = " INSERT INTO tblFIRMORDER (FormItemID, StoreNo, OrderQty)
>> VALUES"
>> mySQL = mySQL & " (" & Request.Form("FID")(i) & ", '" &
>> Request.Form("STNO")(i) & "', " & Request.Form("OQTY")(i) & ")"
>> cnnSimple.execute(mySQL)
>>
>> Can anyone tell me why I am getting the error, and how do i fix it? I
>> can find alot of references to ASP 105 is an array out of range but
>> what does that mean and how do I fix it?
>>
> You verified that OQTY contained multiple values, but you never verified
> that STNO contained the same number of values.
>

Or FID ;)

Dan

Re: Request object, ASP 0105 (0x80004005) An array index is out of range.

am 29.01.2007 15:21:38 von reb01501

Daniel Crichton wrote:
> Bob wrote on Fri, 26 Jan 2007 16:20:18 -0500:
>> You verified that OQTY contained multiple values, but you never
>> verified that STNO contained the same number of values.
>>
>
>
> Or FID ;)
>

I left that as an exercise for the reader ...

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.