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

Submitted by:  None
Submitted on:  Fri 05 Jul 2002 06:55:30 PM UTC  
Category: API - phpGWapiPriority: 5 - Normal
Item Group: NoneStatus: None
Privacy: PublicAssigned to: Caeies <Caeies>
Originator Email: -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, 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.



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


Do you think this task is very important?
If so, you can click here to add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.


Please enter the title of George Orwell's famous dystopian book (it's a date):



Follow 3 latest changes.

Date Changed By Updated Field Previous Value => Replaced By
Mon 12 Dec 2005 01:38:02 PM UTCskwashdAssigned toZone=>Caeies
Thu 15 Jan 2004 08:10:20 AM UTCpowerstatCategoryOther=>API - phpGWapi
Wed 11 Sep 2002 05:56:31 AM UTCZoneAssigned toNone=>NA

Back to the top

Powered by Savane 3.1-cleanup1