"Peter" <peter@somewhereontheinter.net> wrote in
news:cuds3o$b3d$1@forums.macromedia.com:
> Run in Access against the database this is fine, but when run from CF
> via an Access Datasource (CFMX) the results are truncated at 255chars.
>
> I guess this means that the resulting expression is being cast as
> varchar(255). Is there anyway to get CF to cast the result as a Memo
> field?

Hi Peter,

Are you using cfinsert/cfupdate - or a cfquery?

Look at cfqueryparam - this will allow you to update BLOBs with a Query. An
Access-Memo-Field is nothing else than a BLOB.

:-)

cu Simon