Store each point (x,y) as one record in the db:
Table Points
x integer
y integer
Retrieve them via a simple CFQUERY select statement:
<cfquery name="qPoints">
select x,y from Points where...
</cfquery>
Then use the ValueList function to make a list of all of the x values and
a list of all the y values:
<parm name="dataset1xValues" value="#ValueList(qPoints.x)#">
<parm name="dataset1yValues" value="#ValueList(qPoints.y)#">
-David
On Fri, 01 Dec 2000 18:05:19 -0800 "James Birchler" <[EMAIL PROTECTED]>
writes:
> I need to populate the x,y variables in a charting applet. There are
> separate param statements for the x's and y's, in the following
> form:
>
> <param name=dataset1yValues
> value="22,23,49,150,231,280,654,534,678,654,978,654">
>
> <param name=dataset1xValues
> value="100,150,200,250,300,350,400,450,500,550,600,650">
>
> I just don't know a) how to store my x's and y's in my database
> (either as a column of x's and a column of y's, or as a row of all
> x's and a row of all y's) and then the corresponding CFQUERY and
> CFOUTPUT necessary to get them to display as x, x, x, x, etc. in the
>
> <param> tags.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists