OK, Folks, please be patient with me. This may be somewhat off topic, but where else can I go?
I'm using a simple <CFQUERY> to insert a large text block into a MSSQL 7.0 column with a data type of TEXT. I then use a simple SELECT query to retreive the result. Only the first 65K Bytes are being returned. Since Query Annalyzer only displays a limited result, I can't really tell if the whole text block is being inserted. Is there a problem with the data being too large? Is there a workaround without having to be an expert SQL programmer? John Grubb ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists