wel copying the piece of scipt did not go flawless
Also i blindly assumed you talked about storing images as BLOB
Op 31-7-2019 om 21:37 schreef JJS via use-livecode:
*i use something like this:
*
*
*
*put base64encode(image "productphoto") into tGT*
*put URLencode(tGT) into tPrdFt
put "phototable=" & tT & "&id=" & gId & "&productphoto=" & tPrdFt into
varSendData
put "https://yoursite.com/uploadphoto.php"; into tThis
post varSendData to URL tThis*
*Note that i used php as middleware to my db
*
*
*
Op 31-7-2019 om 19:41 schreef Tom Glod via use-livecode:
I've always avoided using blobs, and have recently been reconsidering
(trying to improve performance by not having to baseencode) it.....
but now I'm back to not wanting to use blobs.
I hope someone here can finally clear this up once and for
all.....how and
if to use blobs correctly.
Thanks Bob :)
On Wed, Jul 31, 2019 at 12:45 PM Bob Sneidar via use-livecode <
use-livecode@lists.runrev.com> wrote:
Hi all.
Those familiar with storing file data in SQL blob columns please
chime in
if you have any ideas. I have added a File Storage module to my SQL
based
app. Mostly it works a peach, but every now and then I encounter a file
that generates some kind of error. I get "mySQL Server has gone
away" when
I attempt to insert the file. I open the files for binary read so
it's the
raw file data unadulterated when I insert it.
The nature of the files are typically backup information from
copiers, so
it's likely they contain encryption hashes. They may also contain other
data that mySQL does not like. Any ideas? Should I be encoding the data
somehow before inserting?
Bob S
_______________________________________________
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
_______________________________________________
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
