Re: Sql problem

2017-05-25 Thread Bob Sneidar via use-livecode
Should read, "Forms Generator currently connects directly to SQL VIA SQLYOGA because if I had to write it using only the LC API, I would never have persued it to the level that I have. > > On May 25, 2017, at 12:27 , Bob Sneidar via use-livecode > wrote: > > Forms Generator currently connect

Re: Sql problem

2017-05-25 Thread Andre Garzia via use-livecode
On Thu, May 25, 2017 at 4:27 PM, Bob Sneidar via use-livecode < use-livecode@lists.runrev.com> wrote: > mySQL for Windows is *VERY VERY DIFFICULT* to set up to run with SSL Bob, About running MySQL on Windows, a good choice would be using docker[1]. There are pre-made images for running MySQL u

Re: Sql problem

2017-05-25 Thread Bob Sneidar via use-livecode
Boy howdy do I have one! Forms Generator currently connects directly to SQL because if I had to write it using only the LC API, I would never have persued it to the level that I have. As it is, it's a critical component of our everyday workflow for my IT techs. I bet with a Web API, a LOT more p

Re: Sql problem

2017-05-25 Thread Richard Gaskin via use-livecode
William Prothero wrote: > Thanks for the comments. I bet the linefeeds caused me the problem, > since I just took the contents of a text field, put them in an array, > and didn’t pay attention to linefeeds. Linefeeds are common in data. Consider any user note, such as bug reports at Bugzilla,

Re: Sql problem

2017-05-25 Thread Trevor DeVore via use-livecode
I always thought it would be nice to have a different type of connector in SQL Yoga that would interface with a web API. I never had a project where I needed to actually flesh out the idea to see if it was practical. -- Trevor DeVore ScreenSteps www.screensteps.com On Wed, May 24, 2017 at 12:05

Re: Sql problem

2017-05-24 Thread William Prothero via use-livecode
Folks: Thanks for the comments. I bet the linefeeds caused me the problem, since I just took the contents of a text field, put them in an array, and didn’t pay attention to linefeeds. Now I remember why I didn’t try to directly connect to the dB. The security issue makes it inadvisable to go di

Re: Sql problem

2017-05-24 Thread Bob Sneidar via use-livecode
My problem with that is that I use sqlYoga in a fairly complex app. How would I incorporate sqlYoga calls with a web interface and still retrieve the data in the same format as I currently have? If I cannot do that, then the burden of refactoring the entire application would be considerable. B

Re: Sql problem

2017-05-24 Thread Richard Gaskin via use-livecode
Roger Eller wrote: > I have always replaced the linefeeds with a unique placeholder for > transport, and switched it back to linefeeds in the server script. I > didn't even consider replacing with empty. What in your system requires removing line breaks? -- Richard Gaskin Fourth World System

Re: Sql problem

2017-05-23 Thread Roger Eller via use-livecode
I have always replaced the linefeeds with a unique placeholder for transport, and switched it back to linefeeds in the server script. I didn't even consider replacing with empty. On May 23, 2017 8:55 PM, "Jonathan Lynch via use-livecode" < use-livecode@lists.runrev.com> wrote: > One quick note a

Re: Sql problem

2017-05-23 Thread Jonathan Lynch via use-livecode
One quick note about base64encode: LC adds linefeeds. After you base64encode, you may need to replace linefeed with empty in the variable. Sent from my iPhone > On May 23, 2017, at 8:10 PM, William Prothero via use-livecode > wrote: > > Andre, > This is good advice. I did it this way as a sh

Re: Sql problem

2017-05-23 Thread Andre Garzia via use-livecode
On Tue, May 23, 2017 at 9:10 PM, William Prothero via use-livecode < use-livecode@lists.runrev.com> wrote: > But it looks like I could dispense with the php and directly access the > mySQL db from my mobile app, without a cgi? William, You could but it is not a good security practice to expose

Re: Sql problem

2017-05-23 Thread William Prothero via use-livecode
Andre, This is good advice. I did it this way as a shortcut for an app I’ve built for myself only. You are right that it makes debugging harder because I can’t use other management applications to examine the contents. For many years now I’ve used php cgi’s to connect to the remote mysql db and

Re: Sql problem

2017-05-23 Thread Andre Garzia via use-livecode
William, If I may add a bit of personal opinion here... so, I have been using and storing LC stuff in databases for a long time. Not only I have been storing arrays in database but I had them flying over TCP sockets and being decoded/encoded as needed. For a long time I used the same approach as y

Re: Sql problem

2017-05-21 Thread William Prothero via use-livecode
Never mind. I got it working. I’m not exactly sure about the problem because the method I used should have been quite general. However, what made it work is that I had the contents of a list field in the array I was storing and that somehow caused an error when I tried to decode the array. I de

Re: Sql problem

2017-05-21 Thread William Prothero via use-livecode
Whoops, I lied. The data is stored incorrectly in the simulator too. Hmm…. The IDE stores it correctly. There is something in the encoding that I’m missing. Bill > On May 21, 2017, at 5:03 PM, William Prothero via use-livecode > wrote: > > Folks: > I have an app that stores data to a mysql dat

Sql problem

2017-05-21 Thread William Prothero via use-livecode
Folks: I have an app that stores data to a mysql database on my server. It works fine in the IDE and in the iPhone simulator. However, when I load the app onto the iPhone, the saved data is corrupted. I am saving an array. The array is saved in a big string that has been base64 encoded. When s