RE: Working with Arrays

[Software FX]

I am not sure of the exact reason why the arrays method is not working for you since we do support arrays as this sample on our support site demonstrate. http://support.softwarefx.com/Samples/CfxIE/Data/ArrayData.asp'>http://support.softwarefx.com/Samples/CfxIE/Data/ArrayData.asp

But to answer your question as to a method that we would recommend to pull data from two separate recordsets and place it into chartfx would be to use a "do while" loop to go threw the recordset and pass the data in.  Internally ChartFX is having to perform a similar task when you pass a recordset to chartfx. I am sure you are already aware of we do not currently support passing two different recordsets to ChartFX at the same time.

IMPORTANT NOTE:

In an effort to provide the most advanced solutions in conjunction with

the most comprehensive technical support structure, Software FX will

implement a Paid-Support Program beginning January 1, 2001 for all

existing and future Software FX application users. The specific details

of the Paid-Support Program will be released in an upcoming broadcast

e-mail, as well as on our website.  Please be aware that the online 

technical support web site at http://support.softwarefx.com will continue

to be available without charge.

Justin Trask

Software FX

Please reply to: cfxie@softwarefx.com

-----Original Message-----

From: Tony Arnett [mailto:tarnett@sir-inc.com]

Posted At: Tuesday, December 05, 2000 4:11 PM

Posted To: Server

Conversation: Working with Arrays

Subject: Working with Arrays

I'm getting random numbers on my charts why I try to use arrays as the

data series and labels.

I have 3 series.  Each has 5 data points.

Series 1 is for labels, which are text.

Series 2 is from recordset A using the GetRows method and is numbers.

Series 3 is from recordset B using the GetRows method and is numbers.

I know each array is storing the numbers properly, because I use the

same arrays to fill in a table with the data on the same page.  But the

values that show up in the chart are gibberish - totally random, and

unrelated to the real numbers.

Combining the two recordsets into one is not an option - results in too

complex a query and the page crashes.  Hence, my attempt to pull each

into an array and then use the array method in CFX.

This is for CFXIE 2000, using ASP with VBScript.

If you know of another method that would allow the Chart to pull from

two recordsets, I'll gladly accept that.  I'm not tied to the arrays

method.

Thanks!