UPDATE problem on linux

[bonosa]

I am doing:

query.sprintf ("UPDATE %s SET %s = %d WHERE ID = %d",
aTable.latin1 (), m_alg.latin1 (),
tempScore.toInt (), ID);
qDebug("score query %s",query.latin1());
int res = mysqlQuery (m_link, query);

The query is :

UPDATE alg$1649760492$1$100files SET alg_C = 909 WHERE ID = 2

If I do this manually in mysql it works. But for some reason my code doesnt do it, and it also doesnt report an error. This exact same code works on windows.

 

[azzazzello]

you might want to go into a few more detail here....what is the tool you are using to interface with MySQL?

 

[sem]

I may assume that $ sign is interpreted on Linux as environment variable marker.

Regards, Dima

http://seminihin.narod.ru