to define the start? and span? seems to work more like a wildcard. Still
cant get it case insensitive
-----Original Message-----
From: Plunkett, Matt [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 4:14 PM
To: CF-Talk
Subject: RE: Constrain on a blob
Hrm, I see the problem. My bad. I looked around on google a bit, but
didn't see any answers beyond using an Oracle Text index on the field.
-----Original Message-----
From: Deanna Schneider [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 2:07 PM
To: CF-Talk
Subject: Re: Constrain on a blob
No, it doesn't work, dbms_lob is a package and INSTR is a function within
the package. It does not support UPPER.
-Deanna
----- Original Message -----
From: "Plunkett, Matt" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, October 15, 2003 8:52 AM
Subject: RE: Constrain on a blob
> To do case insensitive like searches, I use UPPER() on both sides of the
> where clause. I haven't tried it here, but WHERE
> dbms_lob.INSTR(UPPER(section.text), UPPER('abc'))>0 may work fine.
>
> -----Original Message-----
> From: Deanna Schneider [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 15, 2003 9:39 AM
> To: CF-Talk
> Subject: Re: Constrain on a blob
>
>
> You should be able to do this (at least it works on clobs)
> SELECT header FROM section WHERE dbms_lob.INSTR(section.text, 'abc')>0
>
> This performs a case-sensitve LIKE search. I've yet to find any way to do
a
> case-insensitive LIKE search.
>
> -Deanna
>
> ----- Original Message -----
> From: "Sean McCarthy" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, October 14, 2003 6: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]
