>>CLOB, or course, as the others have said. > I had never heard of a CLOB. Does it stand for character > long/large object?
>>As a side note, even though I'm _sure_ you're already >>using cfqueryparam, >>you have to use it to put data into a clob column. But, >>you're already using >>it, anyway, right? > ha! I am! You've told me enough times that I am actually > using cfqueryparam somewhat regularly (thank you). You're > saying that I MUST use it though. > thanks for the learnin, folks. Large IIRC it's possible to insert data into a SQL Server "text" column (equivalent of CLOB) without using cfqueryparam -- Oracle isn't as forgiving, although that may have more to do with drivers than with Oracle per se. Although generally speaking you should always use cfqueryparam. I'm fortunate when I'm doing my own work that I've arranged my code in such a fashion that I never need to write <cfquery> tags and so never need to write out <cfqueryparam> tags either, since they're created for me automagically. I've run into problems in the past on some projects where there had been a buggy implementation of cfqueryparam with a particular driver (I remember one with Oracle in particular) which in my experience generally results in the managers choosing not to use cfqueryparam (bad choice) instead of choosing to update the drivers (good choice). At my current 9-5 job my boss (the technical one) isn't sold on cfqueryparam, although he doesn't berate anyone for using it, he just turns his nose up... and although I hate to say it, we have worse problems in our application currently. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:205092 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
