Revisions for framework/SQL/SQL.php

Location: [ Horde ] / framework / SQL / SQL.php View: Logs | Branches | Statistics
Search Revisions:
Show diffs between and
Show Differences shows diffs to the previous revision. If you select a revision by clicking its row, Show Differences will show the differences to the selected row.
Show Branch:
  Revision Date Author Log Message
1.30.2.20 FRAMEWORK_3 (+2 -2 lines) 01/02/2008 06:30 AM Jan Schneider jan

Happy New Year

Tags: HORDE_3_3, HORDE_3_3_RC1, HORDE_3_2_2, HORDE_3_2_1, HORDE_3_2, HORDE_3_2_RC4, HORDE_3_2_RC3, HORDE_3_2_RC2

1.52 (+2 -2 lines) 01/02/2008 06:12 AM Jan Schneider jan

Happy New Year

1.30.2.19 FRAMEWORK_3 (+33 -9 lines) 12/20/2007 08:49 AM Jan Schneider jan

Merge from HEAD.

1.30.2.18 FRAMEWORK_3 (+3 -3 lines) 01/02/2007 08:54 AM Jan Schneider jan

Happy New Year

Tags: HORDE_3_1_9, HORDE_3_1_8, HORDE_3_1_7, HORDE_3_1_6, HORDE_3_1_5, HORDE_3_1_4, HORDE_3_1_4_RC1

1.51 (+2 -2 lines) 01/02/2007 07:47 AM Jan Schneider jan

Happy New Year

Tags: BEFORE_MERGE_3_2, HORDE_3_2_RC1, HORDE_3_2_ALPHA

1.50 (+3 -4 lines) 01/01/2007 07:40 PM Jan Schneider jan

Assign copyright to The Horde Project for those copyright holders that already agreed to it.

1.49 (+3 -3 lines) 12/30/2006 03:24 PM Jan Schneider jan

Standardize copyright wrapping and spacing.

1.48 (+28 -4 lines) 10/25/2006 12:47 PM Jan Schneider jan

Allow to search through API for matches at word boundaries only.

1.30.2.17 FRAMEWORK_3 (+20 -15 lines) 04/18/2006 11:49 PM Ben Chavet ben

MFH: 1.47

Tags: HORDE_3_1_3, HORDE_3_1_2

1.47 (+19 -14 lines) 04/18/2006 06:24 PM Ben Chavet ben

Fix group permission checks.
Bug:  3646

1.46 (+3 -2 lines) 02/14/2006 12:21 AM Matt Selsky selsky

split -> explode

1.30.2.16 FRAMEWORK_3 (+14 -3 lines) 01/18/2006 02:30 PM Ben Chavet ben

MFH: 1.45

Tags: HORDE_3_1_1, HORDE_3_1, HORDE_3_1_RC3, HORDE_3_1_RC2

1.45 (+14 -3 lines) 01/17/2006 11:16 PM Ben Chavet ben

fix bitwise-and for mssql

1.30.2.15 FRAMEWORK_3 (+3 -3 lines) 01/01/2006 04:28 PM Jan Schneider jan

Happy new year

Tags: HORDE_3_1_RC1

1.44 (+3 -3 lines) 01/01/2006 04:10 PM Jan Schneider jan

Happy new year\!

1.30.2.14 FRAMEWORK_3 (+1 -1 lines) 10/18/2005 07:01 AM Jan Schneider jan

Merged from HEAD.

1.30.2.13 FRAMEWORK_3 (+1 -7 lines) 07/03/2005 01:52 AM Matt Selsky selsky

MFH: Remove "@access public" and fix formatting/wrapping.

Tags: HORDE_3_0_12, HORDE_3_0_11, HORDE_3_0_10, HORDE_3_0_9, HORDE_3_0_8, HORDE_3_0_7, HORDE_3_0_6, HORDE_3_0_6_RC1, HORDE_3_0_5, HORDE_3_0_5_RC2, HORDE_3_0_5_RC1

1.43 (+1 -7 lines) 07/03/2005 01:21 AM Matt Selsky selsky

Remove "@access public" and fix formatting/wrapping.

Tags: BEFORE_MERGE_3_1

1.30.2.12 FRAMEWORK_3 (+2 -3 lines) 06/09/2005 10:22 PM Matt Selsky selsky

MFH: 1.42

1.42 (+2 -3 lines) 06/09/2005 09:29 PM Matt Selsky selsky

Another one.

1.30.2.11 FRAMEWORK_3 (+2 -3 lines) 06/09/2005 06:49 PM Matt Selsky selsky

MFH: 1.41

1.41 (+2 -3 lines) 06/09/2005 06:47 PM Matt Selsky selsky

Don't use separate prepare and execute calls.

1.30.2.10 FRAMEWORK_3 (+4 -4 lines) 05/26/2005 07:01 PM Matt Selsky selsky

MFH: Clean up phpdoc.

1.40 (+4 -4 lines) 05/26/2005 06:19 PM Matt Selsky selsky

Clean up phpdoc.

1.30.2.9 FRAMEWORK_3 (+2 -2 lines) 05/25/2005 12:27 PM Matt Selsky selsky

MFH: [mas] Fix SQL 'LIKE' case-insensitive comparison. (Bug #2030)

1.39 (+2 -2 lines) 05/25/2005 12:08 PM Matt Selsky selsky

[mas] Fix SQL 'LIKE' case-insensitive comparison. (Bug #2030)

1.30.2.8 FRAMEWORK_3 (+13 -14 lines) 05/21/2005 01:19 PM Matt Selsky selsky

MFH: Clean up ws and return types in phpdoc.

1.38 (+13 -14 lines) 05/21/2005 11:48 AM Matt Selsky selsky

Clean up ws and return types in phpdoc.

1.30.2.7 FRAMEWORK_3 (+3 -2 lines) 04/19/2005 03:56 AM Jan Schneider jan

MFH 1.37

1.37 (+2 -1 lines) 04/19/2005 03:32 AM Jan Schneider jan

MSSQL uses the same bit operator syntax like ODBC.

Bug: 1816

1.30.2.6 FRAMEWORK_3 (+3 -3 lines) 04/07/2005 10:25 AM Jan Schneider jan

MFH 1.36

1.36 (+2 -2 lines) 04/07/2005 10:20 AM Jan Schneider jan

Fixed prepare placeholders with Oracle and ODBC.

1.30.2.5 FRAMEWORK_3 (+2 -2 lines) 03/16/2005 12:23 PM Chuck Hagenbuch chuck

MFH 1.35

Tags: HORDE_3_0_4, HORDE_3_0_4_RC2

1.35 (+2 -2 lines) 03/16/2005 12:22 PM Chuck Hagenbuch chuck

Putting '?' into the query with a %d sprintf argument turns it into a
0, not a ?, making the query rather confused. Fixes problems with
pgsql.

1.30.2.4 FRAMEWORK_3 (+16 -2 lines) 03/16/2005 11:58 AM Chuck Hagenbuch chuck

MFH 1.34

1.34 (+16 -2 lines) 03/16/2005 11:58 AM Chuck Hagenbuch chuck

Fix handling of IN with bind variables.

1.30.2.3 FRAMEWORK_3 (+77 -15 lines) 03/16/2005 06:59 AM Jan Schneider jan

MFH: Fix DataTree SQL driver on Oracle; use SQL bindings in attribute retrieval.

1.33 (+76 -14 lines) 03/16/2005 06:14 AM Jan Schneider jan

Add escapePrepare() to escape placeholders for prepare/execute statements.
Extend buildClause() to return a prepare statement and the according values
instead of the complete SQL query if requested.

1.30.2.2 FRAMEWORK_3 (+11 -13 lines) 02/26/2005 10:48 PM Chuck Hagenbuch chuck

MFH 1.32

Tags: HORDE_3_0_4_RC1

1.32 (+11 -13 lines) 02/26/2005 10:48 PM Chuck Hagenbuch chuck

- always take database objects by reference
- make sure we're putting in 'NULL' instead of empty if we mean NULL.
- remove @version
- use implode, not join

1.31 (+1 -1 lines) 01/03/2005 08:09 AM Jan Schneider jan

Happy New Year

1.30.2.1 FRAMEWORK_3 (+3 -3 lines) 01/03/2005 07:19 AM Jan Schneider jan

Happy New Year

Tags: HORDE_3_0_3, HORDE_3_0_3_RC1, HORDE_3_0_2, HORDE_3_0_1

1.30 (+6 -6 lines) 12/18/2004 10:53 PM Chuck Hagenbuch chuck

avoid some sprintf calls

Tags: FRAMEWORK_3, HORDE_3_0

1.29 (+6 -6 lines) 09/03/2004 10:24 AM Chuck Hagenbuch chuck

Fix FOR UPDATE syntax (oracle) (#533)

Tags: HORDE_3_0_RC3

1.28 (+65 -2 lines) 06/08/2004 10:29 AM eraserhd

New Horde_SQL::insertValues() and Horde_SQL::updateValues()

1.27 (+6 -2 lines) 02/24/2004 12:14 PM mdjukic

Fix Bitewise AND cconstruct for odbc driver

Submitted by: marcus

Tags: HORDE_3_0_ALPHA

1.26 (+8 -2 lines) 01/31/2004 01:43 PM Chuck Hagenbuch chuck

Bitwise support for Oracle.

Submitted by: Alan Wood <alan@woodysoft.co.uk>

1.25 (+8 -2 lines) 01/09/2004 10:54 AM Jan Schneider jan

Add regexp operator. Does anyone know syntaxes of other RDMBs than MySQL and PostgreSQL?

1.24 (+3 -3 lines) 01/01/2004 10:15 AM Jan Schneider jan

Happy new year everyone.

1.23 (+3 -3 lines) 11/11/2003 05:58 PM Chuck Hagenbuch chuck

Toss all of these into their own @packages until we figure out anything
better to do with them.

1.22 (+3 -3 lines) 11/06/2003 04:03 PM Chuck Hagenbuch chuck

get some test files, and rearrange a few things. What package some of these classes
fall under is entirely debatable; I just want to get everything into a structure that can be worked with.

1.21 (+8 -3 lines) 10/01/2003 05:48 PM Michael M Slusarz slusarz

For postgres, use 'ILIKE' instead of 'LIKE LOWER()', which was returning
nothing for me.  Now I actually get search results again!

1.20 (+3 -3 lines) 09/26/2003 10:42 PM Chuck Hagenbuch chuck

Alright, let's try this way.

1.19 (+3 -3 lines) 09/26/2003 09:44 PM Chuck Hagenbuch chuck

try and make sure LIKE is case insensitive. is one of these LOWER()
calls unnecessary?

1.18 (+10 -7 lines) 09/01/2003 09:33 PM Chuck Hagenbuch chuck

- add LIKE
- Small comment improvements

1.17 (+3 -3 lines) 07/16/2003 05:58 PM Marcus I. Ryan marcus

Fix error in regex
Submitted by: "Jason M. Felice" <jfelice@cronosys.com>

1.16 (+5 -4 lines) 07/16/2003 12:17 AM Marcus I. Ryan marcus

Make more backward compatible (only 7.3+ support SIMILAR TO, 7.2- use ~)

Submitted by: Jeff Seifert <seifert@everybody.org>

1.15 (+4 -4 lines) 06/19/2003 02:47 PM Chuck Hagenbuch chuck

LOG_* constants -> PEAR_LOG_*

1.14 (+37 -2 lines) 05/30/2003 10:25 AM Chuck Hagenbuch chuck

Add SQL::buildClause(), and use it to make getCategoriesByAttributes() more
portable. ("Jason M. Felice" <jfelice@cronosys.com>)

1.13 (+3 -4 lines) 05/28/2003 05:22 PM Chuck Hagenbuch chuck

Fix blob decoding for pgsql.

Submitted by: "Jason M. Felice" <jfelice@cronosys.com>

1.12 (+3 -3 lines) 01/03/2003 10:20 AM Jan Schneider jan

Add and fix @since tags.

1.10.2.3 RELENG_2 (+3 -3 lines) 01/03/2003 08:23 AM Jan Schneider jan

Fix @since tags.
Kill trailing whitespace.

Tags: HORDE_2_2_4_RC2, HORDE_2_2_4_RC1, HORDE_2_2_4, HORDE_2_2_3, HORDE_2_2_2, HORDE_2_2_1, HORDE_2_2_1_RC1, HORDE_2_2, HORDE_2_2_RC2, HORDE_2_2_RC1

1.10.2.2 RELENG_2 (+3 -3 lines) 01/03/2003 07:48 AM Jan Schneider jan

Bump year.

1.11 (+3 -3 lines) 01/02/2003 09:32 PM Jan Schneider jan

Bump year.

1.10.2.1 RELENG_2 (+2 -2 lines) 10/31/2002 05:38 PM Chuck Hagenbuch chuck

missed this when merging the VFS api.

1.10 (+6 -6 lines) 10/18/2002 03:34 PM Chuck Hagenbuch chuck

fix comment order

Tags: RELENG_2

1.9 (+17 -17 lines) 10/14/2002 04:38 PM Chuck Hagenbuch chuck

use the case used in the PHP docs.

1.8 (+53 -26 lines) 10/02/2002 12:04 AM Chuck Hagenbuch chuck

SQL.php and the VFS API should work with Oracle now.

1.7 (+21 -11 lines) 10/01/2002 03:45 PM Chuck Hagenbuch chuck

updateBlob() has half a chance of working on Oracle now.

1.6 (+5 -4 lines) 10/01/2002 01:21 PM mikec

Fix updateBlob() and readBlob()

1.5 (+4 -4 lines) 10/01/2002 01:10 PM Chuck Hagenbuch chuck

one more $field overwriting fix.

1.4 (+6 -6 lines) 10/01/2002 12:59 PM Chuck Hagenbuch chuck

remove quoting. not needed and was breaking things.

1.3 (+6 -6 lines) 10/01/2002 12:44 PM Chuck Hagenbuch chuck

fix overwriting of $field.

1.2 (+3 -3 lines) 10/01/2002 12:31 PM Chuck Hagenbuch chuck

fix syntax error

1.1 10/01/2002 12:16 PM Chuck Hagenbuch chuck

Try to move all of our specialized blob reading/writing code into one
place, so that we have a consistent list of supported databases and
one place to fix bugs/add new features/dbs.