Thread: Formatting text strings in fields
Hello:
I am using postgres 7.35 on a Linux 9.0 PC. I am trying to create a technical intranet using the postgresql database for the information. When I type in a solution to a problem all of the text runs together. An example would be:1. Text here 2. Text here 3. Text here.
I would like it to look like the following.
Problem:
Solution:
1. Text here
2. Text here
3. Text here
Any help would be appreciated
Thank you
Larry Gross
Network Specialist II
MCP, CNE, A+
(701) 328-5863
This actually sounds more like an issue with your html coding. If you are executing select statements against postgres, a row of data is returned, are you writing a <br> via perl/php to the screen before the next row of data is retreived? If the data returned all in one call then you need to change the way the data is being saved into postgres. Have the application insert a <br> after each line before it writes the data into the table. On Mon, 2004-06-28 at 11:39, Larry J. Gross wrote: > Hello: > > I am using postgres 7.35 on a Linux 9.0 PC. I am trying to create a > technical intranet using the postgresql database for the information. > When I type in a solution to a problem all of the text runs together. > An example would be:1. Text here 2. Text here 3. Text here. > > I would like it to look like the following. > > Problem: > > Solution: > > 1. Text here > 2. Text here > 3. Text here > > Any help would be appreciated > > Thank you > > Larry Gross > > Network Specialist II > > MCP, CNE, A+ > > ljgross@state.nd.us > > (701) 328-5863
Hi Larry, Like Mike said, if you are dealing with html-intputs/outputs, you'll have to first input something like chr 13+10 into your db for line breaks and for displaying it nicely out again replace whatever you have with <br> -tags. Or something similar. With your preferred language's replace functions. BR, Aarni On Monday 28 June 2004 19:39, you wrote: > Hello: > > I am using postgres 7.35 on a Linux 9.0 PC. I am trying to create a > technical intranet using the postgresql database for the information. When > I type in a solution to a problem all of the text runs together. An > example would be:1. Text here 2. Text here 3. Text here. > > I would like it to look like the following. > > Problem: > > Solution: > > 1. Text here > 2. Text here > 3. Text here > > Any help would be appreciated > > Thank you > > Larry Gross > Network Specialist II > MCP, CNE, A+ > ljgross@state.nd.us > (701) 328-5863 -- ------------------------------------------------- This is a bugfree broadcast to you from a linux system.