Hello,

I have below column on one of my SQL server database :

id int(4)
status varchar(255)
username varchar(30)
email varchar(60)
priority char(255)
category varchar(100)
subject varchar(300)
description varchar(8000)
ticdate datetime(8)
url varchar(50)

In my webpage, there is a TEXTAREA box where user input their comment and
then submit details to my asp page that will insert the records to the
database column above.

When I checked on the column description, it only shows the first line of
details from the TEXTAREA box and all the inputs below the first line is not
stored into the description column.


Should I change the description column type or anything?


Thanks for the advice.



Andy

Andy,

Please post your code & procedure.

Mark.
--- Andy <andy@t...> wrote:
> Hello,
> 
> I have below column on one of my SQL server database
> :
> 
> id int(4)
> status varchar(255)
> username varchar(30)
> email varchar(60)
> priority char(255)
> category varchar(100)
> subject varchar(300)
> description varchar(8000)
> ticdate datetime(8)
> url varchar(50)
> 
> In my webpage, there is a TEXTAREA box where user
> input their comment and
> then submit details to my asp page that will insert
> the records to the
> database column above.
> 
> When I checked on the column description, it only
> shows the first line of
> details from the TEXTAREA box and all the inputs
> below the first line is not
> stored into the description column.
> 
> 
> Should I change the description column type or
> anything?
> 
> 
> Thanks for the advice.
> 
> 
> 
> Andy
> 
> 


__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/

If you're talking about Enterprise Manager, it will only display the 
first line (or at least only something like the first 256 characters) of 
data in any field......therefore to truly test things, setup a 
connection through an ASP page and SELECT description from TABLE and 
output the contents.  You'll probably find that this will display the 
whole text ......
Cheers
Paul

-----Original Message-----
From: Andy [mailto:andy@t...]
Sent: Saturday, 22 February 2003 8:46 PM
To: ASP Databases
Subject: [asp_databases] Details not stored properly in SQL table


Hello,

I have below column on one of my SQL server database :

id int(4)
status varchar(255)
username varchar(30)
email varchar(60)
priority char(255)
category varchar(100)
subject varchar(300)
description varchar(8000)
ticdate datetime(8)
url varchar(50)

In my webpage, there is a TEXTAREA box where user input their comment 
and
then submit details to my asp page that will insert the records to the
database column above.

When I checked on the column description, it only shows the first line 
of
details from the TEXTAREA box and all the inputs below the first line is 
not
stored into the description column.


Should I change the description column type or anything?


Thanks for the advice.



Andy

Hi,

If you are viewing this data in Enterprise Manager, then only the first line
is displayed by default. Place your cursor into the field, and press the
"Down" arrow on your keyboard to see subsequent lines.

Alternatively, extract the data into your presentation layer (ASP, VB,
Access) and you should be able to see all the data.

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Andy" <andy@t...>
Subject: [asp_databases] Details not stored properly in SQL table


: I have below column on one of my SQL server database :
:
: id int(4)
: status varchar(255)
: username varchar(30)
: email varchar(60)
: priority char(255)
: category varchar(100)
: subject varchar(300)
: description varchar(8000)
: ticdate datetime(8)
: url varchar(50)
:
: In my webpage, there is a TEXTAREA box where user input their comment and
: then submit details to my asp page that will insert the records to the
: database column above.
:
: When I checked on the column description, it only shows the first line of
: details from the TEXTAREA box and all the inputs below the first line is
not
: stored into the description column.
:
:
: Should I change the description column type or anything?