Re: DBI: Use placeholders for table name?

I don't know of a RDBMS and DBD driver which accepts placeholders in a structural slot like the table name. Perhaps a redesign of the database and its usage would be helpful.

After Compline,
Zaxo

Comment on Re: DBI: Use placeholders for table name?

Replies are listed 'Best First'.
Re^2: DBI: Use placeholders for table name? by dws (Chancellor) on Dec 05, 2004 at 00:11 UTC
I don't know of a RDBMS and DBD driver which accepts placeholders in a structural slot like the table name. Last time I looked, several of the drivers for databases that don't support prepare would allow you to use placeholders anywhere in the query, since the bound variables are expanded by the driver at execute time. This "feature" allowed people to mislead themselves into thinking that binding table names is possible in the general case.	[reply]

Replies are listed 'Best First'.

Re^2: DBI: Use placeholders for table name?
by dws (Chancellor) on Dec 05, 2004 at 00:11 UTC

I don't know of a RDBMS and DBD driver which accepts placeholders in a structural slot like the table name.

Last time I looked, several of the drivers for databases that don't support prepare would allow you to use placeholders anywhere in the query, since the bound variables are expanded by the driver at execute time. This "feature" allowed people to mislead themselves into thinking that binding table names is possible in the general case.

[reply]