One thing you could do, is to break your big string into smaller sizes that will fit into the varchar(8000) columns, and have as many columns as necessary... you could then have CF join the columns back together. Not the "correct" way to do things, but it should work. -- Ken
On 10/16/05, CF-Talk <cf-talk@houseoffusion.com> wrote: > > CF-Talk 16-Oct-05 Issue:2020 > In this issue: > flash forms and a bad directory structure? > Forums w/external authentication > Forums w/external authentication > Pluggable Security system/ app architecture (WAS: Re: Any Interest in a > Completely Free CFML Calendar?) > zipping and unzipping a string > zipping and unzipping a string > zipping and unzipping a string > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221159 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54