pdoria
24th March 2012, 17:46
Must be seeing things... but why:
sql = "SELECT * FROM garmin_packets WHERE unit_imei=? AND fmi_packet_id=? AND unique_id=?";
queryCheck.prepare(sql);
queryCheck.bindValue(0, this->connAvlImei);
queryCheck.bindValue(1, FMI_A607_DRIVER_ID_UPDATE);
queryCheck.bindValue(2, driver_id.change_id);
queryCheck.exec ( sql );
produces this:
"SELECT * FROM garmin_packets WHERE unit_imei=? AND fmi_packet_id=? AND unique_id=?"
QSqlError(-1, "QPSQL: Unable to create query", "ERROR: operator does not exist: character =?
LINE 1: SELECT * FROM garmin_packets WHERE unit_imei=? AND fmi_packe...
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
")
??? :confused:
Btw I made sure to check my stupidity and caffeine levels... all checked out inside reasonable range... ;)
sql = "SELECT * FROM garmin_packets WHERE unit_imei=? AND fmi_packet_id=? AND unique_id=?";
queryCheck.prepare(sql);
queryCheck.bindValue(0, this->connAvlImei);
queryCheck.bindValue(1, FMI_A607_DRIVER_ID_UPDATE);
queryCheck.bindValue(2, driver_id.change_id);
queryCheck.exec ( sql );
produces this:
"SELECT * FROM garmin_packets WHERE unit_imei=? AND fmi_packet_id=? AND unique_id=?"
QSqlError(-1, "QPSQL: Unable to create query", "ERROR: operator does not exist: character =?
LINE 1: SELECT * FROM garmin_packets WHERE unit_imei=? AND fmi_packe...
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
")
??? :confused:
Btw I made sure to check my stupidity and caffeine levels... all checked out inside reasonable range... ;)