If everything is in an array then "arrayEncode" the array and store it in a db. Then arrayDecode it when retrieving it from the DB. You may also have to base64Encode/base64Decode to eliminate any binary.
Ex: (not tested) Put Base64Encode(arrayEncode(sigArray)) into DBdata Put arrayDecode(Base64Decode(DBdata)) into sigArray Ralph DiMola IT Director Evergreen Information Services [email protected] -----Original Message----- From: use-livecode [mailto:[email protected]] On Behalf Of JJS via use-livecode Sent: Tuesday, August 13, 2019 3:23 PM To: How to use LiveCode Cc: JJS Subject: best way to store data from signature widget into mysql db Hi, i was wondering what the best way would be to store a signature of the signature widget into mysql db, so i can recall it. 1. figure out how many keys/elements there are in the array, as it will be different per signature (serialize it as a single string, or create a JSON and store it directly) or 2. is it possible to export the signature, which probably is an svg, to an jpg/png so i can store it as BLOB? thanks for any insights. Regards, Jerry _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
