Hi, i have done doing a code for a mini-aplication of a Newsletter module...

The problem is that i have being developing the Module with MySQL 5.1 in localhost(myPC), but now when i upload the files and i make the connection with my hosting on iPowerWeb.com, it print this message...

*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 'SELECT
COUNT(CEDULA) FROM NEWSLETTER WHERE CEDULA = '0011809226 *

My select's work fine in my computer but isnt working on the server... i think that is the version of iPowerWeb MySQL (3.23)

The syntax that i used in my select is this:

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Dim rs
Set rs = Server.CreateObject("ADODB.Recordset"
rs.ActiveConnection = MM_db_connection_STRING
rs.Source = "SELECT IF((SELECT COUNT(CEDULA) FROM NEWSLETTER WHERE CEDULA = '"&Request.Form("cedula"&"') &gt; 0, 'SI', 'NO') as resultado"
rs.CursorType = 0
rs.CursorLocation = 2
rs.LockType = 1
rs.Open()
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Edited by - djraptor on 06 Jun 2006 18:44:56

Edited by - djraptor on 06 Jun 2006 18:45:11