putting binary data into a mySQL database

John Dixon dixonja at hotmail.co.uk
Thu Jan 21 07:27:45 EST 2016


Thank you... that did it.. :-)

> Date: Thu, 21 Jan 2016 12:22:58 +0000
> From: neil at livecode.com
> To: use-livecode at lists.runrev.com
> Subject: Re: putting binary data into a mySQL database
> 
> Hi John,
> 
> You should be able to use the URLEncode  when passing it to the .lc 
> script and then URLdecode to decoded it back to it original form.
> 
> Kind Regards,
> 
> Neil
> 
> 
> 	
> 
> LiveCode Technical Support and Content Creation Lead
> neil at livecode.com <mailto:neil at livecode.com>
> 
> LiveCode
> +44 (0) 845 219 8923.
> 25A Thistle Street Lane South West, Edinburgh, EH2 1EW
> http://www.livecode.com
> 
> Facebook <https://www.facebook.com/pages/LiveCode/121318328010780> 
> Twitter <https://twitter.com/livecode> Youtube 
> <https://www.youtube.com/user/RunRevLtd> Linkedin 
> <https://github.com/runrev/livecode>
> 
> 
> On 21/01/2016 12:10, John Dixon wrote:
> > Thanks for the reply.. :-)
> >
> > I though have another question, How do I pass encrypted data to an .lc script ?
> >
> >
> >> Date: Thu, 21 Jan 2016 19:30:09 +0800
> >> Subject: Re: putting binary data into a mySQL database
> >> From: lan.kc.macmail at gmail.com
> >> To: use-livecode at lists.runrev.com
> >>
> >> Look up revExecuteSQL in the Dictionary. Of particular interest:
> >>
> >> To pass binary data in a variable in the variablesList, prepend "*b" to the
> >>> variable name. The *revExecuteSQL* command strips the binary marker "*b"
> >>> and passes it to the database as binary data, rather than text data.
> >>
> >> Basically you need to be using the variable list form of revExecuteSQL
> >> rather than passing the data directly. Also there is a note about binary in
> >> arrays that are being loaded into dbs.
> >> _______________________________________________
> >> 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