Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." 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 Basics 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
  #1 (permalink)  
Old October 5th, 2005, 10:19 AM
Registered User
 
Join Date: Oct 2005
Location: Nashua, NH, USA.
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default scrolling text box

I'm trying to save the contents of a scrolling text box that i have create in my asp form and save the data into an access database. It will only save the first line of text and when I try to retrieve the data it doesn't show up. Can anyone help me with this?
  #2 (permalink)  
Old October 5th, 2005, 05:51 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Melbourne, Vic, Australia.
Posts: 308
Thanks: 0
Thanked 0 Times in 0 Posts
Default

do you mean you're using <input type=text> and doing something wierd with it, or are you using <textarea></textarea> and it's still only saving the first bit?

I am a loud man with a very large hat. This means I am in charge
  #3 (permalink)  
Old October 6th, 2005, 07:13 AM
Registered User
 
Join Date: Oct 2005
Location: Nashua, NH, USA.
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I'm using <textarea></textarea>

  #4 (permalink)  
Old October 6th, 2005, 10:48 AM
Friend of Wrox
 
Join Date: Jul 2003
Location: , , United Kingdom.
Posts: 683
Thanks: 0
Thanked 1 Time in 1 Post
Default

Is the db field large enough for what you are trying to insert.

Can you post your code?

Cheers,

Chris

  #5 (permalink)  
Old October 20th, 2005, 01:15 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Melbourne, Vic, Australia.
Posts: 308
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I haven't worked with Access in a while - but possibly if you're using a Text field type (it might even happen on Memo) that new line characters aren't loved by Access -
Maybe try something like
Code:
Rs("YourField") = Replace(Request.Form("YourTextArea"), chr(13), "<br>")
when updating, that way you can see if it is the newline characters causing you grief

I am a loud man with a very large hat. This means I am in charge
  #6 (permalink)  
Old October 29th, 2005, 03:55 AM
Registered User
 
Join Date: Oct 2005
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

1. Your data type needs to be set to text or large enough to store all data. 2. You must read this field last from the recordset, otherwise this field and any fields read thereafter will not display.

  #7 (permalink)  
Old November 10th, 2005, 05:26 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Melbourne, Vic, Australia.
Posts: 308
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
quote:2. You must read this field last from the recordset, otherwise this field and any fields read thereafter will not display.
Never heard of this before, and I must say that I'd have to disagree on principle. whether reading or writing to a recordset, it doesn't matter what the order of fields is.


I am a loud man with a very large hat. This means I am in charge


Similar Threads
Thread Thread Starter Forum Replies Last Post
running scrolling text from stored procedure in VS cJeffreywang ASP.NET 2.0 Basics 1 August 14th, 2007 03:47 PM
Scrolling on text box echovue Access VBA 2 January 3rd, 2007 03:57 PM
text scrolling, background staitonery john txforthehelp Javascript How-To 4 May 23rd, 2006 11:37 AM
Scrolling thru a large list box - using keystrokes bill unswort VBScript 1 August 27th, 2004 07:20 AM





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