Forums > MaxMSP

edit HSQLDB from Max

June 23, 2007 | 7:47 am


June 23, 2007 | 10:49 am

Your patcher code is fine… except that your SQL is probably not
doing what you intend.

You’ve written

UPDATE testtable SET info = sss WHERE ID = 1

which attempts to move data in column sss into column info – and you
have no column sss.

Try:

UPDATE testtable SET info = ‘sss’ WHERE ID = 1

(Somewhat surprisingly, it appears that the quotes don’t need to be
escaped.)

– N.

Nick Rothwell / Cassiel.com Limited
http://www.cassiel.com
http://www.myspace.com/cassieldotcom
http://www.loadbang.net


Viewing 2 posts - 1 through 2 (of 2 total)