Using cfqueryparam

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.