the information shouldn't be going INTO the db with paragraph format. you
should have WRAP="HARD" in your textarea control, then insert the data
straight. PAaragraphForamt() is for output, not inuput.
chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com
-----Original Message-----
From: Dave Wilson [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 10:03 AM
To: CF-Talk
Subject: Strange output phenomenon
Hi All,
Got a really strange problem here with Paragraphformat
Scenario:
A user enters a list of names into a form field (textarea field in this
case), which is then parsed so as to enter the names into an Access
field using the Paragraphformat function in CF.
i.e. user inputs:
Dave1
Dave2
Dave3
Dave4
Dave5
Which becomes
Dave1 <p>Dave2 <p>Dave3 <p>Dave4 <p> Dave5
In Access field - Thus far so good
However, when outputting the prior user inputs above, simply using
<cfoutput>
#query.fieldname#
</cfoutput>
I am getting
Dave
Dave2
Dave
Dave4
Dave5
(Notice the missing "3" and "1")
I've also tried this with various different inputs, leading to an
interesting result as demonstrated below
INPUT:
Dave12345
Dave12345
Dave101
Dave245
Dave
RETURNS:
Dave
245
Dave
245
Dave
0
Dave245
Dave
(As you may notice, the "1" and "3" are being treated as <BR> tags?????)
System Environment:
NT4 SP6, CF4.01 Enterprise, MS Access datasource
Anybody ever seen this before or have any idea what's going on?
Thanks in advance
Dave
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists