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: [email protected]
> To: [email protected]
> 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
> [email protected] <mailto:[email protected]>
>
> 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: [email protected]
> >> To: [email protected]
> >>
> >> 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
> >> [email protected]
> >> Please visit this url to subscribe, unsubscribe and manage your
> >> subscription preferences:
> >> http://lists.runrev.com/mailman/listinfo/use-livecode
> >
> > _______________________________________________
> > use-livecode mailing list
> > [email protected]
> > Please visit this url to subscribe, unsubscribe and manage your
> > subscription preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
>
> _______________________________________________
> use-livecode mailing list
> [email protected]
> Please visit this url to subscribe, unsubscribe and manage your subscription
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
_______________________________________________
use-livecode mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
