Qt Forum

    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Unsolved

    Does the lates mysql support parameter binding in IN parameters

    General and Desktop
    mysql
    1
    1
    304
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Maikoly
      Maikoly last edited by

      query = new QSqlQuery();
      query->prepare("Call log(:usernam,:pass)");
      query->isSelect();
      //query->prepare("SELECT * FROM pumaro.users WHERE (userID = :usernam AND password1 = :pass)");
      query->bindValue(":usernam",QVariant(user),QSql::In);
      query->bindValue(":pass",QVariant(pass),QSql::In);
      query->exec();

      the commented section works fine. but the Call procedure(); returns Size -1. Whats wrong with the code.. Am I doing it Wrong. Any Assistance and advise shall be appreciated.

      MIC TEC SYSTEMS.Ke

      1 Reply Last reply Reply Quote 0
      • First post
        Last post