Thanks Richard, writing to a file (an sqlite database actually) is exactly what I want to do.
However, I'm running into a problem with this. I believe I have written the data correctly to the database as a BLOB column, but when I read it back from the database and use arraydecode to make it into an array again, I get a runtime error that just names the line and character with no indication of what the error is. Here's what I do to put the data into the db and retrieve it. Updating the DB: * * *put* "UPDATE qdProperties SET qdPropertyValue=CAST (:1 AS BLOB) WHERE qdPropertyID=5304" into mySQL revExecuteSQL 1,mySQL,"*bmyencodedarrayinput" Getting the data back again: *put* revQueryDatabase(1,"SELECT qdPropertyValue FROM qdProperties WHERE qdPropertyID=5304") into myRset *put* revDatabaseColumnNamed(myRset,"qdPropertyValue") intomyencodedarrayoutput *put* arraydecode(myencodedarrayoutput) into myNewArray It's that last line of code that throws the run time error. I'm pretty sure the runtime error is because the binary data that comes back from the db is not a valid encoded array but I have not used BLOB data in dbs before so not sure if what I am doing is the correct way to store/retrieve it. If anyone has experience with this, would be grateful for some input. Thanks, Molly's Revenge <http://www.mollysrevenge.com> On Sat, Aug 20, 2011 at 2:28 PM, Richard Gaskin <ambassa...@fourthworld.com>wrote: > Pete wrote: > >> Next issue is using combine and split with multidimensional arrays. It >> seems like they only work for a single dimension array. I guess to use >> them >> with multidimensional arrays, you have to apply them to each level of >> array >> key? Maybe a recursive function of some sort? >> > > Split and combine translate data to and from simple delimited lists, and > since lists aren't hierarchical by nature there is no meaningful action that > can be performed with those commands on multi-level data. > > If the goal is to store an array on disk for later use, see the arrayEncode > and arrayDecode functions. > > -- > Richard Gaskin > Fourth World > LiveCode training and consulting: http://www.fourthworld.com > Webzine for LiveCode developers: http://www.LiveCodeJournal.com > LiveCode Journal blog: > http://LiveCodejournal.com/**blog.irv<http://LiveCodejournal.com/blog.irv> > > > ______________________________**_________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/**mailman/listinfo/use-livecode<http://lists.runrev.com/mailman/listinfo/use-livecode> > > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode