> Hello Everyone,

> My problem is I'm trying to use cfqueryparam to pass a
> file to our sybase DB, by using the data type of blob. My
> column type is image though, Is that Ok? I get an error
> when i do this, i'm running colfusion 5.0 and it seems to
> not support the blob data type.

> Has anyone accomplished this in CF 5.0 using other
> methods?

> Thank you in advance.
> Metzy

Hrm... well you read the file and then there's no type for the
cfqueryparam tag for image or blob data...

You might try dropping the cfqueryparam and using #toBinary(myfile)#
... or if you're using action="" in your cffile tag and just
drop that into the column with-or-without single-quotes instead of the
cfqueryparam... If none of that works, try the cf_sql_longvarchar data
type in your cfqueryparam tag.

unfortunately, i never had to do this with cf5

hth

s. isaac dealey     954.927.5117
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.sys-con.com/story/?storyid=44477&DE=1
http://www.sys-con.com/story/?storyid=45569&DE=1
http://www.fusiontap.com
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to