Qt Code:
  1. int ProductsForm::categoryIdByName(const QString& name)
  2. {
  3. QSqlQuery categories = QSqlQuery(model->database());
  4. categories.exec(QString("SELECT id FROM Categories WHERE name='%1'").arg(name));
  5. categories.first();
  6. return categories.value(0).toInt();
To copy to clipboard, switch view to plain text mode 

it works now, and i still don't know why! ^^" but thanks anyway