关于<cfquery>中单引号变双引号问题
<cfset list1="SELECT * FROM computer_info_view where os_language='CH'; and os_name='Windows2000' and version='PRO';">

<cfquery name="sel_list" datasource="#ds#">

#list1#

</cfquery>
运行后...

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: Incorrect syntax near 'CH'.

SQL : SELECT * FROM computer_info_view where os_language=''CH''; and os_name=''Windows2000'' and version=''PRO'';
单引号全变成双引号？
[解决办法]
使用：PreserveSingleQuotes()函数，问题已解决。
[解决办法]
帮你结帖：）