[Mysql] Campo Null o vuoto

[Descendz]

Salve ragazzi,
ho realizzato questa stringa mysql

Set rs = Conn.Execute("select * from tabella where campoa='" & valore1 & "' and campo2<>"" and  campo3='campo3'")

Purtroppo continuo a ricevere questo erroe

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

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 '" and campo3='campo3'' at line 1

Perchè?

[optime]

posta la stringa reale

[Descendz]

Stringa:

Set rs = Connlo.Execute("select * from clientimetatab where emailmeta='" & actionform2 & "' and  utconferma<>''  validometa='conferma'")

Errore:

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

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 'validometa='conferma'' at line 1

[optime]

ti manca un operatore logico (AND, OR;...) prima di validometa