Re: CFQUERY syntax: populating params to plot x,y values

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: select x,y from Points where... Then use the ValueList function to make a list of all of the x values and a list of all the y values:

CFQUERY syntax: populating params to plot x,y values

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: 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