＋设为首页 ＋添加到收藏夹
SELECT restaurantid
FROM (select distinct restaurantid,regionid from restaurant_region)
WHERE instr(01,02,regionid)>0
GROUP BY restaurantid
HAVING (count( regionid) = len(01,02)-len(replace(01,02,,,))+1)
说明：上面的语句在access中正确执行！！！
-----------------------------------------
<cfset strSQL="SELECT restaurantid
FROM (select distinct restaurantid,regionid from restaurant_region)
WHERE instr(01,02,regionid)>0
GROUP BY restaurantid
HAVING (count( regionid) = len(01,02)-len(replace(01,02,,,))+1)">
<cfquery datasource="antx" name="test">
#PreserveSingleQuotes(strSQL)#
</cfquery>
------------------------------------
上面的程序即报错！！
提示信息：
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] 表达式中 replace 函数未定义。
为什么？replace是access的内置函数呀！！！！
说说怎么搞定的。
