(sorted) putting binary data into a mySQL database

[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: dixonja at hotmail.co.uk
> To: use-livecode at lists.runrev.com
> Subject: RE: putting binary data into a mySQL database
> Date: Thu, 21 Jan 2016 14:51:09 +0000
> 
> 
> Can someone tell me what I am doing wrong here ? I am not able to insert data into the table 'thenamer'..
> When the script runs nothing is returned in whathappened, 
> 
> the table name is thenamer
> the fields in the table are idNo, thename, thechat
> 
> I know that the .lc script works without trying to insert anything into the database, as I can get it to return to me the contents of the variable thestuff as shown in the second .lc script below
> 
> Any help, pointers, whisky glady accepted... as I'm losing hair...:-)
> 
> <?lc
> put $_GET["A"] into tAction
>     
>    get revOpenDatabase("mysql", "localhost", "xxxxxxxx", "xxxxxxx", "xxxxxxx")
>    put it into theDataRef
>    
>  if tAction = "request" then    
>    put $_GET["boodata"] into thestuff
>    
>    put "thenamer" into tTableName
>    put "thename, thechat" into tFields
>    put "John" into thename
>    put thestuff into thechat
>    
>    put "INSERT INTO" & tTableName & "(" & tFields & ") VALUES(:1,:2)" into tSQL
>    revExecuteSQL theDataRef, tSQL, "thename","theChat"
>    put the result into whathappened
>    
>    put whathappened
>    revCloseDataBase theDataRef    
> 
>    quit    
>   end if    
> ?>    
> 
> The .lc script behaves when not trying to insert data into the database...
> 
> <?lc
> put $_GET["A"] into tAction
>     
>    get revOpenDatabase("mysql", "localhost", "xxxxxxxx", "xxxxxxxx", "xxxxxxxx")
>    put it into theDataRef
>    
>  if tAction = "request" then    
>    put $_GET["boodata"] into thestuff
>    
>    
>    
>    put thestuff    
>    revCloseDataBase theDataRef    
> 
>    quit    
>   end if    
> ?>    
> 
> 
> 
>  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
>  		 	   		  
> _______________________________________________
> 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