Sorry. I misread the question, and thought the loop used array values,
etc. Please disregard that answer.


As for the real answer, perhaps you should check out the technote below


http://www.macromedia.com/support/coldfusion/ts/documents/cfmx61_sqlserv
er_cpu.htm


-Dov

  _____  

From: Ghosal, Ruben - HQ CD Consul
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 10, 2004 2:48 PM
To: CF-Talk
Subject: RE: java.lang.ArrayIndexOutOfBoundsException


Can you please explain.....the error occurs only when there is a
lot of
data......for small amount of data the code works fine.

-----Original Message-----
From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 10, 2004 2:44 PM
To: CF-Talk
Subject: RE: java.lang.ArrayIndexOutOfBoundsException

You want arraylen -1
-dbk

  _____  

From: Ruben Ghosal [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 10, 2004 1:43 PM
To: CF-Talk
Subject: java.lang.ArrayIndexOutOfBoundsException

Hi,

I have a large amount of data which I am trying to insert in a
Shopping cart array. The array is declared is _javascript_. I get
the
following runtime error.

java.lang.ArrayIndexOutOfBoundsException
at java.net.SocketInputStream.read(SocketInputStream.java:121)
at

macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.readPacketIntoP
rimaryBuffer(Unknown Source)
at

macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes
(Unknown Source)
at

macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes
(Unknown Source)
at

macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes
(Unknown Source)
at

macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes
(Unknown Source)
at

macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes
(Unknown Source)
at

macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes
(Unknown Source)
at

macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes
(Unknown Source)
at

macromedia.jdbc.sqlserver.SQLServerByteOrderedDataReader.getArrayOfBytes
(Unknown Source)
at macromedia.util.UtilPagedTempBuffer.write(Unknown Source)
at

macromedia.jdbc.sqlserver.tds.TDSRequest.getColumnDataForRow(Unknown
Source)
at
macromedia.jdbc.sqlserver.SQLServerImplResultSet.getData(Unknown
Source)
at macromedia.jdbc.base.BaseResultSet.getObject(Unknown Source)
at coldfusion.sql.QueryTable.populate(QueryTable.java:272)
at coldfusion.sql.Executive.getRowSets(Executive.java:559)
at coldfusion.sql.Executive.executeCall(Executive.java:814)
at coldfusion.sql.Executive.executeCall(Executive.java:749)
at coldfusion.sql.SqlImpl.executeCall(SqlImpl.java:313)
at

coldfusion.tagext.sql.StoredProcTag.doEndTag(StoredProcTag.java:192)
at

cfshoppingCart2ecfm1340170321.runPage(D:\inetpub\CurtisCustomTags\shoppi
ngCart.cfm:44)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at

coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.j
ava:60)
at
coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:256)
at
coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:1881)
at

cfitemDetails2ecfm1913841519._factor26(D:\inetpub\curtisdirect\ORDER\ite
mDetails.cfm:883)
at

cfitemDetails2ecfm1913841519._factor35(D:\inetpub\curtisdirect\ORDER\ite
mDetails.cfm:403)
at

cfitemDetails2ecfm1913841519._factor36(D:\inetpub\curtisdirect\ORDER\ite
mDetails.cfm:372)
at

cfitemDetails2ecfm1913841519.runPage(D:\inetpub\curtisdirect\ORDER\itemD
etails.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at

coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871)
at

cfsteptwo2ecfm898332195.runPage(D:\inetpub\curtisdirect\ORDER\steptwo.cf
m:151)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at

coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at

coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
at

coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107)
at

coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:
43)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:80)
at

coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
at

coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
at

coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersist
enceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
at

coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:105)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at

jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at

jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252
)
at

jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527
)
at

jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:
192)
at

jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.j
ava:348)
at

jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java
:451)
at

jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.jav
a:294)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

Here is the sample code......

<cfoutput>
<script language="_javascript_">
   var quantityList = new Array();
   var costCenterList = new Array();
</script>

<cfset myVar=0>
<cfloop from="1" to="#arrayLen(shoppingCart['Products'])#"
index="myIndex">
   <cfflush>
   <script language="_javascript_">
      quantityList[#myVar#]='quantity_#myIndex#';
      costCenterList[#myVar#] = 'costCenter_#myIndex#';
   </script>

can anybody suggest where I am going wrong and how to fix it?
  _____

  _____
  _____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to