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
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
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
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,
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
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
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
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
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
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
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
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
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
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
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
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
16 matches
Mail list logo