0 Replies Latest reply on Nov 5, 2008 7:27 PM by ottz0

    MYSQL error

    ottz0 Level 1
      I have made a recordset in DW and made the binding for it and tested the record and that is ok. It shows the record.

      I am making a user login page and havve my database made with username and password. Again I tested the recordset in DW which shows the records.

      When I view in localhost and press login button it get this error. I don't understand because the fields I created etc are standard.

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

      [MySQL][ODBC 5.1 Driver][mysqld-5.0.41-community-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 '[admin] WHERE usrname = _latin1'ffbb' AND usrpwrd = _latin1'fbbfb'' at line 1

      /sps/login.asp, line 55

      Any ideas?