OK, I figure out my problem with truncated output parameters in
stored procedures. When you create the parameter with CF, there is an
'optional' MAXLENGTH parameter that you can set. If you do not specify
the MAXLENGTH for varchar, it defaults to 255. That explains the
truncation of the varchar(2000) output parameter that I was trying to get
from the stored proc. It is probably good practice to always use the
MAXLENGTH, even though it is optional, because even a VARCHAR(1) would be
set up as a VARCHAR(255) . . .
Thanks anyway,
Jay White
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
