Lucee documentation says that cfsqltype is deprecated and that sqltype
should be used instead. However, I can’t seem to find good documentation on
sqltype. If I were to use sqltype instead of cfsqltype in the following
example:
INSERT INTO someTable
(
someText
)
VALUES
(
<cfqueryparam value=“#form.myTextArea#” cfsqltype=“CF_SQL_LONGVARCHAR”
)
what string would sqltype accept instead of “CF_SQL_LONGVARCHAR” ?
I think it means instead of ‘cfsqltype’ just drop the cf or ‘sqltype’,
also instead of ‘CF_SQL_LONGVARCHAR’ you should be able to just use
‘LONGVARCHAR’.On Wednesday, August 10, 2016 at 6:24:49 PM UTC-5, Zy Danielson wrote:
Lucee documentation says that cfsqltype is deprecated and that sqltype
should be used instead. However, I can’t seem to find good documentation on
sqltype. If I were to use sqltype instead of cfsqltype in the following
example:INSERT INTO someTable
(
someText
)
VALUES
(
)what string would sqltype accept instead of “CF_SQL_LONGVARCHAR” ?
Thanks Mark, and Philip. You guys are great.