Ok yes, i did not think about that.

Thanks Ralph for pointing me to that.

I will test it.


Kind regards,

Jerry

Op 13-8-2019 om 21:39 schreef Ralph DiMola via use-livecode:
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
rdim...@evergreeninfo.net

-----Original Message-----
From: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] 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
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

_______________________________________________
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

Reply via email to