Re: mySQL Host access

2016-01-07 Thread Peter Haworth
Hi Lyn, Thanks for that info, that will certainly help me when I start looking into LC server. Unfortunately, I think I'm about 6 months into a 2-year contract with my current web host so probably could not switch at this point. On Thu, Jan 7, 2016 at 4:17 PM Lyn Teyla

Re: mySQL Host access

2016-01-07 Thread Peter Haworth
Hi Alex, You're probably right on the lc server issue (and thanks for the compliment). I already had a library of php db access scripts on my server which I've been using in batch cron jobson a nightly basis so the guts of what I needed to do was already in place, whereas I have never installed

Re: mySQL Host access

2016-01-07 Thread Lyn Teyla
Peter Haworth wrote: > Is this common practice when accessing mySQL on a host server? If so, is > there a better way to set about accessing a mySQL database in these > circumstances, perhaps using php scripts on the server instead of accessing > the db directly with the LC database functions?

Re: mySQL Host access

2016-01-07 Thread Mark Wieder
On 01/07/2016 06:05 PM, Lyn Teyla wrote: The stacks are a free download, and from what I can tell, don’t require you to be a HostM.com client. You just need to be able to run LiveCode Server. Maybe. The url *does* throw a 404, though. -- Mark Wieder ahsoftw...@gmail.com

Re: mySQL Host access

2016-01-07 Thread Lyn Teyla
Peter Haworth wrote: > Thanks for that info, that will certainly help me when I start looking into > LC server. Unfortunately, I think I'm about 6 months into a 2-year > contract with my current web host so probably could not switch at this > point. The stacks are a free download, and from what

Re: mySQL Host access

2016-01-07 Thread Peter Haworth
OK, thanks Lyn. I will have to check with my web host (Dreamhost) how to set LC server up. On Thu, Jan 7, 2016 at 6:05 PM Lyn Teyla wrote: > Peter Haworth wrote: > > > Thanks for that info, that will certainly help me when I start looking > into > > LC server.

Re: mySQL Host access

2016-01-07 Thread Mark Wieder
On 01/07/2016 06:43 PM, Mark Wieder wrote: The url *does* throw a 404, though. ...and now they fixed the link. -- Mark Wieder ahsoftw...@gmail.com ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe,

Re: mySQL Host access

2016-01-07 Thread Mike Bonner
I wonder if Andres Dblib could be modified so that it could be used on both ends. On the client side, use the where, columns etc functionality to build up an array, (dbA) encode it, and post it to a page where its decoded, copied to the dbA variable (after you "start using.." andres stack) and

Re: mySQL Host access

2016-01-07 Thread Earthednet-wp
Peter, I do this on my server. I keep the php on my server. Then I only have to allow access from "localhost' because the php is being run on the server. The php is accessed with "post" command from livecode. If you need an example, I can send you a sample stack, with some sample php. Bill

Re: mySQL Host access

2016-01-07 Thread Alex Tweedly
Why would you consider php scripts, when it would (I assume) be much more familiar for you to use .lc scripts on LCServer, or CGI, scripts ? In fact, given it's you :-), I would think you could write such LC access scripts in your sleep :-), probably better than most of us. -- Alex. On