Wrox Programmer Forums
|
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 10th, 2004, 02:34 AM
Registered User
 
Join Date: Feb 2004
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default String getting truncated while displaying in asp

Hi,
I have problems in displaying a column (of msaccess table) in asp form with a string value having gaps in between. Suppose I stored a column "This is a string" in a msacces table column. When I display the string it shows (in asp form), "This" only. The portion following the first blank in the string gets truncated. Could you please tell me how the entire string, i.e., "This is a string" can be displayed instead of "This".
Thanks in advance
 
Old February 10th, 2004, 11:16 AM
Authorized User
 
Join Date: Dec 2003
Posts: 81
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Please post your code

John

 
Old February 10th, 2004, 12:08 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Are you displaying the text in a text box? If so, you need to enclose the value attribute in quotes (In fact, you should always enclose your attributes, to create XHTML compliant code):

<input type=text value=This is not a Good example>

<input type="text" value="This is a much better example" />

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.





Similar Threads
Thread Thread Starter Forum Replies Last Post
String or binary data would be truncated spiffyaldo2 ASP.NET 1.0 and 1.1 Basics 1 March 21st, 2006 08:49 AM
String or binary data would be truncated. Cinderella Classic ASP Basics 3 June 5th, 2004 04:36 AM
need to be truncated PatrickH SQL Server ASP 2 April 15th, 2004 10:48 AM
Truncated Report in CR9 and CRViewer for asp.net binnot Crystal Reports 1 February 13th, 2004 04:29 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.