[Dbix-class] Re: JOIN question

A. Pagaltzis pagaltzis at gmx.de
Wed Nov 29 09:06:38 GMT 2006


* Bernhard Graf <dbic2 at augensalat.de> [2006-11-29 09:45]:
> A. Pagaltzis wrote:
> > * Bernhard Graf <dbic2 at augensalat.de> [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/>



More information about the Dbix-class mailing list