Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-16391

Updating a blob on a table with InnoDB engine v10.3

    XMLWordPrintable

Details

    Description

      I cant get this code to work with "update" it returns 0 but dosen't update post, but it works with a "Insert"

      bufferlength = ((picturebufferlen)*2) + BUFFERSIZE +1;
      buffer = malloc(bufferlength);

      end = buffer;
      end += snprintf(buffer, bufferlength, "UPDATE billeder_table SET billed='");
      end += mysql_real_escape_string(&SQLconnection, end, picturebuffer, picturebufferlen);
      end += snprintf(end, bufferlength, "' WHERE %s = %s AND TS='%s';", SoegeFelt, Soegenummer, SoegeTimestam);
      if (mysql_real_query(&SQLconnection, buffer, end - buffer) > 0)

      { free(buffer); return 1; }

      Attachments

        Activity

          People

            Unassigned Unassigned
            michael.jensen1@youmail.dk Michael Jensen
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.