In access you may have the colum set to a text field which id a max of 255
charecters.
switch it to a memo field & you will have the room you need.
dont forget your paragraph format on the text!
HTH
-paul
> -----Original Message-----
> From: Mike Weaver [SMTP:[EMAIL PROTECTED]]
> Sent: Sunday, December 03, 2000 4:29 PM
> To: CF-Talk
> Subject: OT:Query results (newbie)
>
> Is there a limit to the size of a single result to a query? I have a db
> location to store notes separated by a delimiter. The notes are in the db,
> but when I get a query result and display through a loop to sort by
> delimiter they seem to be limited to about 255 characters. The db location
> is set for 64k in access.
>
> Any help greatly appreciated.
>
> Mike
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
