OSCommerce Product Manager

OSCommerce Product Manager for Windows
Tasklist

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, 02:28 GMT-6
Last edited by Mario A. Valdez-Ramirez (mvaldez) - Sunday, 14 November 2004, 03:36 GMT-6
Task Type Bug Report
Category Backend / Core
Status Closed
Assigned To Mario A. Valdez-Ramirez (mvaldez)
Operating System All
Severity Low
Priority Urgent
Reported Version any
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 0
Private No

Details

This 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

Closed by  Mario A. Valdez-Ramirez (mvaldez)
Sunday, 14 November 2004, 03:36 GMT-6
Reason for closing:  
Comment by Mario A. Valdez-Ramirez (mvaldez) - Sunday, 14 November 2004, 03:36 GMT-6

Fixed. Closed.

Loading...