Possible to insert array into db without looping?

Question

Hi there,

I'm working on a Flex project that uses cfc's and MySQL. I
have an ArrayCollection that I want to store in my db. I was
thinking that I could store it as a BLOB. I'm taking a stab at it
now but I thought I'd put the feelers out to see if anyone has any
ideas of how to do this.

Maybe a simpler way to put it:

Is it possible to save an entire array into a database
without looping through and storing each item in the array
separately?

Thanks.

Novian

insuractive · Answer

For 1 dimensional arrays, you can either convert the array toa list - ArrayToList() or for more complicated structures you canserialize your data using XML, WDDX (a type of XML) or JSON. WDDXsupport is native to CF, you can find components online that willgive you JSON support or you can roll your own XMLconversion.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded