X-Original-To: pgsql-interfaces@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 046D4475E77
	for <pgsql-interfaces@postgresql.org>;
	Fri, 25 Apr 2003 10:09:23 -0400 (EDT)
Received: from web20710.mail.yahoo.com (web20710.mail.yahoo.com
	[216.136.226.183])
	by postgresql.org (Postfix) with SMTP id 20C14474E42
	for <pgsql-interfaces@postgresql.org>;
	Fri, 25 Apr 2003 10:09:19 -0400 (EDT)
Message-ID: <20030425140922.48194.qmail@web20710.mail.yahoo.com>
Received: from [216.68.139.46] by web20710.mail.yahoo.com via HTTP;
	Fri, 25 Apr 2003 07:09:22 PDT
Date: Fri, 25 Apr 2003 07:09:22 -0700 (PDT)
From: No Spam <postgres_question@yahoo.com>
Subject: Accessing large object from ColdFusion
To: pgsql-interfaces@postgresql.org
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Spam-Status: No, hits=-6.6 required=5.0
	tests=BAYES_01
	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200305/2
X-Sequence-Number: 4120

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_state,index_planinstance_svcins_id,index_planinstance_user_id,planinstances_pkey

The CF query is:

<CFQUERY NAME="q" DATASOURCE="PostgresDB">
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
</CFQUERY>

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

__________________________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo
http://search.yahoo.com