Hi Alan, I have changed the field to a text blob but the hard return is still not being recognised. I use ibase_blob_echo($rec->FLDNM) to display the data. What could I be doing wrong?
Mags On Thu, Jun 28, 2012 at 8:04 PM, Alan J Davies < [email protected]> wrote: > If you want the easy way, then change the field type to a text blob, and > output it as is. Works perfectly. > > The hard way is the way you have it now. To get the data you ideally > create a select stored procedure and you then need to : > find each instance of a hard return (ascii32 ?) > say HR1 > copy the data from the start of the field to HR1 -1 > then find hard return 2 > say HR2 > copy the data from position HR1+1 to this HR2 -1 > and so on... > You can do it in a loop. > I'm sure others already have SPs that do this, but I take the easy route. > > > HTH > Alan > > Alan J Davies > Aldis > > On 28/06/2012 17:42, Mags Phangisa wrote: > > I have a field that takes 1000 characters. When the data is captured it > is > > in paragraphs but when it is displayed in a report it comes up as a > single > > (big) paragraph. > > > > Is there a way to pick up the return key so that I can display the data > in > > the same way it was captured? > > > > Mags > > > > [Non-text portions of this message have been removed] > > > > > > > > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Visit http://www.firebirdsql.org and click the Resources item > on the main (top) menu. Try Knowledgebase and FAQ links ! > > Also search the knowledgebases at http://www.ibphoenix.com > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > Yahoo! Groups Links > > > > [Non-text portions of this message have been removed]
