| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 29562 | 2003-01-24 11:51:00 | ASP / MySQL question | kevinpaul (3067) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 116338 | 2003-01-24 11:51:00 | Hi All Don't know if i'm in the right place for this, but I'll give it a go anyway: I'm trying to display text from a MySQL database using ASP . The problem is the text in a "normal" format (ie notepad) has line breaks, but when it displays in a web page it loses these breaks . The only way around this that I've been able to find is to manually insert at the end of each line (ala copy&paste) . How do I code either my ASP page or SQL to convert the standard windows line break (\n I THINK) to ? Thanks in advance Kevin |
kevinpaul (3067) | ||
| 116339 | 2003-01-24 12:24:00 | yea i'v never used a sql database but i have use an Access database i was thinking in the SQL database you could insert a sybol like a "^' at the end of each line and have an IF statement in your code to replace every ^ with a this may be way off the mark but i only use SQL to insert into a access database P.S plz son't call me an ideit if i'm wrong (its erly morngin) |
sc0ut (2899) | ||
| 116340 | 2003-01-24 23:57:00 | Presumably you would need to scan for the CR/LF or just a CR (or is it a LF un Unix) in a function and replace those characters with a as above. |
Dolby Digital (160) | ||
| 116341 | 2003-01-25 00:21:00 | Have you tried using an alternative text editor? You might like to try NoteTab Lite. | Greg S (201) | ||
| 116342 | 2003-01-25 01:42:00 | Is this what your problem is? My database text field displays without any line breaks on my web page? The field itself has new paragraphs in it, but they don't show . How can I fix this? Your answer is in most search engines . Line breaks in asp ( . dogpile . com/texis/search?method=&top=1&brand=dogpile&q=line+breaks+in+asp+text+field&cat=web" target="_blank">search . dogpile . com) The solution is not in the database but in the method of displaying . |
Merlin (503) | ||
| 1 | |||||