I don't know for sure if you can search *LOBs, but I know you can search
TEXT fields... have you thought about whether or not you can use a TEXT
field instead? You might already know about this, but in case you don't:
They are called "ConText" indexes... and the creation of them looks
something like this:
CREATE INDEX myindex ON [tblname]([txt column name]) INDEXTYPE IS
CTXSYS.CONTEXT;
Anyway, these indexes require constant maintenance to keep them up to date.
There are other similar indexes used for different styles of searching. A
web search should turn up some information if you are interested.
-----Original Message-----
From: Sean McCarthy [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 15, 2003 5:50 AM
To: CF-Talk
Subject: RE: Constrain on a clob
Sorry should have been more clear. It is a clob. From what I have read
there is no way I can search against the data? Any ideas? Looks like I
could use interMedia?
thanks
sean
-----Original Message-----
From: Craig Dudley [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 15, 2003 4:34 AM
To: CF-Talk
Subject: RE: Constrain on a blob
Shouldn't you be storing the data in a CLOB or TEXT field if it's text?
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]
- RE: Constrain on a clob Sean McCarthy
- Re: Constrain on a clob Bryan Stevenson
- CFMX 6.1 install Bryan Love
- CFMX 6.1 install Ryan Sabir