X-Original-To: pgsql-interfaces@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 49806476375 for ; Fri, 25 Apr 2003 10:55:09 -0400 (EDT) Received: from c001.snv.cp.net (h000.c001.snv.cp.net [209.228.32.114]) by postgresql.org (Postfix) with SMTP id 5725E476373 for ; Fri, 25 Apr 2003 10:55:08 -0400 (EDT) Received: (cpmta 17498 invoked from network); 25 Apr 2003 07:55:11 -0700 Received: from 216.68.139.46 (HELO tierra) by smtp.register-admin.com (209.228.32.114) with SMTP; 25 Apr 2003 07:55:11 -0700 X-Sent: 25 Apr 2003 14:55:11 GMT From: "Steven M. Lotito" To: Subject: Accessing Large Objects From Cold Fusion Date: Fri, 25 Apr 2003 11:02:14 -0400 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Importance: Normal X-Spam-Status: No, hits=-17.2 required=5.0 tests=BAYES_10,MSGID_GOOD_EXCHANGE,PGP_SIGNATURE autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/168 X-Sequence-Number: 4107 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, I've run into an issue that I hope someone can help with... I have a 3rd party postgres database that I need to use ColdFusion to access. They are XML documents, but show up as OIDs. I cannot figure out how to get ColdFusion to read the actual data object... if I select the field I just get the numeric OID... (I guess it's roughly equivalent to a BLOB) \d shows: Table "planinstances" Attribute | Type | Modifier - --------------------------------------------------- planinst_id | integer | not null default nextval('"planinstances_planinst_id_seq"'::text) parent_id | integer | default 0 entdate | timestamp with time zone | default "timestamp"('now'::text) plandef_id | integer | state | character varying(32) | default 'unknown' status | character varying(32) | default 'pending' preprov_config | oid | default 0 preprov_result | oid | default 0 activation_config | oid | default 0 activation_result | oid | default 0 ispoverview | oid | default 0 servinst_id | integer | default 0 user_id | integer | default 0 order_id | integer | default 0 Indices: index_planinstance_order_id,index_planinstance_plandef_id,index_planinstance _sta te,index_planinstance_svcins_id,index_planinstance_user_id,planinstances_pke y The CF query is: SELECT activation_config, plandef_id, planinst_id, preprov_config FROM planinstances WHERE user_id = '#ARGUMENTS.user_id#' AND status = 'normal' AND state='active' AND parent_id = 0 I'm using ColdFusion MX with the latest postgres JDBC driver... I've been able to access these fields in the past ( in Perl I could use lo_read() and could do it in Java using the ResultSet.getBinaryStream() method ) but I need to figure out how to do this with ColdFusion... Does anyone have any suggestions? Thanks in advance! steve -----BEGIN PGP SIGNATURE----- Version: PGPfreeware 6.5.8 for non-commercial use iQA/AwUBPqlN9eirKAzVk3unEQKO+QCg8daYQ3M6JbTy5OyqrZ26ET5LOKQAn19f C135duxdBKu8X5YT57L3zESE =92fZ -----END PGP SIGNATURE-----