Check your ODBC connection. Make sure that "Enable retrieval of long text" is checked.
----- Original Message -----
From: Brian Panulla <[EMAIL PROTECTED]>
Date: Friday, January 24, 2003 2:19 pm
Subject: CFQUERYPARAM and MSSQL7 TEXT fields
> We're using CFQUERYPARAM tags on a project for the first time (CF5
> Windows
> / SQL Server 7) and we've had a lot of success in improving the
> general
> performance of the application.
>
> We just ran into one stumbling block: TEXT fields. If we use the
> CFQUERYPARAM SQLDATATYPE of "CF_SQL_VARCHAR," our queries will run
> until we
> go larger than the 8000 character limit of a SQL 7 Varchar, and
> then it
> will throw an error ("Right truncation of character data"). We
> need to
> store more than this amount of character data, hence the choice to
> use TEXT
> fields in the first place.
>
> According to MSDN, the ODBC binding type of LONGVARCHAR
> corresponds to the
> TEXT field type, but using "CF_SQL_LONGVARCHAR" exhibits the same
> behavior.
> Anyone know how to fix this?
>
> Brian
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
