主题:  急急急

dllyzs

职务:普通成员
等级:1
金币:0.0
发贴:18
注册:2002/8/2 10:06:22
#12002/11/23 12:24:13
谁能告诉我是什么错误
源码

    SELECT DISTINCT TITLE.SUB_ID
    FROM SUB,TITLE
    WHERE CAT_ID=#URL.CAT_ID#
    
     AND Bord_id=#url.bord_id#
    

    AND TITLE.Title LIKE '%#Form.keyword#%'
    AND TITLE.SUB_ID=SUB.SUB_ID

ODBC Error Code = 22005 (Error in assignment)


[Microsoft][ODBC Microsoft Access 驱动程序] 内存溢出


SQL = "SELECT DISTINCT TITLE.SUB_ID FROM SUB,TITLE WHERE CAT_ID=2 AND TITLE.Title LIKE '%贴图%' AND TITLE.SUB_ID=SUB.SUB_ID"

Data Source = "LB_CFM"


The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (61:4) to (61:56).



5DDC版主

职务:版主
等级:6
金币:10.0
发贴:3820
注册:2002/3/25 21:30:11
#22002/11/23 19:34:37
SQL语法错误

SELECT DISTINCT TITLE.SUB_ID
FROM SUB,TITLE

错误