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
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
