On Apr 15, 2008, at 12:53 PM, [EMAIL PROTECTED] wrote:
Robert,What about the code I saw in the meeting where you were doing a de- blobthe image/bytea field? Do I remember this wrong? -----Original Message----- From: [EMAIL PROTECTED][mailto:[EMAIL PROTECTED] On Behalf OfRobert Boone Sent: Tuesday, April 15, 2008 9:25 AM To: Houston.pm located in Houston, TX. Subject: Re: [pm-h] DBIX::Class - blobs I asked on the #dbix-class irc channel and got this reply: castaway: dbic does not do it, the dbd backend does (quote numerics that is) iirc you may have to figure out bind_params.. I know theres a patch/thing for bind_params for PGs bytea, but not about numerics [also look in ::Storage::DBI::Pg for blob stuff iirc theres a pg-specific thing for that too On Tue, Apr 15, 2008 at 7:57 AM, <[EMAIL PROTECTED]> wrote:Hi, I've taken the plunge and am attempting to grok DBIx::Class, withrespect toSybase. 2 bugs are hindering my progress. The latter has got me at apause.I know in one of the Catalyst/DBIx::Class presentations given (I thinkitwas Robert's?), a solution was provided for it. 1. Sybase goes nanners when you try to quote a numeric in a whereclause.DBIx::Class seems to insist on doing this. So for instance, column XXXisnumeric, so in my DBIC code I have: XXX => 5 for my search criteria. ButDBIC wants to execute the following SQL: where XXX = "5". This makesSybasecomplain that I can't do the comparison without an explicit convertcall.I'm working around this by doing a really ugly thing in DBIC code: XXX=>\' = 1'.2. The real stumper is automatically decoding a blob value and inflatingitinto the column. At the moment, I'm just stabbing at it. Can someonegive mean example of how to accomplish this? Thanks, Todd ________________________________Generally, this communication is for informational purposes only and itisnot intended as an offer or solicitation for the purchase or sale of any financial instrument or as an official confirmation of any transaction.Inthe event you are receiving the offering materials attached belowrelated toyour interest in hedge funds or private equity, this communication maybeintended as an offer or solicitation for the purchase or sale of suchfund(s). All market prices, data and other information are not warrantedasto completeness or accuracy and are subject to change without notice.Anycomments or statements made herein do not necessarily reflect those of JPMorgan Chase & Co., its subsidiaries and affiliates. This transmissionmaycontain information that is privileged, confidential, legallyprivileged,and/or exempt from disclosure under applicable law. If you are not theintended recipient, you are hereby notified that any disclosure,copying,distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. Although this transmission andanyattachments are believed to be free of any virus or other defect thatmightaffect any computer system into which it is received and opened, it istheresponsibility of the recipient to ensure that it is virus free and no responsibility is accepted by JPMorgan Chase & Co., its subsidiaries andaffiliates, as applicable, for any loss or damage arising in any wayfromits use. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether inelectronic or hard copy format. Thank you. Please refer tohttp://www.jpmorgan.com/pages/disclosures for disclosures relating to UKlegal entities. _______________________________________________ Houston mailing list [email protected] http://mail.pm.org/mailman/listinfo/houston Website: http://houston.pm.org/_______________________________________________ Houston mailing list [email protected] http://mail.pm.org/mailman/listinfo/houston Website: http://houston.pm.org/ Generally, this communication is for informational purposes only and it is not intended as an offer or solicitation for the purchase or sale of any financial instrument or as an official confirmation of any transaction. In the event you are receiving the offering materials attached below related to your interest in hedge funds or private equity, this communication may be intended as an offer or solicitation for the purchase or sale of such fund(s). All market prices, data and other information are not warranted as to completeness or accuracy and are subject to change without notice. Any comments or statements made herein do not necessarily reflect those of JPMorgan Chase & Co., its subsidiaries and affiliates. This transmission may contain information that is privileged, confidential, legally privileged, and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. Although this transmission and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free and no responsibility is accepted by JPMorgan Chase & Co., its subsidiaries and affiliates, as applicable, for any loss or damage arising in any way from its use. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. Please refer to http://www.jpmorgan.com/pages/disclosures for disclosures relating to UK legal entities. _______________________________________________ Houston mailing list [email protected] http://mail.pm.org/mailman/listinfo/houston Website: http://houston.pm.org/
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Houston mailing list [email protected] http://mail.pm.org/mailman/listinfo/houston Website: http://houston.pm.org/
