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]