MySQL Read Only?

Q&A's, tips, howto's

MySQL Read Only?

Postby Dave » Sun Jun 01, 2003 6:01 pm

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.
Dave
 
Posts: 6
Joined: Sun Jun 01, 2003 5:54 pm

Postby Lutz » Thu Jun 05, 2003 9:21 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
Lutz
 
Posts: 5279
Joined: Thu Sep 26, 2002 4:45 pm
Location: Pasadena, California

Postby Dave » Fri Jun 06, 2003 3:13 am

I have mysql.lsp v1.3 with 16 definitions to initialize navigate query and close, but not write data to database.
Dave
 
Posts: 6
Joined: Sun Jun 01, 2003 5:54 pm

Postby Lutz » Fri Jun 06, 2003 12:05 pm

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
Lutz
 
Posts: 5279
Joined: Thu Sep 26, 2002 4:45 pm
Location: Pasadena, California


Return to newLISP in the real world

Who is online

Users browsing this forum: No registered users and 2 guests