What is the most suitable type of cfsqltype Coldfusion to use in a field like a unique MS SQL identifier?

When connecting with Coldfusion 8 to an MS SQL 2008 data source, which Coldfusion cfsqltype class should be used for the SQL column set to "uniqueidentifier".

<cfquery name="user" datasource="#ds#">
    SELECT id, username
    FROM users
    WHERE id = <cfqueryparam cfsqltype="WHAT_CF_SQL_TYPE_HERE?" value="#arguments.id#">
</cfquery>

Thank!

+3
source share
1 answer
+5
source

Source: https://habr.com/ru/post/1726397/


All Articles