steve_jackson@cox.net wrote:
Quote:
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.
