[Dbix-class] DBIx JOIN issue in New version

Paul Findlay Paul.Findlay at fonterra.com
Tue Feb 11 19:32:35 GMT 2014


Hi Sheeju,

I believe you need to update the SQL::Abstract module as well.

Kind regards,

Paul Findlay

From: Sheeju Alex [mailto:sheejuec7 at gmail.com]
Sent: Wednesday, 12 February 2014 12:27 a.m.
To: dbix-class at lists.scsys.co.uk
Subject: [Dbix-class] DBIx JOIN issue in New version

After upgrading to new DBIX version my JOIN statement is failing, here is the query in new and old version

** WORKING in this version

DBIx Version: 0.08195

SELECT * FROM "AlertContact" "me"  JOIN "AlertProfile" "Profile" ON "Profile"."Id" = "me"."ProfileId" WHERE ( ( "Profile"."Refe
renceId" = ? AND "me"."Name" = ? ) ): '1', 'Email'

** NOT WORKING in this version

DBIx Version: 0.08250

SELECT * FROM "AlertContact" "me"  JOIN "AlertProfile" "Profile" ON "Profile"."Id" IDENT ? WHERE ( ( "Profile"."ReferenceId" = ? AND "me"."Name" = ? ) )" with ParamValues: 1='me.ProfileId', 2='1', 3='Email']
I see extra keyword IDENT in JOIN statement, Can you please let me know
how to fix it?
Thanks,
Sheeju

________________________________
DISCLAIMER
This email contains information that is confidential and which may be legally privileged. If you have received this email in error, please notify the sender immediately and delete the email. This email is intended solely for the use of the intended recipient and you may not use or disclose this email in any way.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20140212/370a2c76/attachment.htm>


More information about the DBIx-Class mailing list