Storing and retrieving data from a SQL database

Peter Haworth pete at lcsql.com
Thu May 19 03:07:19 EDT 2016


As Mike said, there's no need to do that. Use the variables list parameter
when inserting/updating your data, and revQueryDatabase to create a cursor
when selecting the data. RevDataFromQuery would probably work too with the
right column/row delimiters.

On Wed, May 18, 2016, 8:01 PM Lyn Teyla <lyn.teyla at gmail.com> wrote:

> Paul Dupuis wrote:
>
> > Does anyone have some really good (comprehensive) routines to escape and
> > unescape text data for storing in a SQL database (like SQLite or MySQL)
>
> HostM’s server-side demo stack comes with a function (look for the one
> named "se") that you can use:
>
> https://www.hostm.com/tutorials/livecode/api-mariadb-mysql
>
> Lyn :)
>
>
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode



More information about the use-livecode mailing list