BLOB Storage Errors

JJS jjs at krutt.org
Wed Jul 31 16:59:05 EDT 2019


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 at 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 at 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 at 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your 
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode




More information about the use-livecode mailing list