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