Are you using CFMX? I've had that problem using WDDX packets in client vars
that are stored in the DB because the Java type that CFMX uses is/was (fixed
yet? dunno) not large enough to handle the string. Perhaps you are having
the same issue.
+-----------------------------------------------+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+-----------------------------------------------+
"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis
"Let's Roll"
- Todd Beamer, Flight 93
-----Original Message-----
From: John McCosker [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 17, 2003 10:51 AM
To: CF-Talk
Subject: Data getting truncated on select
Greetings,
I am querying a row in a table bringing back a large about of html data
from a column named RawData, data type TEXT,
When outputting a lot of data is not getting output, this is really strange,
But I went into query analyzer and updated the field with a really large
text string,
"data data etc........... end"
on outputting the data it was prove somehow on select its being truncated as
"end"
did not get output.
My stored proc looks like this,
CREATE PROCEDURE leo4_getScheduledData
(
@customerID INT,
@MacroName VARCHAR(50),
@ContainerID INT
)
AS
SELECT *
FROM SchedulesContainer
WHERE [EMAIL PROTECTED]
AND [EMAIL PROTECTED]
AND [EMAIL PROTECTED]
any ideas would be appreciated.
J
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at
http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
