Page 1 of 1

MySQL Read Only?

Posted: Sun Jun 01, 2003 6:01 pm
by Dave
There are no newlisp functions to write to a MySQL database. It is read only. Are you going to add these soon? It would be useful.

Posted: Thu Jun 05, 2003 9:21 pm
by Lutz
Sorry for not answering earlier (I was on a trip). Look into the file 'mysql.lsp' in the newlisp source distribution. It gives you function definitions and examples on how to interact read/write with a MySQL database.

Lutz

Posted: Fri Jun 06, 2003 3:13 am
by Dave
I have mysql.lsp v1.3 with 16 definitions to initialize navigate query and close, but not write data to database.

Posted: Fri Jun 06, 2003 12:05 pm
by Lutz
look at the bottom of the file, where a function 'test' is defined. Updates and inserts are done using SQL in the 'query' function. 'query' is probably a misnomer, perhaps it should be renamed to 'sql'.

Lutz