Results 1 to 2 of 2

Thread: MySQL and ASP

  1. #1
    Join Date
    Dec 1969

    Default MySQL and ASP

    Why do I get the following error...:<BR><BR>Query-based update failed because the row to update could not be found<BR><BR>...with my ASP application using a DSN connection to a MYSQL database. I first used it with MSAccess also with DSN and it worked perfectly.<BR><BR>Here is the code:<BR><BR>set eigenaar = Server.CreateObject("ADODB.Recordset")<BR>eigenaar .ActiveConnection = MM_gw_STRING<BR>eigenaar.Source = "SELECT * FROM Eigenaar WHERE Gebruikersnaam = &#039;" + Replace(eigenaar__MMColParam, "&#039;", "&#039;&#039;") + "&#039;"<BR>eigenaar.CursorType = 0<BR>eigenaar.CursorLocation = 2<BR>eigenaar.LockType = 3<BR>eigenaar.Open()<BR>eigenaar.fields("name") = Replace(request.form("name"), "&#039;", "&#039;&#039;")<BR>eigenaar.update

  2. #2
    Join Date
    Dec 1969

    Default RE: MySQL and ASP

    Perhaps it is because you are using MySQL. That language is not the same SQL language as MS access or MS SQL Server from microsoft. You should find some MySQL forums on connection and updating an MySql DB.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts