newLISP Fan Club

Forum => newLISP in the real world => Topic started by: Dave on June 01, 2003, 11:01:31 AM

Title: MySQL Read Only?
Post by: Dave on June 01, 2003, 11:01:31 AM
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.
Title:
Post by: Lutz on June 05, 2003, 02:21:34 PM
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
Title:
Post by: Dave on June 05, 2003, 08:13:03 PM
I have mysql.lsp v1.3 with 16 definitions to initialize navigate query and close, but not write data to database.
Title:
Post by: Lutz on June 06, 2003, 05:05:53 AM
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