Hollywood forums

I take that back... it works, I had some quotes mixed up the first time.

Thanks a bunch.....

Thanks for reply... looked promising, but it just treats them as strings, so the literal values n a and p are now inserted....

Hi, I am trying to find the proper syntax for inserting data into a sqlite3 database, from within Hollywood, where the data I want to insert is contained in variables. I can't seem to find the syntax that will work anywhere. i.e. db:exec([[ INSERT INTO profiles (name, address, phone) VALUES(n, a, p)...

Maybe this has already been talked about, but for me, an ODBC plugin for connecting to MySQL database servers would be amazing. Is this something that would be possible?