Given your situation, I would suggest that you break up the field on the input side and save it as multiple records with a sequence number to control the display.
You are right about the work you would have to do on the retrieval. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Max Appiah-Kubi Sent: Monday, November 26, 2001 5:00 AM To: '[EMAIL PROTECTED]' Subject: RE: Display query data on multiple pages Thanks for pointing me to the right direction, but is there a way of retrieving full strings rather than characters in a string as I will like to work on the basis of words rather than characters. Reason being that if I specified the number of charcters to to extract from the data(ie x number of strings) it will be a pain to work out where the last character to extract is the at the end of a string. What I want to avoid doing is having cut up words appearing all over the pages rendering sentences meaningless or messing up formatting of the document. There is a good example of what I wish to do at this address http://www.sys-con.com/coldfusion/article2a.cfm?id=39&count=1547&tot=11&page =2 . If anyone have a any thought about this, please reply as soon as you can. All ideas are welcome. Thanks -----Original Message----- From: Dave Cahall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 4:04 PM To: [EMAIL PROTECTED] Subject: RE: Display query data on multiple pages Well, one way to do this would be to run a query and save the 30,000 words into an application variable. Then on each page pull in display only a portion using one of the string functions such as Left(string, count), Mid(string, start, count), or Right(string, count) to parse out the portion you want to display on that page. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Max Appiah-Kubi Sent: Wednesday, November 21, 2001 3:44 AM To: Coldfusion (E-mail) Subject: Display query data on multiple pages I have a content field in a database which will have an average of 30,000 words of data, and I will ideally like to display the output data on multiple pages(say 6000 words on a page) so as to reduce the length of pages on the site and rather use prev/next to navigate from the start to to the end of the document. Can anybody help me accomplish this task? Any codes will be greatly appreciated. Thanks ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
