RTRIM dbresultfields again?

[Ted]

Hi
I wrote a question about RTRIM and I didn´t get any answer so I will try to
be more specific this time.
I have a dbresult page that lists fields from a db.
Ex <<fname>><<ename>>
When the field "fname" is empty it occupies 1 space so the next field ename
is written 1 step to the right from the leftmargin.
My question is: Is it possible to prevent the empty fieldresult fname to
occupy any space. I call this RTRIM or RightTrim but maybe it´s wrong word
for this.
I appreciate any answer
Ted

 

[Thomas A. Rowe]

A better option might be to do:

<%
FirstName = fp_rs("fname")
LastName = fp_rs("lname")
FullName = Trim(FirstName + " " + LastName)
%>

The use the following to display on your page:
<%=FullName%>

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Ted]

Thanks Thomas
That fixed my problem
/Ted

A better option might be to do:

<%
FirstName = fp_rs("fname")
LastName = fp_rs("lname")
FullName = Trim(FirstName + " " + LastName)
%>

The use the following to display on your page:
<%=FullName%>

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================