response.write

[Hugh Welford]

Hi - trying to display a memo field using response.write but it truncates
it. Is there a size issue with response.write? If so how do I get round it
and to be able to display the whole memo field

Thanks in advance

Hugh

 

[Evertjan.]

Hugh Welford wrote on 20 jun 2005 in
microsoft.public.inetserver.asp.general:

Hi - trying to display a memo field using response.write but it
truncates it. Is there a size issue with response.write? If so how do
I get round it and to be able to display the whole memo field

Response.write is a serverside command
to fill the renered html page with characters
and has no size as such.

Sizes are defined in clientside html or code.

=================================

<% for mySize = 10 to 22 step 2 %>

<div style='font.size:<% = mySize %>pt;'>
<% Response.write "Hello<br>world!" %>
</div>

<% next %>

==================================

Inspect your rendered html (with view-source)
and show us both your asp code and
the rendered view-source for more help.

 

[Hugh Welford]

Hi Evertjan - thanks for your response. Its not the font size that is the
problem but the length of the text rendered. As you can see, the text is
truncated as 256 characters - seems to think its a text field??? Hugh



source code -

strsql = "SELECT DISTINCT details.* FROM details WHERE PATID = " & found &
";"

objrec.open strsql, objconn, adopenforwardonly, adlockoptimistic, adcmdtext

response.write "<br>" & objrec("about")

the field "about" is a memo field

rendered code -

<table width="550" class = "second">

<tr >

<td height="2" width="304" >

<div align="left"><!-- #BeginEditable "header" --><font color="#9E4E98"><img
src="headers/blue_fullprofile1.gif" width="170" height="26"></font><!--
#EndEditable --></div>

</td>

<td height="2" width="233">

<div align="right"><font face="Verdana, Arial, Helvetica, sans-serif"
size="2"> </font></div>

</td>

</tr>

<tr valign="top">

<td height="300" colspan="2"><!-- #BeginEditable "body" -->



<br>I am 6foot, long dark hair, I represented Australia for the World
champion cow paddy throwing competition. So as you can guess I am quiet fit
and have attractive arms because I have to work out on the arm area so I can
win the Grand Nationals... I love pa

Hugh Welford wrote on 20 jun 2005 in



Response.write is a serverside command

to fill the renered html page with characters

and has no size as such.

Sizes are defined in clientside html or code.



<% for mySize = 10 to 22 step 2 %>

<div style='font.size:<% = mySize %>pt;'>

<% Response.write "Hello<br>world!" %>


<% next %>



Inspect your rendered html (with view-source)

and show us both your asp code and

the rendered view-source for more help.



The Netherlands.

 

[Evertjan.]

Hugh Welford wrote on 20 jun 2005 in
microsoft.public.inetserver.asp.general:

Hi Evertjan - thanks for your response. Its not the font size that is
the problem but the length of the text rendered. As you can see, the
text is truncated as 256 characters - seems to think its a text
field??? Hugh



source code -

strsql = "SELECT DISTINCT details.* FROM details WHERE PATID = " &
found & ";"

objrec.open strsql, objconn, adopenforwardonly, adlockoptimistic,
adcmdtext

response.write "<br>" & objrec("about")

[please do not toppost on usenet]

It is not the response.write that truncates,
but probably your database "about" textfield
that has a maximum of 256 characters.

 

[Bob Barrows [MVP]]

Hi Evertjan - thanks for your response. Its not the font size that is
the problem but the length of the text rendered. As you can see, the
text is truncated as 256 characters - seems to think its a text
field??? Hugh



source code -

strsql = "SELECT DISTINCT details.* FROM details WHERE PATID = " &
found & ";"

objrec.open strsql, objconn, adopenforwardonly, adlockoptimistic,
adcmdtext

response.write "<br>" & objrec("about")

the field "about" is a memo field

http://www.aspfaq.com/show.asp?id=2188

Bob Barrows

 

[Hugh Welford]

thanks evertjan - but as I said, its a "memo" field, and the text itself is
complete in the field

Hugh

Hugh Welford wrote on 20 jun 2005 in
microsoft.public.inetserver.asp.general:

Hi Evertjan - thanks for your response. Its not the font size that is
the problem but the length of the text rendered. As you can see, the
text is truncated as 256 characters - seems to think its a text
field??? Hugh



source code -

strsql = "SELECT DISTINCT details.* FROM details WHERE PATID = " &
found & ";"

objrec.open strsql, objconn, adopenforwardonly, adlockoptimistic,
adcmdtext

response.write "<br>" & objrec("about")

[please do not toppost on usenet]

It is not the response.write that truncates,
but probably your database "about" textfield
that has a maximum of 256 characters.

 

[Evertjan.]

Hugh Welford wrote on 20 jun 2005 in
microsoft.public.inetserver.asp.general:

Hugh Welford wrote on 20 jun 2005 in
microsoft.public.inetserver.asp.general:

Hi Evertjan - thanks for your response. Its not the font size that
is the problem but the length of the text rendered. As you can see,
the text is truncated as 256 characters - seems to think its a text
field??? Hugh



source code -

strsql = "SELECT DISTINCT details.* FROM details WHERE PATID = " &
found & ";"

objrec.open strsql, objconn, adopenforwardonly, adlockoptimistic,
adcmdtext

response.write "<br>" & objrec("about")

[please do not toppost on usenet]

It is not the response.write that truncates,
but probably your database "about" textfield
that has a maximum of 256 characters.

thanks evertjan - but as I said, its a "memo" field, and the text
itself is complete in the field

Could you test with:

response.write len( objrec("about") ) & " Characters long<br>"

?

 

[Hugh Welford]

it returns a null value - presumably as it is a memo field.

Hugh

Hugh Welford wrote on 20 jun 2005 in
microsoft.public.inetserver.asp.general:

Hugh Welford wrote on 20 jun 2005 in
microsoft.public.inetserver.asp.general:

Hi Evertjan - thanks for your response. Its not the font size that
is the problem but the length of the text rendered. As you can see,
the text is truncated as 256 characters - seems to think its a text
field??? Hugh



source code -

strsql = "SELECT DISTINCT details.* FROM details WHERE PATID = " &
found & ";"

objrec.open strsql, objconn, adopenforwardonly, adlockoptimistic,
adcmdtext

response.write "<br>" & objrec("about")

[please do not toppost on usenet]

It is not the response.write that truncates,
but probably your database "about" textfield
that has a maximum of 256 characters.

thanks evertjan - but as I said, its a "memo" field, and the text
itself is complete in the field

Could you test with:

response.write len( objrec("about") ) & " Characters long<br>"

?

 

[Evertjan.]

Hugh Welford wrote on 20 jun 2005 in
microsoft.public.inetserver.asp.general:

Hugh Welford wrote on 20 jun 2005 in
microsoft.public.inetserver.asp.general:

Hugh Welford wrote on 20 jun 2005 in
microsoft.public.inetserver.asp.general:

Hi Evertjan - thanks for your response. Its not the font size
that is the problem but the length of the text rendered. As you
can see, the text is truncated as 256 characters - seems to
think its a text field??? Hugh



source code -

strsql = "SELECT DISTINCT details.* FROM details WHERE PATID = "
& found & ";"

objrec.open strsql, objconn, adopenforwardonly,
adlockoptimistic, adcmdtext

response.write "<br>" & objrec("about")

[please do not toppost on usenet]

It is not the response.write that truncates,
but probably your database "about" textfield
that has a maximum of 256 characters.

thanks evertjan - but as I said, its a "memo" field, and the text
itself is complete in the field

Could you test with:

response.write len( objrec("about") ) & " Characters long<br>"

?

it returns a null value - presumably as it is a memo field.

Dear Hugh, why do you keep on topposting?
I will not go on on a topposted thread.

================================

If objrec("about") returns a string, it is immaterial if it comes from a
memofield or a textfield.

If it is a string with content it must have a positive integer length

response.write len( objrec("about") )

 

[Hugh Welford]

dont know what top-posting is - merely answering your kind replies to the
group

Hugh Welford wrote on 20 jun 2005 in
microsoft.public.inetserver.asp.general:

Hugh Welford wrote on 20 jun 2005 in
microsoft.public.inetserver.asp.general:
Hugh Welford wrote on 20 jun 2005 in
microsoft.public.inetserver.asp.general:

Hi Evertjan - thanks for your response. Its not the font size
that is the problem but the length of the text rendered. As you
can see, the text is truncated as 256 characters - seems to
think its a text field??? Hugh



source code -

strsql = "SELECT DISTINCT details.* FROM details WHERE PATID = "
& found & ";"

objrec.open strsql, objconn, adopenforwardonly,
adlockoptimistic, adcmdtext

response.write "<br>" & objrec("about")

[please do not toppost on usenet]

It is not the response.write that truncates,
but probably your database "about" textfield
that has a maximum of 256 characters.

thanks evertjan - but as I said, its a "memo" field, and the text
itself is complete in the field

Could you test with:

response.write len( objrec("about") ) & " Characters long<br>"

?

it returns a null value - presumably as it is a memo field.

Dear Hugh, why do you keep on topposting?
I will not go on on a topposted thread.

================================

If objrec("about") returns a string, it is immaterial if it comes from a
memofield or a textfield.

If it is a string with content it must have a positive integer length

response.write len( objrec("about") )

 

[Hugh Welford]

Thanks for your help Bob. The answer to the problem is that "select
distinct" does NOT work, but "select" does.

Regards Hugh

 

[Bob Barrows [MVP]]

Damn, I missed that. I would have expected an error message from the attempt
to use DISTINCT with a memo field, not truncation.

Bob Barrows

 

[Evertjan.]

Hugh Welford wrote on 21 jun 2005 in
microsoft.public.inetserver.asp.general:

dont know what top-posting is

=====================

One of the most irritating habits on usenet

What is topposting?

Yes, it is. see rfc1855

Is it against Netiquette?

rfc1855 says:
(quote)
If you are sending a reply to a message or a posting be sure you
summarize the original at the top of the message, or include just
enough text of the original to give a context. This will make
sure readers understand when they start to read your response.
Since NetNews, especially, is proliferated by distributing the
postings from one host to another, it is possible to see a
response to a message before seeing the original. Giving context
helps everyone. But do not include the entire original!
(/quote)

What does that rfc say?

You could search Google for netiquette and topposting.

 

[Ken Jenkins]

who the hell cares if he topposts ?
get a life..

Hugh Welford wrote on 20 jun 2005 in
microsoft.public.inetserver.asp.general:

Hugh Welford wrote on 20 jun 2005 in
microsoft.public.inetserver.asp.general:
Hugh Welford wrote on 20 jun 2005 in
microsoft.public.inetserver.asp.general:

Hi Evertjan - thanks for your response. Its not the font size
that is the problem but the length of the text rendered. As you
can see, the text is truncated as 256 characters - seems to
think its a text field??? Hugh



source code -

strsql = "SELECT DISTINCT details.* FROM details WHERE PATID = "
& found & ";"

objrec.open strsql, objconn, adopenforwardonly,
adlockoptimistic, adcmdtext

response.write "<br>" & objrec("about")

[please do not toppost on usenet]

It is not the response.write that truncates,
but probably your database "about" textfield
that has a maximum of 256 characters.

thanks evertjan - but as I said, its a "memo" field, and the text
itself is complete in the field

Could you test with:

response.write len( objrec("about") ) & " Characters long<br>"

?

it returns a null value - presumably as it is a memo field.

Dear Hugh, why do you keep on topposting?
I will not go on on a topposted thread.

================================

If objrec("about") returns a string, it is immaterial if it comes from a
memofield or a textfield.

If it is a string with content it must have a positive integer length

response.write len( objrec("about") )

 

[Evertjan.]

Ken Jenkins wrote on 21 jun 2005 in
microsoft.public.inetserver.asp.general:

who the hell cares if he topposts ?

Since you ask, I do.

But you knew that, so why ask?