Wrox Programmer Forums
|
Classic ASP Professional For advanced coder questions in ASP 3. 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 Professional 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 September 5th, 2006, 01:56 AM
Registered User
 
Join Date: Mar 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to phishcoder
Default unusual issue with textarea

I'm using asp classic, vbscript and sql server.

The most condensed way to pose the question is I need to be able to perform a LineFeed and CarriageReturn in both a (Window's program written in VB) VB textarea and an HTML textarea using text type data from a sql server field. And I need to use an HTML textarea to input the new string if it matters.

The field in question is a notes field and it includes a date such as:

Date: NoteStringWhatEver

Here's the tricky part...

When a new note is created, the note is concatenated to the beginning of the previous note..

8-31-06: Note
7-31-06: Another Note

I need to store this string in such a way in a sql server field that both vb and the textarea will be able to display it as:

8-1-06: Note
7-31-06: Another Note

and not...

8-1-06: Note 7-31-06: Another Note

and not...

8-1-06: Note#10;#13;7-31-06: Another Note

and not...

8-1-06:Note<br>7-31-06:Another Note

I have no control whatsoever over the VB Window's program nor the sql table. It would be great to have a separate notes table but it's not possible.

Any help would be greatly appreciated.

Jason
 
Old September 5th, 2006, 06:42 AM
Wrox Author
 
Join Date: Oct 2005
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons
Default

Have you tried using vbCRLF?

"The one language all programmers understand is profanity."
 
Old September 5th, 2006, 11:48 PM
Registered User
 
Join Date: Mar 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to phishcoder
Default

That got it. Thanks.


 
Old September 6th, 2006, 07:25 AM
Wrox Author
 
Join Date: Oct 2005
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons
Default

glad it worked.

"The one language all programmers understand is profanity."





Similar Threads
Thread Thread Starter Forum Replies Last Post
Tab function + <textarea></textarea> Adam H-W HTML Code Clinic 0 April 24th, 2007 10:36 AM
regarding textarea in asp nkramanmca Classic ASP Components 4 January 24th, 2005 03:53 AM
unusual space yami56 Dreamweaver (all versions) 7 August 15th, 2004 06:39 AM
display vbCrLf's from textarea to textarea mat41 Classic ASP Basics 8 June 10th, 2004 12:19 AM
TextArea microchip Classic ASP Databases 2 March 17th, 2004 11:19 AM





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