replace spaces with from a recordset

Question

How can I change "spaces" on records being returned by a recordset?

For example, I have this code that will return a value of "John Doe":

<td width="30%"><%=rsTmp("Name")%></font></td>

What I would like to do is to change the space between the words into:

&nbsp;

so that when my page got congested the name "John Doe" will still be in a straight line, and will not be separated?

adding `style="white-space: nowrap;"` to your td would also stop the Name from being split onto seperate lines. — Beast-a-tron, Dec 20 '12 at 16:58

score 3 · Answer 1 · edited Dec 21 '12 at 14:19

3

I resolved it! I used replace function like this.

<% Replace(rsTmp("Name")," ","&nbsp;")%>

edited Dec 21 '12 at 14:19

FoamyGuy

answered Nov 21 '11 at 22:23

zerey

1

This will generate syntax error. Sure you copied your exact code? – Shadow The GPT Wizard Nov 22 '11 at 11:21

score 3 · Answer 2 · answered Nov 24 '11 at 16:31

3

In Classic ASP you will need to code the following:

<%= Replace(rsTmp("Name")," ","&nbsp;") %>

Which is the same as

<%
    Response.Write ( Replace(rsTmp("Name")," ","&nbsp;") )
%>

answered Nov 24 '11 at 16:31

Nicholas Murray

score 3 · Answer 3 · answered Nov 25 '11 at 18:28

3

Actually, I would suggest using replace(rsTmp("Name"), " ", " ")

In HTML5 the ASCII code   are replaced with  . You might as well do this from this day and onwards ;)

answered Nov 25 '11 at 18:28

MicBehrens

3 Answers3