RE: Constrain on a blob

2003-10-17 Thread Sean McCarthy
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, 2

RE: Constrain on a blob

2003-10-16 Thread Plunkett, Matt
inal 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.INST

Re: Constrain on a blob

2003-10-16 Thread Deanna Schneider
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.

RE: Constrain on a blob

2003-10-15 Thread Plunkett, Matt
nesday, 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

Re: Constrain on a blob

2003-10-15 Thread Deanna Schneider
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"

RE: Constrain on a blob

2003-10-15 Thread Craig Dudley
nd 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

Re: Constrain on a blob

2003-10-14 Thread Bryan Stevenson
nder & 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 conv

RE: Constrain on a blob

2003-10-14 Thread Sean McCarthy
on a blob What DB and what version of CF? CF 5 and earlier cannot select a BLOBbut 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 PROTE

Re: Constrain on a blob

2003-10-14 Thread Bryan Stevenson
What DB and what version of CF? CF 5 and earlier cannot select a BLOBbut 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]