per voi la sintassi è corretta?

[malecce]

secondo voi è corretta questa interrogazione di una database myql, io ricevo sempre un errore:

"SELECT ID, fldNAME FROM nm_tbl_cate WHERE ID IN (SELECT fldCATE_ID FROM nm_tbl_news_cate WHERE fldNEWS_ID = " & NID & ")"
posto anche l'errore:

[MySQL][ODBC 3.51 Driver][mysqld-4.0.15-nt]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT fldCATE_ID FROM nm_tbl_news_cate WHERE fldNEWS_ID = 3)'

grazie , spero di non aver sbagliato forum


Maurizio

[gensole]

prova così

"SELECT ID, fldNAME FROM nm_tbl_cate WHERE ID IN (SELECT fldCATE_ID FROM nm_tbl_news_cate WHERE fldNEWS_ID = '" & NID & "')"

[malecce]

sembrerebbe di no , ho corretto come mi hai suggerito e cioè:

SQL = "SELECT ID, fldNAME FROM nm_tbl_cate WHERE ID IN (SELECT fldCATE_ID FROM nm_tbl_news_cate WHERE fldNEWS_ID ='"& NID & "')"

l'errore è:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[MySQL][ODBC 3.51 Driver][mysqld-4.0.15-nt]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT fldCATE_ID FROM nm_tbl_news_cate WHERE fldNEWS_ID = '3')

mi sembra + o meno lo stesso di prima

ciao

[Mems]

sql =  "SELECT nm_tbl_cate.ID, nm_tbl_cate.fldNAME " &_
       "FROM nm_tbl_cate " &_
       "INNER JOIN nm_tbl_news_cate " &_
       "ON nm_tbl_news_cate.fldNEWS_ID = m_tbl_cate.ID " &_
       "WHERE nm_tbl_news_cate.fldNEWS_ID = " & NID