[Dbix-class] Query is NOT created successfully.
rabbit+dbic at rabbit.us
Tue Dec 18 08:24:32 GMT 2012
On Mon, Dec 17, 2012 at 01:50:06PM -0800, dkim wrote:
> When I use DBIx::Class::ResultSet::search() method with a complex query with
> multiple joins, the query produced from DBIx::Class is not complete. Some
> conditions are missing in the SQL query when I check the SQL. If I test it
> with each condition separately, then SQL is OK with that condition.
> I am wondering if anybody has the same issue before and/or how to resolve
> this kind of issue.
> I will appreciate it if somebody can help me.
It is unlikely you will receive any help - your question is too vague.
Please provide your search() arguments and the resulting DBIC_TRACE and
explain which parts you think are incorrect. *Then* someone would be
able to identify the problem.
More information about the DBIx-Class