Excelent!...thanks Jay. When I first started to use CF I always wondered
why it didn't ask for the size of the varchar param Personally I think it
would be usefull for this to be compulsory as it is at the other end in SQL.
------------------------------------------------------------------
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
------------------------------------------------------------------
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
------------------------------------------------------------------
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 419 4235
------------------------------------------------------------------
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
-----Original Message-----
From: Jay White [mailto:[EMAIL PROTECTED]]
Sent: 02 November 2000 14:57
To: CF-Talk
Subject: RE: SQL Server 7.0 Stored Procedures
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]
------------------------------------------------------------------------------------------------
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]
