[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