I wonder if you shouldn't be using binary? Bob
On Aug 21, 2011, at 11:35 AM, Pete wrote: > 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 _______________________________________________ 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