[PD] Question about SQL Placeholder Implementation
Mathieu Bouchard
matju at artengine.ca
Fri Dec 21 07:42:38 CET 2007
On Tue, 18 Dec 2007, Mike McGonagle wrote:
> [query <srv_id> insert into mytable (id, name, token) values (?f,'?s','?s')]
> In this example, the first placeholder would expect a Float, with the next
> two expecting a Symbol (just think of this as a variation on the printf
> string substitutions).
It looks more like the types of [t] [pack] [unpack] [expr] etc.
You don't really need to type your data. SQL is largely typeless: at least
at the level of what you can put in one table cell, anything is a string.
It becomes typed (but auto-cast) when put in the cell, but rebecomes
untyped when taken out of the cell.
> but considering that the databases need to know the specific data types
> for each placeholder,
heh? do they?
_ _ __ ___ _____ ________ _____________ _____________________ ...
| Mathieu Bouchard - tél:+1.514.383.3801, Montréal QC Canada
More information about the Pd-list
mailing list