[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