Text from a SQL Memo field 1

[bletey]

Hi All,

My problem is that after retrieving the contents of a memo field form a SQL7.0 table, and dumping it in a textarea:

<teatarea>
<%=nyRS(&quot;myMemoField&quot%>
</textarea>

there appears to be a large amount of white space before the text:

------------------------------
|<-------white space----------|
|-------->address line 1 |
|address line 2 |
|address line 3 |
| |
------------------------------
sorry for then noddy diagram

nothing i do seems to get rid of it , when testing the length of the field it is only ever the len(memo) and is correct. Any ideas cos it looks really meesy

Pete

 

[shaddow]

Try to put the <teatarea> tags like this, without separing them by ENTER...

<teatarea><%=nyRS(&quot;myMemoField&quot%></textarea>
________

George

 

[Geee]

Yes, use LTRIM, RTRIM or TRIM commands.

LTRIM will remove all whitespace before the first character in a string.

RTRIM will remove all whitespace after the last character in a string.

TRIM will do both.

Hope that helps...

G -GTM Solutions, Home of USITE-
-=

http://www.gtmsolutions.com=-

 

[bletey]

No worries guys I've tried TRIM before but i'll try again
cheers bletey