Re: putting binary data into a mySQL database

2016-01-23 Thread Kay C Lan
On Thu, Jan 21, 2016 at 10:51 PM, John Dixon wrote: > > Can someone tell me what I am doing wrong here ? > I guess you've figured it out by now, but just in case: > >put "INSERT INTO" & tTableName & "(" & tFields & ") VALUES(:1,:2)" into > tSQL > = INSERT INTOthenamer(thename,thechat) VALU

Re: putting binary data into a mySQL database

2016-01-22 Thread Bob Sneidar
I put it into a archer(50) column. I don't think you need to store it as binary data. I don't and haven't had any problems so far. Bob S > On Jan 21, 2016, at 03:20 , John Dixon wrote: > > How to I put encrypted data.. ie :- > > Salted__c¸≈úÿ9†∆YFòó∆ñU[∑ÉÑÅF > > into a record in a mySQL

RE: (sorted) putting binary data into a mySQL database

2016-01-21 Thread John Dixon
APOLOGIES TO ALL WHO HAVE READ MY OTHER POSTS ON THIS... I have got everything to work... err ... there was some finger trouble hanging around the script... :-( > From: dixo...@hotmail.co.uk > To: use-livecode@lists.runrev.com > Subject: RE: putting binary data into a mySQL databa

RE: putting binary data into a mySQL database

2016-01-21 Thread John Dixon
to the database... Date: Thu, 21 Jan 2016 12:22:58 + > From: n...@livecode.com > To: use-livecode@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 >

RE: putting binary data into a mySQL database

2016-01-21 Thread John Dixon
Thank you... that did it.. :-) > Date: Thu, 21 Jan 2016 12:22:58 + > From: n...@livecode.com > To: use-livecode@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 th

Re: putting binary data into a mySQL database

2016-01-21 Thread Neil Roger
/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.macm

RE: putting binary data into a mySQL database

2016-01-21 Thread John Dixon
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.macm...@gmail.com > To: use-livecode@lists.runrev.com

Re: putting binary data into a mySQL database

2016-01-21 Thread Kay C Lan
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

putting binary data into a mySQL database

2016-01-21 Thread John Dixon
How to I put encrypted data.. ie :- Salted__c¸≈úÿ9†∆YFòó∆ñU[∑ÉÑÅF into a record in a mySQL database ? ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscri