:> Ok, this may be a stupid question, but when choosing a data storage :> method (XML vs. SQL) what is the best method to store large amounts of :> text?
Why not a combination of both? "Normal" database type stuff - business name, address, blah, blah.... in your SQL database, with a field for the file names of the XML reports? That way, from a simple SQL query you could call up links to the reports, without having to store the reports in the database itself or going over the 8000 character limit... ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
