Need Assistnce accessing SQL Srvr

[trsands]

I am using JS on a cold fusion page. I have created a script which houses data in an Array. I want to update my SQL data base with the data. And also Im unclear on how to 'see' the JS array in Cold Fusion that would solve my problem because I know how to do the update from Cold Fusion.

[Khalid Ali]

can you not post/get data to your CF script???

[trsands]

For some reason Im not clear on that. When I submit does my JS array become a CF form variable?

Perhaps there is a way to update my SQL database directly from JS rather than using a cold fusioin data source?

[olerag]

If you were to place the contents of the array into a "hidden"
object, the values will get passed upon submission. I don't
know the type or size of info your array stores but this would
be one way, as, I believe, KA has already mentioned.

[trsands]

Thanks guys. now just to complicate it a bit further. The array is made up of objects containing purchase data e.g.

object.date
object.time
object.customerid
object.itemcode
object.price
object.quantity

this makes getting the data back on the CF side extremely difficult if I just use a join() right?