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

Re: User friendly functions to replace MySQL queries?

2017-05-21 Thread Sannyasin Brahmanathaswami via use-livecode
Since I refuse to move over to HTML5 and Andre works on our projects, I have the joy of helping to make sure he sticks with this community. @ Alex cat's out of the bag… yes our current project (of which Andre has master minded a large part) is on git, public. https://github.com/Himalayan-Acade