Re: [firebird-support] Return key

2012-06-30 Thread Mags Phangisa
Thanks a lot Milan. This is working perfectly. Mags On Fri, Jun 29, 2012 at 1:12 PM, Milan Babuskov mil...@panonnet.net wrote: ** Mags Phangisa wrote: 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

Re: [firebird-support] Return key

2012-06-29 Thread Milan Babuskov
Mags Phangisa wrote: 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? ibase_blob_echo() means you're probably using PHP, so you're probably using HTML as output. HTML

Re: [firebird-support] Return key

2012-06-28 Thread Alan J Davies
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

Re: [firebird-support] Return key

2012-06-28 Thread Mark Rotteveel
On 28-6-2012 18: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

Re: [firebird-support] Return key

2012-06-28 Thread Mags Phangisa
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 alan.dav...@aldis-systems.co.uk wrote: If you want the

Re: [firebird-support] Return key

2012-06-28 Thread Mark Rotteveel
On 28-6-2012 20:04, Alan J Davies wrote: If you want the easy way, then change the field type to a text blob, and output it as is. Works perfectly. VARCHAR and CHAR fields can also contain linebreaks. There is no need to use blobs. Mark -- Mark Rotteveel

Re: [firebird-support] Return key

2012-06-28 Thread Mags Phangisa
When capturing I have no problem Mark the problem is when I retrieve and display the data. I would love get a way to display the data without having to loop thru the data. Mags On Thu, Jun 28, 2012 at 9:28 PM, Mark Rotteveel m...@lawinegevaar.nlwrote: On 28-6-2012 20:04, Alan J Davies wrote: