why can't i mysql_tquery after the query is escaped??
#1

i dont understand.. it should work..but cant not function. why? the mysql_log indicates it cant not recognize the escaped string
Reply
#2

Try to escape only the fields not the whole string at once.

I.E
Escaping inputtext from dialog:
Код:
mysql_escape_string(inputtext, inputtext);
new string[128]; format(string, sizeof(string), "UPDATE `table` SET `Field` = '%s' WHERE `Condition` = 1", inputtext);
mysql_tquery(connectionHandle, string, "");
Or use mysql_format with %e specifier
Код:
new string[128]; 
mysql_format(connectionHandle, string, sizeof(string), "UPDATE `table` SET `Field` = '%e' WHERE `Condition` = 1", inputtext);
mysql_tquery(connectionHandle, string, "");
Reply
#3

Quote:
Originally Posted by dodoc
Посмотреть сообщение
i dont understand.. it should work..but cant not function. why? the mysql_log indicates it cant not recognize the escaped string
If you are certain you did what was done above (Sk1lleD's post) you should post code. It makes it easier to help if it's a specific part failing only
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)