Title: Message
I have this issue where I have content in a db, one page can display 20 rows of content for example, but I'd like it to even out, for example;
20 rows EQ 56K, then I'd like to display only 25K per page.
This is achievable with READTEXT, I can specify how many bytes to read, but the problem is then that the HTML mark-up could be cut off, or a word could be cut of.
 
The only solution I see there, is maybe to separate the content from the layout, i.e. text with no mark-up at all and then use some kind of lay-out mask over the retrieved text. Not sure how yet, or if possible at all.
 
So all in all READTEXT would be the preferable solution, but it brings along some complicated issues.
 
The next solution would be to use DATALENGTH and keep reading rows until > 25K, which could mean that the last row could contain 40K of text thus really not creating good page separation/breaks anymore.
 
Another option I was thinking about was to retrieve ALL content for one Subject/page and let ColdFusion do the separation, i.e. use a regex to strip all markup and then set the markers where the page break should be....
 
Hope any of this makes sense? Any ideas, comments?
 
Taco Fleur
Blog http://www.tacofleur.com/index/blog/
Methodology http://www.tacofleur.com/index/methodology/
0421 851 786
Tell me and I will forget
Show me and I will remember
Teach me and I will learn
 
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004

Reply via email to