patchphpGroupWare - 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: 

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%'";

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

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

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 toZone Caeies
2004-01-15 powerstat CategoryOther API - phpGWapi
2002-09-11 Zone Assigned toNone None

Back to the top

Powered by Savane 3.13-f8d8.
Corresponding source code