afaik BLOB = binary large object, not reallly where you want to be
storing text.
-----Original Message-----
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: 15 October 2003 01:26
To: CF-Talk
Subject: Re: Constrain on a blob
Ya you need to convert it via a function....and for the life of
me I can't remember what it's called (just found it a month ago)...try
Google..."Oracle 9 SELECT BLOB"....should point ya in the right
direction ;-)
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]
---------------------------------------------------------
Macromedia Associate Partner
www.macromedia.com
---------------------------------------------------------
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
----- Original Message -----
From: Sean McCarthy
To: CF-Talk
Sent: Tuesday, October 14, 2003 4:37 PM
Subject: RE: Constrain on a blob
its an oracle 9 db and im working in toad (fancy sql plus)
rite now
seems like i need to perform some sort of convert method on
the data first?
-----Original Message-----
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 14, 2003 7:37 PM
To: CF-Talk
Subject: Re: Constrain on a blob
What DB and what version of CF?
CF 5 and earlier cannot select a BLOB....but you can get some
Java based
custom tags to do it
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]
---------------------------------------------------------
Macromedia Associate Partner
www.macromedia.com
---------------------------------------------------------
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
----- Original Message -----
From: Sean McCarthy
To: CF-Talk
Sent: Tuesday, October 14, 2003 4:07 PM
Subject: Constrain on a blob
I get and 'inconsistent datatype' error when I try to:
SELECT
title
FROM
myTable
WHERE
myBlob = 'abc'
Is it possible to constrain on the information in a blob.
Optimally I
would
like the ability to do a 'like %foo%'
_____
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
