Yeah, that sounds like what I had to do on an old DB2 system for storing large text. That definitely will work, but it's a pain in the butt to deal with. It's much easier if your db system can do it for you.
John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -----Original Message----- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Friday, April 29, 2005 12:02 PM To: CF-Talk Subject: RE: longer than a varchar2 Eww. That would stuff up all the cool Oracle Text indexing we are using for our search engine, document management etc. -----Original Message----- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Friday, 29 April 2005 10:26 To: CF-Talk Subject: RE: longer than a varchar2 When I need to store unlimited amounts of text, I usually create a separate table like this: Notes ----- ID (sequential value) FK (links to a parent table) TextValue (varchar 4000) Then, break up the text into 4000-byte chunks and insert them into the table. I also store the related foreign key value to keep them "together". When I query the data back out, I retrieve all records for a particular FK value, and sort it by the ID (sequential value). This method is very portable and doesn't require changing any datatypes from one rdbms to another. It could evolve into serving multiple uses by adding another column to distinguish the "type/application" of data. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205106 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
