Problem with a percentage (%) sign in wxString Topic is solved

[YuMERA]

Hi! How do I handle this?

I have SQL Query

Code: Select all

    scFindItem->SetValue("Pivo")   
       	wxString SQL = wxString::Format(_T("SELECT ID_art, naziv_art, kolicina_art, cena_art, grupa_naziv, grupa_ID, grupa_art "
                                         "FROM artikli,grupa "
                                         "WHERE grupa_art = grupa_ID AND "
                                         "naziv_art LIKE('%%s%')"),scFindItem->GetValue());

the result of that string is

SELECT ID_art, naziv_art, kolicina_art, cena_art, grupa_naziv, grupa_ID, grupa_art FROM artikli,grupa WHERE grupa_art = grupa_ID AND naziv_art LIKE('%s')

must be

SELECT ID_art, naziv_art, kolicina_art, cena_art, grupa_naziv, grupa_ID, grupa_art FROM artikli,grupa WHERE grupa_art = grupa_ID AND naziv_art LIKE('Pivo')

problem is from LIKE('%%s%')

[Kvaz1r]

For escaping '%' you can double it.
Example:

Code: Select all

wxString::Format("%%%s%%", "abs")

[YuMERA]

Thanks, that's it