| Age | Commit message (Collapse) | Author | Files | Lines |
|
Update comments in the code as well as the documentation to describe
ADODB_FETCH_* and ADODB_ASSOC_CASE_ constants.
Added description of each case and usage hints.
|
|
Add a warning message in the Readme file as well as the 5.19 changelog,
briefly describing the issue with fetching data in associative mode from
interbase, mssql, foxpro and possibly other DB engines, as well as those
derived from them.
Issue #20
|
|
|
|
They were previously defined in adodb-pear.inc.php, which doesn't make
much sense since they are only referenced within adodb.inc.php.
Fixes #49
|
|
|
|
Adds the mssql datatype datetime2 to the metatype mapping. Prevents
date time errors caused by the field being treated as a long.
Signed-off-by: Damien Regad <dregad@mantisbt.org>
|
|
This patch addresses these issues when given $prefix and $stripprefix
parameters.
- missing param for the schema when calling MetaTables()
- no table were returned if $stripprefix was true ($table name stripped,
then later a sql select on that table name live, lol).
- prefixes like 'mydbprefix_db1_' should not allow other tables starting
'mydbprefixXdb1_' or 'mydbprefix_db1X' to be matched as table for the
result.
Tested only with mysqli.
Fixes #92
Signed-off-by: Damien Regad <dregad@mantisbt.org>
|
|
Fixes #75
|
|
|
|
- ADOConnection::Connect
- ADOConnection::PConnect
Fixes #63
Signed-off-by: Damien Regad <dregad@mantisbt.org>
|
|
There are cases where ADODB is not be able to figure out the proper
count(*) queries for PageExecute() on its own.
To work around this problem, ADOdb now handles a new keyword
"_ADODB_COUNT" that can be wrapped around the parts of the SQL query
that should be replaced with "COUNT(*)"; the code will remove everything
between and including the _ADODB_COUNT keywords and replace it with
COUNT(*). The _ADODB_COUNT tags are of course removed when COUNT(*) is
not needed.
Example usage:
SELECT
_ADODB_COUNT
col1,
col2,
col3,
( select col4 from table2 where col1=col2 )
col4,
_ADODB_COUNT
FROM table1
LEFT JOIN ( select col5 from table3 where col3=col4 ) AS tmp;
Original 2012 bug report: http://phplens.com/lens/lensforum/msgs.php?id=19058
The fix has been in use since that time in hundreds of thousands of
production installations.
Fixes #88
Signed-off-by: Damien Regad <dregad@mantisbt.org>
|
|
|
|
mysqli_real_escape_string(), differs from mysql_real_escape_string().
The former requires a valid mysqli DB connection object, while the
latter has a fallback mechanism which attempts to generate a connection
when given NULL.
When calling ADOConnection::qstr() without an active connection
($_connectionID == false), mysqli_real_escape_string() throws a warning
and returns an empty string.
Now, we fallback to pre-PHP 5 mechanism to quote the string when not
connected.
Fixes #79
|
|
|
|
The methods "AddColumnSQL" and "AlterColumnSQL" did not quote the table
name propery, resulting in broken ALTER TABLE statements.
Fixes #67
Signed-off-by: Damien Regad <dregad@mantisbt.org>
|
|
Signed-off-by: Damien Regad <dregad@mantisbt.org>
|
|
|
|
The following commit was originally submited at https://bugs.debian.org/471265 back in 2008.
Some URLs have changed again since, but this is better anyways.
|
|
Thanks to diogotoscano
|
|
|
|
Thanks to @diogotoscano
|
|
Fixes #56
Signed-off-by: Damien Regad <dregad@mantisbt.org>
|
|
|
|
|
|
Fixes #31
Changes to original commit: whitespace and updated changelog.
Signed-off-by: Damien Regad <dregad@mantisbt.org>
|
|
The instructions given are not working with register_globals=OFF, which
is the default with PHP 5.3 (and the directive has been removed in 5.4).
Fixes #30
|
|
|
|
Some methods' signature did not match the parent class
|
|
When calling MetaColumns with schema.table, the driver triggers a
'Warning: sprintf(): Too few arguments' because the metaColumnsSQL1
statement contains one more parameter in 7 compared to the 6.4 version.
Resolved by adding a new protected _generateMetaColumnsSQL() method to
handle the preparation of the appropriate SQL statement, and overriding
it in the postgres7 driver.
http://phplens.com/lens/lensforum/msgs.php?id=19481
|
|
There was a small mistake in the version matching regex introduced in
commit 30c21280a48680c079f825af6583793928d65cf5, causing the function to
trigger a system notice and only return 'V' instead of the actual
version number.
Fixes #16
|
|
Fixes #12
|
|
|
|
PHPUnit 4.x+ used in conjunction with ADOdb memcache library causes a
'cannot redeclare _rs2serialize' error when including adodb-csv.inc.php.
http://phplens.com/lens/lensforum/msgs.php?id=19489
|
|
|
|
|
|
|
|
|
|
|
|
Added 'm' (multiline) flag to preg_match()
|
|
|
|
|
|
Reworded mention of obsolete docs
|
|
- Fix some broken links
- Removing links to phplens.com for documentation where applicable,
use local files instead
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|