This is just a quick note to Canvas Wiki users regarding large text entries. I was putting our internal coding guidelines into our dev wiki today when I ran into an issue with the entry being truncated. My initial thought was either a validation rule in the app was truncating the text, or the DSN configuration wasn't set to allow CLOBS. After a quick peek at the code, I confirmed the issue was with the DSN config. You'll never run into this issue unless you have a fairly large wiki entry.
To correct the issue, edit your data source in the ColdFusion Administrator and click on the Show Advanced Settings button. You should see a checkbox for CLOB -- Enable long text retrieval (CLOB). Make sure this is checked and you should be good to go.
| Sun | Mon | Tue | Wed | Thu | Fri | Sat |
|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | 6 | |
| 7 | 8 | 9 | 10 | 11 | 12 | 13 |
| 14 | 15 | 16 | 17 | 18 | 19 | 20 |
| 21 | 22 | 23 | 24 | 25 | 26 | 27 |
| 28 | 29 | 30 | 31 |
Caching Enhancements in ColdFusion 9 - Part 6: Configuring Caches and Working with ehcache.xml
pat branley said: Hi Rob
Love your posts on ehcache and cf9. One thing i would love to know about is exactly how you ...
[More]
Connect to DB2 on an AS400 (iSeries)? Then I want to hear from you!
as400 rpg said: I think I will be doing this very soon so will be back to get some tips!
[More]
Summary of Third Party CFC Documentation Tools
Rocky Madden said: Though it has no support, currently, for interfaces, ColdDoc is a great alternative for generating d...
[More]
How to Safely Move Your iTunes Music Directory to a New Drive
Rob said: Rob,
Do you happen to know where the video DRM info is stored on iTunes? I've bought several seaso...
[More]
Intermittent Apache Problems and "winnt_accept: Asynchronous AcceptEx failed"
Tarquin said: Thanks for this - it fixed my problem.
[More]
There are no comments for this entry.
[Add Comment]