* Bernhard Graf <[EMAIL PROTECTED]> [2006-11-29 09:45]: > A. Pagaltzis wrote: > > * Bernhard Graf <[EMAIL PROTECTED]> [2006-11-28 23:35]: > > > turned out that this cannot be easily achived, because of > > > shortcomings in SQL::Abstract, which doesn't support > > > placeholders in the FROM-part of a query. > > > > Neither does any database, so I don’t see it as > > a shortcoming. > > Where did you get this? > > I tried it with the mysql DBD driver and it worked. Of course > there might be drivers that don't support it. > > Try this silly example (that also returns senseless results) > with the email database from my first email if you like:
Ah. “In the FROM-part” seemed to mean that you wanted to specify a table name using a placeholder; what you meant is “in the WHERE clause.” Regards, -- Aristotle Pagaltzis // <http://plasmasturm.org/> _______________________________________________ List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class Wiki: http://dbix-class.shadowcatsystems.co.uk/ IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/ Searchable Archive: http://www.mail-archive.com/dbix-class@lists.rawmode.org/