MySQL Read Only?

Q&A's, tips, howto's
Locked
Dave
Posts: 6
Joined: Sun Jun 01, 2003 5:54 pm

MySQL Read Only?

Post 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.

Lutz
Posts: 5289
Joined: Thu Sep 26, 2002 4:45 pm
Location: Pasadena, California
Contact:

Post 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

Dave
Posts: 6
Joined: Sun Jun 01, 2003 5:54 pm

Post by Dave »

I have mysql.lsp v1.3 with 16 definitions to initialize navigate query and close, but not write data to database.

Lutz
Posts: 5289
Joined: Thu Sep 26, 2002 4:45 pm
Location: Pasadena, California
Contact:

Post 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

Locked