[PD-dev] Fwd: Fwd: Fwd: Fwd: Connecting up an SQL Database to PD

[jamie at postlude.co.uk]

> And yet, I know that it is NOT a valid column name, I am not certain
> if it is part of the 1992 SQL spec (which seems to be the "bible"),
> but I know that it will just return the number as a CONSTANT in both
> MySQL and SQLite. I will have to check on if this is in the spec.

Well either way [psql] handles ',1 ,' correctly, forwarding it to the
server as part of the query.

> Also, did you catch the other subtle problem with the class method
> names like 'close'? If you add any class methods, those symbols used
> to identify those methods can't be used in a comma separated list in
> the SQL.
>

Yup this is a bug. I'll be committing a fix for this (as well as the other
changes I mentioned) tonight when I'm not behind a firewall any more!

Jamie