|
 |
asptoday_discuss thread: Cant See Details - I am growing mad ...
Message #1 by "Binny Chacko" <binny.chacko@w...> on Wed, 9 Oct 2002 20:31:12 +0530
|
|
Hi All,
I am facing a strange problem of not being able to display data from
the database onto my ASP page. It simply truncates the data after around
250 characters.
Scenario is that I have a varchar field in an SQL 2000 database which
has some data around 600 characters in length but when i try displaying
the same in a textarea field, the corresponding data is getting
truncated.
Could some one guide me as to where I am going wrong with some settings?
Thank You,
Regards,
Binny Chacko.
DISCLAIMER:
Information contained and transmitted by this E-MAIL is proprietary to
Wipro Limited and is intended for use only by the individual or entity
to which it is addressed, and may contain information that is
privileged, confidential or exempt from disclosure under applicable law.
If this is a forwarded message, the content of this E-MAIL may not have
been sent with the authority of the Company. If you are not the intended
recipient, an agent of the intended recipient or a person responsible
for delivering the information to the named recipient, you are notified
that any use, distribution, transmission, printing, copying or
dissemination of this information in any way or in any manner is
strictly prohibited. If you have received this communication in error,
please delete this mail & notify us immediately at mailadmin@w...
Message #2 by "Dave Cranwell" <david@t...> on Wed, 9 Oct 2002 16:18:59 +0100
|
|
I thought sql2k could only take 255 characters in a varchar? What you are
putting into the field may get *stored* correctly, but if i'm right; its
likely that sql2k simply doesn't process field contents after the 255th
character, thereby rendering the remaining characters invisible to your
scripts.
Recommend: use ntext or text.
--------------------------
Dave Cranwell
Torchbox Ltd
david@t...
tel: (+44) 1608 811 870
mob: (+44) 7760 438 708
http://www.torchbox.com
----- Original Message -----
From: "Binny Chacko" <binny.chacko@w...>
To: "ASPToday Discuss" <asptoday_discuss@p...>
Sent: Wednesday, October 09, 2002 4:01 PM
Subject: [asptoday_discuss] Cant See Details - I am growing mad ...
Hi All,
I am facing a strange problem of not being able to display data from the
database onto my ASP page. It simply truncates the data after around 250
characters.
Scenario is that I have a varchar field in an SQL 2000 database which has
some data around 600 characters in length but when i try displaying the same
in a textarea field, the corresponding data is getting truncated.
Could some one guide me as to where I am going wrong with some settings?
Thank You,
Regards,
Binny Chacko.
DISCLAIMER:
Information contained and transmitted by this E-MAIL is proprietary to Wipro
Limited and is intended for use only by the individual or entity to which it
is addressed, and may contain information that is privileged, confidential
or exempt from disclosure under applicable law. If this is a forwarded
message, the content of this E-MAIL may not have been sent with the
authority of the Company. If you are not the intended recipient, an agent of
the intended recipient or a person responsible for delivering the
information to the named recipient, you are notified that any use,
distribution, transmission, printing, copying or dissemination of this
information in any way or in any manner is strictly prohibited. If you have
received this communication in error, please delete this mail & notify us
immediately at mailadmin@w...
Message #3 by "Steven Van de Weyer" <vandeweyer.s@p...> on Thu, 10 Oct 2002 08:59:06
|
|
The problem is that HTML will not recognize carriage return or line feed.
If you check your output in the HTML source, you will see that the text is
not truncated at all.
What you should do is: write a function that catches Chr(10) and Chr(13)
and puts a <BR> tag in place.
Good luck,
Steven Van de Weyer (Belgium)
> Hi All,
I am facing a strange problem of not being able to display data
from
the database onto my ASP page. It simply truncates the data after around
250 characters.
Scenario is that I have a varchar field in an SQL 2000 database which
has some data around 600 characters in length but when i try displaying
the same in a textarea field, the corresponding data is getting
truncated.
Could some one guide me as to where I am going wrong with some settings?
Thank You,
Regards,
Binny Chacko.
DISCLAIMER:
Information contained and transmitted by this E-MAIL is proprietary to
Wipro Limited and is intended for use only by the individual or entity
to which it is addressed, and may contain information that is
privileged, confidential or exempt from disclosure under applicable law.
If this is a forwarded message, the content of this E-MAIL may not have
been sent with the authority of the Company. If you are not the intended
recipient, an agent of the intended recipient or a person responsible
for delivering the information to the named recipient, you are notified
that any use, distribution, transmission, printing, copying or
dissemination of this information in any way or in any manner is
strictly prohibited. If you have received this communication in error,
please delete this mail & notify us immediately at mailadmin@w...
Message #4 by "Binny Chacko" <binny.chacko@w...> on Thu, 10 Oct 2002 13:49:24 +0530
|
|
Thanx Steven for your guidance.
But the problem for me is not at all with carriage return, it is just
plan vanilla text and my display actually gets truncated in the middle
of word, some where after around 250 characters.
One more observation is that the same asp file when placed on another
winnt and win2k server is working fine and showing me the complete
contents of the field which is around 1900 characters in full form.
Could you please lemme know if there is any setting in IIS or NT which
could be hindering this display?
Thank you,
Regards,
Binny Chacko.
-----Original Message-----
From: Steven Van de Weyer [mailto:vandeweyer.s@p...]
Sent: Thursday, October 10, 2002 2:29 PM
To: ASPToday Discuss
Subject: [asptoday_discuss] Re: Cant See Details - I am growing mad ...
The problem is that HTML will not recognize carriage return or line
feed.
If you check your output in the HTML source, you will see that the text
is
not truncated at all.
What you should do is: write a function that catches Chr(10) and Chr(13)
and puts a <BR> tag in place.
Good luck,
Steven Van de Weyer (Belgium)
> Hi All,
I am facing a strange problem of not being able to display data
from =3D
the database onto my ASP page. It simply truncates the data after around
=3D
250 characters.=3D20
Scenario is that I have a varchar field in an SQL 2000 database which
=3D
has some data around 600 characters in length but when i try displaying
=3D
the same in a textarea field, the corresponding data is getting =3D
truncated.
Could some one guide me as to where I am going wrong with some settings?
Thank You,
=3D20
Regards,
Binny Chacko.
DISCLAIMER:
Information contained and transmitted by this E-MAIL is proprietary to
=3D
Wipro Limited and is intended for use only by the individual or entity
=3D
to which it is addressed, and may contain information that is =3D
privileged, confidential or exempt from disclosure under applicable law.
=3D
If this is a forwarded message, the content of this E-MAIL may not have
=3D
been sent with the authority of the Company. If you are not the intended
=3D
recipient, an agent of the intended recipient or a person responsible
=3D
for delivering the information to the named recipient, you are notified
=3D
that any use, distribution, transmission, printing, copying or =3D
dissemination of this information in any way or in any manner is =3D
strictly prohibited. If you have received this communication in error,
=3D
please delete this mail & notify us immediately at mailadmin@w...
DISCLAIMER:
Information contained and transmitted by this E-MAIL is proprietary to
Wipro Limited and is intended for use only by the individual or entity
to which it is addressed, and may contain information that is
privileged, confidential or exempt from disclosure under applicable law.
If this is a forwarded message, the content of this E-MAIL may not have
been sent with the authority of the Company. If you are not the intended
recipient, an agent of the intended recipient or a person responsible
for delivering the information to the named recipient, you are notified
that any use, distribution, transmission, printing, copying or
dissemination of this information in any way or in any manner is
strictly prohibited. If you have received this communication in error,
please delete this mail & notify us immediately at mailadmin@w...
Message #5 by "Ron Hardesty" <ron@j...> on Thu, 10 Oct 2002 11:33:55 -0700
|
|
Have you checked your printer drivers for new versions?
Ron Hardesty
ronhardesty@q...
-----Original Message-----
From: Binny Chacko [mailto:binny.chacko@w...]
Sent: Thursday, October 10, 2002 1:19 AM
To: ASPToday Discuss
Subject: [asptoday_discuss] Re: Cant See Details - I am growing mad ...
Thanx Steven for your guidance.
But the problem for me is not at all with carriage return, it is just
plan vanilla text and my display actually gets truncated in the middle
of word, some where after around 250 characters.
One more observation is that the same asp file when placed on another
winnt and win2k server is working fine and showing me the complete
contents of the field which is around 1900 characters in full form.
Could you please lemme know if there is any setting in IIS or NT which
could be hindering this display?
Thank you,
Regards,
Binny Chacko.
-----Original Message-----
From: Steven Van de Weyer [mailto:vandeweyer.s@p...]
Sent: Thursday, October 10, 2002 2:29 PM
To: ASPToday Discuss
Subject: [asptoday_discuss] Re: Cant See Details - I am growing mad ...
The problem is that HTML will not recognize carriage return or line
feed.
If you check your output in the HTML source, you will see that the text
is
not truncated at all.
What you should do is: write a function that catches Chr(10) and Chr(13)
and puts a <BR> tag in place.
Good luck,
Steven Van de Weyer (Belgium)
> Hi All,
I am facing a strange problem of not being able to display
data
from
the database onto my ASP page. It simply truncates the data after around
= 250 characters.
Scenario is that I have a varchar field in an SQL 2000 database which
has some data around 600 characters in length but when i try displaying
= the same in a textarea field, the corresponding data is getting
truncated.
Could some one guide me as to where I am going wrong with some settings?
Thank You,
Regards,
Binny Chacko.
DISCLAIMER:
Information contained and transmitted by this E-MAIL is proprietary to
Wipro Limited and is intended for use only by the individual or entity
to which it is addressed, and may contain information that is
privileged, confidential or exempt from disclosure under applicable law.
= If this is a forwarded message, the content of this E-MAIL may not
have = been sent with the authority of the Company. If you are not the
intended = recipient, an agent of the intended recipient or a person
responsible = for delivering the information to the named recipient,
you are notified = that any use, distribution, transmission, printing,
copying or = dissemination of this information in any way or in any
manner is = strictly prohibited. If you have received this communication
in error, = please delete this mail & notify us immediately at
mailadmin@w...
DISCLAIMER:
Information contained and transmitted by this E-MAIL is proprietary to
Wipro Limited and is intended for use only by the individual or entity
to which it is addressed, and may contain information that is
privileged, confidential or exempt from disclosure under applicable law.
If this is a forwarded message, the content of this E-MAIL may not have
been sent with the authority of the Company. If you are not the intended
recipient, an agent of the intended recipient or a person responsible
for delivering the information to the named recipient, you are notified
that any use, distribution, transmission, printing, copying or
dissemination of this information in any way or in any manner is
strictly prohibited. If you have received this communication in error,
please delete this mail & notify us immediately at mailadmin@w...
Message #6 by "Binny Chacko" <binny.chacko@w...> on Fri, 11 Oct 2002 08:53:48 +0530
|
|
Sorry ron, i meant that am not getting the display on my screen.
Thank You,
Regards,
Binny Chacko.
-----Original Message-----
From: Ron Hardesty [mailto:ron@j...]
Sent: Friday, October 11, 2002 12:04 AM
To: ASPToday Discuss
Subject: [asptoday_discuss] Re: Cant See Details - I am growing mad ...
Have you checked your printer drivers for new versions?
Ron Hardesty
ronhardesty@q...
-----Original Message-----
From: Binny Chacko [mailto:binny.chacko@w...]
Sent: Thursday, October 10, 2002 1:19 AM
To: ASPToday Discuss
Subject: [asptoday_discuss] Re: Cant See Details - I am growing mad ...
Thanx Steven for your guidance.
But the problem for me is not at all with carriage return, it is just
plan vanilla text and my display actually gets truncated in the middle
of word, some where after around 250 characters.
One more observation is that the same asp file when placed on another
winnt and win2k server is working fine and showing me the complete
contents of the field which is around 1900 characters in full form.
Could you please lemme know if there is any setting in IIS or NT which
could be hindering this display?
Thank you,
Regards,
Binny Chacko.
-----Original Message-----
From: Steven Van de Weyer [mailto:vandeweyer.s@p...]
Sent: Thursday, October 10, 2002 2:29 PM
To: ASPToday Discuss
Subject: [asptoday_discuss] Re: Cant See Details - I am growing mad ...
The problem is that HTML will not recognize carriage return or line
feed.
If you check your output in the HTML source, you will see that the text
is
not truncated at all.
What you should do is: write a function that catches Chr(10) and Chr(13)
and puts a <BR> tag in place.
Good luck,
Steven Van de Weyer (Belgium)
> Hi All,
I am facing a strange problem of not being able to display
data
from =3D
the database onto my ASP page. It simply truncates the data after around
=3D 250 characters.=3D20
Scenario is that I have a varchar field in an SQL 2000 database which
=3D
has some data around 600 characters in length but when i try displaying
=3D the same in a textarea field, the corresponding data is getting =3D
truncated.
Could some one guide me as to where I am going wrong with some settings?
Thank You,
=3D20
Regards,
Binny Chacko.
DISCLAIMER:
Information contained and transmitted by this E-MAIL is proprietary to
=3D
Wipro Limited and is intended for use only by the individual or entity
=3D
to which it is addressed, and may contain information that is =3D
privileged, confidential or exempt from disclosure under applicable law.
=3D If this is a forwarded message, the content of this E-MAIL may not
have =3D been sent with the authority of the Company. If you are not the
intended =3D recipient, an agent of the intended recipient or a person
responsible =3D for delivering the information to the named recipient,
you are notified =3D that any use, distribution, transmission, printing,
copying or =3D dissemination of this information in any way or in any
manner is =3D strictly prohibited. If you have received this
communication
in error, =3D please delete this mail & notify us immediately at
mailadmin@w...
DISCLAIMER:
Information contained and transmitted by this E-MAIL is proprietary to
Wipro Limited and is intended for use only by the individual or entity
to which it is addressed, and may contain information that is
privileged, confidential or exempt from disclosure under applicable law.
If this is a forwarded message, the content of this E-MAIL may not have
been sent with the authority of the Company. If you are not the intended
recipient, an agent of the intended recipient or a person responsible
for delivering the information to the named recipient, you are notified
that any use, distribution, transmission, printing, copying or
dissemination of this information in any way or in any manner is
strictly prohibited. If you have received this communication in error,
please delete this mail & notify us immediately at mailadmin@w...
DISCLAIMER:
Information contained and transmitted by this E-MAIL is proprietary to
Wipro Limited and is intended for use only by the individual or entity
to which it is addressed, and may contain information that is
privileged, confidential or exempt from disclosure under applicable law.
If this is a forwarded message, the content of this E-MAIL may not have
been sent with the authority of the Company. If you are not the intended
recipient, an agent of the intended recipient or a person responsible
for delivering the information to the named recipient, you are notified
that any use, distribution, transmission, printing, copying or
dissemination of this information in any way or in any manner is
strictly prohibited. If you have received this communication in error,
please delete this mail & notify us immediately at mailadmin@w...
Message #7 by "Steven Van de Weyer" <vandeweyer.s@p...> on Mon, 14 Oct 2002 09:08:47
|
|
Is it possible to put some of your code here?
Steven VDW.
> Hi All,
I am facing a strange problem of not being able to display data
from
the database onto my ASP page. It simply truncates the data after around
250 characters.
Scenario is that I have a varchar field in an SQL 2000 database which
has some data around 600 characters in length but when i try displaying
the same in a textarea field, the corresponding data is getting
truncated.
Could some one guide me as to where I am going wrong with some settings?
Thank You,
Regards,
Binny Chacko.
DISCLAIMER:
Information contained and transmitted by this E-MAIL is proprietary to
Wipro Limited and is intended for use only by the individual or entity
to which it is addressed, and may contain information that is
privileged, confidential or exempt from disclosure under applicable law.
If this is a forwarded message, the content of this E-MAIL may not have
been sent with the authority of the Company. If you are not the intended
recipient, an agent of the intended recipient or a person responsible
for delivering the information to the named recipient, you are notified
that any use, distribution, transmission, printing, copying or
dissemination of this information in any way or in any manner is
strictly prohibited. If you have received this communication in error,
please delete this mail & notify us immediately at mailadmin@w...
Message #8 by "Binny Chacko" <binny.chacko@w...> on Mon, 14 Oct 2002 19:35:58 +0530
|
|
Steven actually i dont c a problem with the code at all, since the same
asp page works on one another web server connecting to the same database
but not on this web server.
Thank You,
Regards,
Binny Chacko.
-----Original Message-----
From: Steven Van de Weyer [mailto:vandeweyer.s@p...]
Sent: Monday, October 14, 2002 2:39 PM
To: ASPToday Discuss
Subject: [asptoday_discuss] Re: Cant See Details - I am growing mad ...
Is it possible to put some of your code here?
Steven VDW.
> Hi All,
I am facing a strange problem of not being able to display data
from =3D
the database onto my ASP page. It simply truncates the data after around
=3D
250 characters.=3D20
Scenario is that I have a varchar field in an SQL 2000 database which
=3D
has some data around 600 characters in length but when i try displaying
=3D
the same in a textarea field, the corresponding data is getting =3D
truncated.
Could some one guide me as to where I am going wrong with some settings?
Thank You,
=3D20
Regards,
Binny Chacko.
DISCLAIMER:
Information contained and transmitted by this E-MAIL is proprietary to
=3D
Wipro Limited and is intended for use only by the individual or entity
=3D
to which it is addressed, and may contain information that is =3D
privileged, confidential or exempt from disclosure under applicable law.
=3D
If this is a forwarded message, the content of this E-MAIL may not have
=3D
been sent with the authority of the Company. If you are not the intended
=3D
recipient, an agent of the intended recipient or a person responsible
=3D
for delivering the information to the named recipient, you are notified
=3D
that any use, distribution, transmission, printing, copying or =3D
dissemination of this information in any way or in any manner is =3D
strictly prohibited. If you have received this communication in error,
=3D
please delete this mail & notify us immediately at mailadmin@w...
DISCLAIMER:
Information contained and transmitted by this E-MAIL is proprietary to
Wipro Limited and is intended for use only by the individual or entity
to which it is addressed, and may contain information that is
privileged, confidential or exempt from disclosure under applicable law.
If this is a forwarded message, the content of this E-MAIL may not have
been sent with the authority of the Company. If you are not the intended
recipient, an agent of the intended recipient or a person responsible
for delivering the information to the named recipient, you are notified
that any use, distribution, transmission, printing, copying or
dissemination of this information in any way or in any manner is
strictly prohibited. If you have received this communication in error,
please delete this mail & notify us immediately at mailadmin@w...
Message #9 by "Biju.Therakathilal" <Biju.Therakathilal@t...> on Mon, 14 Oct 2002 13:20:10 -0500
|
|
Binny,
SQL 2000 has limit for varchar datatype and is 2MB. So it is well above your
600 characters. I think the problem you are getting is due to some settings
on IIS.
thanks
biju
-----Original Message-----
From: Binny Chacko [mailto:binny.chacko@w...]
Sent: Wednesday, October 09, 2002 10:01 AM
To: ASPToday Discuss
Subject: [asptoday_discuss] Cant See Details - I am growing mad ...
Hi All,
I am facing a strange problem of not being able to display data
from the database onto my ASP page. It simply truncates the data after
around 250 characters.
Scenario is that I have a varchar field in an SQL 2000 database which has
some data around 600 characters in length but when i try displaying the same
in a textarea field, the corresponding data is getting truncated.
Could some one guide me as to where I am going wrong with some settings?
Thank You,
Regards,
Binny Chacko.
DISCLAIMER:
Information contained and transmitted by this E-MAIL is proprietary to Wipro
Limited and is intended for use only by the individual or entity to which it
is addressed, and may contain information that is privileged, confidential
or exempt from disclosure under applicable law. If this is a forwarded
message, the content of this E-MAIL may not have been sent with the
authority of the Company. If you are not the intended recipient, an agent of
the intended recipient or a person responsible for delivering the
information to the named recipient, you are notified that any use,
distribution, transmission, printing, copying or dissemination of this
information in any way or in any manner is strictly prohibited. If you have
received this communication in error, please delete this mail & notify us
immediately at mailadmin@w...
Message #10 by "Binny Chacko" <binny.chacko@w...> on Tue, 15 Oct 2002 08:57:04 +0530
|
|
Yes Biju,as u had mentioned, i dont feel itz the problem with the
database limitations, since I have now redirected the same page across
one another web-server which is connecting to the same database and
there it is perfectly fine and I dont c any direct limitations in the
display.
Hence as u had also mentioned, this might be related to some windows nt
+ iis issue. Thereby if u find such an instance of the problem and there
after a solution for the problem , kindly lemme know the same.
Thank You,
Regards,
Binny Chacko.
-----Original Message-----
From: Biju.Therakathilal [mailto:Biju.Therakathilal@t...]
Sent: Monday, October 14, 2002 11:50 PM
To: ASPToday Discuss
Subject: [asptoday_discuss] RE: Cant See Details - I am growing mad ...
Binny,
SQL 2000 has limit for varchar datatype and is 2MB. So it is well above
your
600 characters. I think the problem you are getting is due to some
settings
on IIS.
thanks
biju
-----Original Message-----
From: Binny Chacko [mailto:binny.chacko@w...]
Sent: Wednesday, October 09, 2002 10:01 AM
To: ASPToday Discuss
Subject: [asptoday_discuss] Cant See Details - I am growing mad ...
Hi All,
I am facing a strange problem of not being able to display data
from the database onto my ASP page. It simply truncates the data after
around 250 characters.
Scenario is that I have a varchar field in an SQL 2000 database which
has
some data around 600 characters in length but when i try displaying the
same
in a textarea field, the corresponding data is getting truncated.
Could some one guide me as to where I am going wrong with some settings?
Thank You,
Regards,
Binny Chacko.
DISCLAIMER:
Information contained and transmitted by this E-MAIL is proprietary to
Wipro
Limited and is intended for use only by the individual or entity to
which it
is addressed, and may contain information that is privileged,
confidential
or exempt from disclosure under applicable law. If this is a forwarded
message, the content of this E-MAIL may not have been sent with the
authority of the Company. If you are not the intended recipient, an
agent of
the intended recipient or a person responsible for delivering the
information to the named recipient, you are notified that any use,
distribution, transmission, printing, copying or dissemination of this
information in any way or in any manner is strictly prohibited. If you
have
received this communication in error, please delete this mail & notify
us
immediately at mailadmin@w...
DISCLAIMER:
Information contained and transmitted by this E-MAIL is proprietary to
Wipro Limited and is intended for use only by the individual or entity
to which it is addressed, and may contain information that is
privileged, confidential or exempt from disclosure under applicable law.
If this is a forwarded message, the content of this E-MAIL may not have
been sent with the authority of the Company. If you are not the intended
recipient, an agent of the intended recipient or a person responsible
for delivering the information to the named recipient, you are notified
that any use, distribution, transmission, printing, copying or
dissemination of this information in any way or in any manner is
strictly prohibited. If you have received this communication in error,
please delete this mail & notify us immediately at mailadmin@w...
|
|
|
View Cart
