insert to database from visual c++

[auliac]

i have built aplication to insert data from database. i have two variables they are m_UserName and m_Password.

my code like this :


CDatabase db;

db.OpenEx(_T("DSN=billing test; UID = root"),CDatabase::noOdbcDialog);
db.ExecuteSQL("INSERT INTO user VALUES ('m_UserName' , 'm_Password')");

why were data inserted in my database m_UserName and m_Password? not the value of that variable? if i want to insert the value of the variable, what should i do?

thanks for every think....

[GCDEF]

Because you used string literals instead of variables in your code.

[auliac]

ok. thanks...