Using special characters within a string

[Paul]

Hi

Doing my best to understand why I cant insert a vbcrlf or an equivalent into
this piece of code that read messages from an SQL DB. The messages it takes
read into a marquee fine but I want the Marquee to scroll up instead of
horizontally and I need new line spacings else the mesages are difficult to
read.

At present we use the strNewTextDelimitor and I am unable due to syntax or
perhaps idioscy to find a way of adding the VBCRLF or any derivative into
this code so......I am sure its simple but could do with a hand...Tx in
advance.

This outout is pumped to a page back to a page which will not pick up the
new messages if I use any of the following characters (even without placing
them into a variable) vbcrlf vbcr vblf chr(13) chr(10).

Do While Not adoRecordset.EOF

' Add the current message in the recordset to the string that is
returned
strNewText = strNewText & strNewTextDelimiter &
Trim(adoRecordset.Fields("Message").Value & "")
' Set the delimiter ready for the next message.
strNewTextDelimiter = " * * "

' Get the next message from the recordset
adoRecordset.MoveNext
Loop

The code above works fine but the moment I attempt to add the special
characters the scripts do not run and the web page will not update :-( ,
Tis driving me crackers!

Cheers,

[Aaron [SQL Server MVP]]

Can you show how you "attempt to add the special characters"?

--
http://www.aspfaq.com/
(Reverse address to reply.)


"Paul" <[e-mail]> wrote in message
news:41**********************@news.zen.co.uk...

Hi

Doing my best to understand why I cant insert a vbcrlf or an equivalent into this piece of code that read messages from an SQL DB. The messages it takes read into a marquee fine but I want the Marquee to scroll up instead of
horizontally and I need new line spacings else the mesages are difficult to read.

At present we use the strNewTextDelimitor and I am unable due to syntax or
perhaps idioscy to find a way of adding the VBCRLF or any derivative into
this code so......I am sure its simple but could do with a hand...Tx in
advance.

This outout is pumped to a page back to a page which will not pick up the
new messages if I use any of the following characters (even without placing them into a variable) vbcrlf vbcr vblf chr(13) chr(10).

Do While Not adoRecordset.EOF

' Add the current message in the recordset to the string that is
returned
strNewText = strNewText & strNewTextDelimiter &
Trim(adoRecordset.Fields("Message").Value & "")
' Set the delimiter ready for the next message.
strNewTextDelimiter = " * * "

' Get the next message from the recordset
adoRecordset.MoveNext
Loop

The code above works fine but the moment I attempt to add the special
characters the scripts do not run and the web page will not update :-( ,
Tis driving me crackers!

Cheers,

[Jeff Cochran]

On Tue, 10 Aug 2004 12:07:43 +0100, "Paul" <[e-mail]> wrote:

Hi

Doing my best to understand why I cant insert a vbcrlf or an equivalent into
this piece of code that read messages from an SQL DB. The messages it takes
read into a marquee fine but I want the Marquee to scroll up instead of
horizontally and I need new line spacings else the mesages are difficult to
read.

At present we use the strNewTextDelimitor and I am unable due to syntax or
perhaps idioscy to find a way of adding the VBCRLF or any derivative into
this code so......I am sure its simple but could do with a hand...Tx in
advance.

This outout is pumped to a page back to a page which will not pick up the
new messages if I use any of the following characters (even without placing
them into a variable) vbcrlf vbcr vblf chr(13) chr(10).
How do you know? :)

Displaying a VbCrLf in HTML has no effect, you need to convert them to
a <br> or <p></p> tag for HTML to show them. VbCrLf will break the
lines in a View Source, but it's not an HTML tag.

Add the VbCrLf to the input side and store it in the database (it
makes a great delimiter...) and Replace it on the output side. As in:

strMessage = Replace(strMessage,VbCrLf,"<br>")

Jeff
Do While Not adoRecordset.EOF

' Add the current message in the recordset to the string that is
returned
strNewText = strNewText & strNewTextDelimiter &
Trim(adoRecordset.Fields("Message").Value & "")
' Set the delimiter ready for the next message.
strNewTextDelimiter = " * * "

' Get the next message from the recordset
adoRecordset.MoveNext
Loop

The code above works fine but the moment I attempt to add the special
characters the scripts do not run and the web page will not update :-( ,
Tis driving me crackers!

Cheers,