phpGroupWare - Patches: patch #392, VFS: comparison on text fields
You are not allowed to post comments on this tracker with your current authentication level.
patch #392: VFS: comparison on text fields
Submitter: | None | ||
Submitted: | Fri 05 Jul 2002 06:55:30 PM UTC | ||
Category: | API - phpGWapi | Priority: | 5 - Normal |
Item Group: | None | Status: | None |
Privacy: | Public | Assigned to: | Caeies |
Originator Email: | -email is unavailable- | Open/Closed: | Open |
Fri 05 Jul 2002 07:23:12 PM UTC, comment #1: |
Bradley Bell <btb> |
Fri 05 Jul 2002 06:55:30 PM UTC, original submission:
mssql and sybase (at least) don't allow = comparisons on text fields. LIKE , however is fine, and in most circumstances is completely equivalent. Also, ORDER BY cannot be used on a text field. This patch fixes both problems.
|
Anonymous |
Attached Files
file #4511: patch_item_392.patch added by None (13KiB - text/plain - patch item 392)
Depends on the following items: None found
Items that depend on this one: None found
CC list is empty
There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.
Follow 3 latest changes.
Date | Changed by | Updated Field | Previous Value | => | Replaced by |
---|---|---|---|---|---|
2005-12-12 | skwashd | Assigned to | Zone | Caeies | |
2004-01-15 | powerstat | Category | Other | API - phpGWapi | |
2002-09-11 | Zone | Assigned to | None | None |
Powered by Savane 3.13-f8d8.
Corresponding source code
Ahh, of course this will fail if the file or directory contains the LIKE metacharacters 0r _. So I guess they need to be escaped somehow. This problem already exists in class.vfs_sql.inc.php, in the line:
$sql .= " FROM phpgw_vfs WHERE directory LIKE '$dir_clean%'";