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]

Reply via email to