Re: Constrain on a clob

[Bryan Stevenson]

Yes you can search a CLOB, but it takes some doing.  If in Toad you can use some Oracle functions.  If running a CFQUERY you cannot do it in CF 5 or earlier without the aid of a custom tag (they are Java based and you have to pay for them....about $35 US if memory serves).

HTH

Cheers

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: Wednesday, October 15, 2003 5:50 AM
  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]

---