Recordset is truncated after 255 characters

Dev Shed Forums Sponsor:

August 8th, 2012, 04:45 PM

frasersales-ltd

Registered User

Join Date: Apr 2012

Posts: 8

Time spent in forums: 1 h 17 m 45 sec
Reputation Power: 0

Recordset is truncated after 255 characters

I'm trying to read a CSV file into a database using classic ASP. The fields work ok apart from the description field is truncated after 255 characters. Even when I display the field straight after the below command the same issue happens. Looking at the CSV file, nothing seems to be stopping it after 255 characters i.e. carriage returns. A sample of the CSV file is below.

Code:

set myRS = myConn.Execute("SELECT [Description] FROM [Text;DATABASE=" & Server.MapPath("/fpdb/") & ";HDR=Yes].[PRD_new.csv]")

Do While not myRS.EOF
	response.write(myRS("Description"))
	myRS.MoveNext	
Loop

(CSV file)
Description
"Many wiki communities are private, particularly within enterprises. They are often used as internal documentation for in-house systems and applications. Some companies use wikis to allow customers to help produce software documentation.[25] A study of cor"

August 9th, 2012, 12:07 AM

Doug G

Grumpier Old Moderator

Dev Shed God 19th Plane (14000 - 14499 posts)

Join Date: Jun 2003

Posts: 14,233

Time spent in forums: 1 Month 4 Weeks 14 h 11 m 5 sec
Reputation Power: 4445

Maybe it's some limitation with the ado text driver. I've never used that driver.

__________________
======
Doug G
======
It is a truism of American politics that no man who can win an election deserves to. --Trevanian, from the novel Shibumi

August 13th, 2012, 12:08 PM

frasersales-ltd

Registered User

Join Date: Apr 2012

Posts: 8

Time spent in forums: 1 h 17 m 45 sec
Reputation Power: 0

I managed to solve this issue. Thanks for the help.

August 13th, 2012, 02:14 PM

Doug G

Grumpier Old Moderator

Join Date: Jun 2003

Posts: 14,233

Time spent in forums: 1 Month 4 Weeks 14 h 11 m 5 sec
Reputation Power: 4445

Quote:

Originally Posted by frasersales-ltd

I managed to solve this issue. Thanks for the help.

I'm glad you got it solved. What was causing the problem?

August 14th, 2012, 12:57 PM

frasersales-ltd

Registered User

Join Date: Apr 2012

Posts: 8

Time spent in forums: 1 h 17 m 45 sec
Reputation Power: 0

There was nothing wrong with the sample CSV file. There was just an error in my code. To prevent the description from being truncated after 255 characters. Some of the descriptions were blank so I deleted those and saved the CSV file. Now it's adding more than 255 characters to the database field.

August 14th, 2012, 05:08 PM

Doug G

Grumpier Old Moderator

Join Date: Jun 2003

Posts: 14,233

Time spent in forums: 1 Month 4 Weeks 14 h 11 m 5 sec
Reputation Power: 4445

Thank you for the update I'm glad it's working for you.

Recordset is truncated after 255 characters

Developer Shed Advertisers and Affiliates