Formatting Text from SQL7

[mousematt]

Hi hope someone can help.

I'm pulling back text from a sql7 db that was entered in a text input box, when I do this through normal response.write(objRS("anyonldthing&quot)

It comes out with no line returns, when I do roughly the same through flash it has the line returns etc can anyone help?

 

[mwolf00]

response.write(replace(replace, objrs(&quot;anything&quot,char(10),'<br>'),char(13),'<br>') -- Just trying to help... LOL

 

[ntm0n]

One other note, if you place the sql text within a &quot;textarea&quot; you will see the line feeds etc....

 

[mousematt]

That doesn't work I put in
response.write(replace(replace, objrs(&quot;anything&quot,char(10),'<br>'),char(13),'<br>') and it comes up with an error. Also doesn't ' just comment the rest of the line out?

I also tried.
response.write(replace(replace, objrs(&quot;anything&quot,char(10),&quot;<br>&quot,char(13),&quot;<br>&quot. that didn't work either.

 

[mousematt]

Using
Response.Write(Replace(Replace(objRS(&quot;anything&quot,char(10),&quot;<br>&quot,char(13),&quot;<br>&quot )

just says - Microsoft VBScript runtime (0x800A01F4)
Variable is undefined: 'char'

 

[mwolf00]

OOOPPSS! Sorry... Messed up the quote marks AND the function call....

Response.Write(Replace(Replace(objRS(&quot;anything&quot,chr(10),&quot;<br>&quot,chr(13),&quot;<br>&quot )



-- Just trying to help... LOL

 

[mousematt]

Cheers works like a dream