当从Coldfusion 8连接到MS SQL 2008数据源时,对于设置为“ uniqueidentifier”的SQL列,我应该使用哪种Coldfusion cfsqltype。
<cfquery name="user" datasource="#ds#"> SELECT id, username FROM users WHERE id = <cfqueryparam cfsqltype="WHAT_CF_SQL_TYPE_HERE?" value="#arguments.id#"> </cfquery>
谢谢!
CF_SQL_CHAR或CF_SQL_IDSTAMP
参见:http : //livedocs.adobe.com/coldfusion/8/htmldocs/Tags_p- q_18.html