>From what I recall, If using CF5 there is no cfqueryparam type for the clobs. I seem to recall appending data into clobs when using CF5. Just thought I would note that in case someone is doing this on a older version of CF. I ran into it maybe 3-4 months ago when working on one of our older boxes.
On 4/29/05, Deanna Schneider <[EMAIL PROTECTED]> wrote: > > CLOB, or course, as the others have said. > > 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? > > >> I have some text that I need to keep for a database of questions. > >> Some of this text is expected to be 5000-6000 characters. In oracle, > >> I tried to make a varchar2(5000), but it gave me an error saying that > >> it was too large. From searching, I've found the limit to be 4000. > >> What now? I think that what I've read is that I need a LONG, but it > >> wasn't clear if this was for binaries or not. If so, it seems like > >> overkill for just 5000 chars. So, I'm looking for advice here. What > >> type of column should I be making here? > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:205080 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
