OSCommerce Product Manager for Windows
FS#139 - Percent symbol is escaped from text...
Attached to Project:
OSCommerce Product Manager
Opened by Mario A. Valdez-Ramirez (mvaldez) - Sunday, 14 November 2004, 08:28 GMT
Last edited by Mario A. Valdez-Ramirez (mvaldez) - Sunday, 14 November 2004, 09:36 GMT
Opened by Mario A. Valdez-Ramirez (mvaldez) - Sunday, 14 November 2004, 08:28 GMT
Last edited by Mario A. Valdez-Ramirez (mvaldez) - Sunday, 14 November 2004, 09:36 GMT
|
DetailsThis bug is related to Bug #137.
The function FNopm_CleanSQLString in dataman.pas is escaping several characters that can cause problems in SQL strings. Among them, there were the percent symbol and the underscore. Bug 137 was about underscore character. As a solution we disable that escaping. This bug is about percent symbols. The real problem is that MySQL needs percent symbols and underscores escaped only when searching, not when entering or updating data. The solution is to let know the function FNopm_CleanSQLString when we are searching and when we are not. We added a new parameter (Searching) to be used only when the escaped string will be used as a search parameter (in a where clause). |
This task depends upon
Fixed. Closed.