Problem using cfqueryparam

[Jason Lim]

CF throw me an error if I use <cfqueryparam cfsqltype="cf_sql_longvarchar"...
on MS Access Memo field.
My data in the Memo field is around 1000+ char, it should be no problem cause
Memo could support up to 62,000 char if I'm not mistaken.
Now I have to take out the cfqueryparam in order for it to work... *sigh*

Please help
Thanks

[mxstu]

Sounds like you're using the unicode driver? You might want to see this [url]http://john.beynon.org.uk/index.cfm?mode=entry&entry=99B475AB-ACD0-3695-005F8F654764FA66[/url].

[Jason Lim]

Change it to cfsqltype="cf_sql_clob" will do the trick

Thanks again