> 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]

