ADODB General Discussion

Jon Coulter | 5 Mar 2007 22:10

_adodb_column_sql and integers?

I'm using the postgresql driver, and whenever I pass a value to AutoExecute(...), the adodb driver gets really lazy at the _adodb_column_sql() step (which is what I want to do :))

Basically, if I have a field defined as an integer in the database, but I let '10a' pass into the system, I would rather adodb quote the data before sending it to the server (set intfield = '10a') and let the database throw an error, then postgres assuming I have done the correct casting and passing it as (set intfield = 10a), which is what it does.

This would leave a lot of room for SQL injection bugs. One of the main reasons I want to use an abstraction library like adodb is so I don't have to be hugely tedious with casting data types and things like that. Granted, I'm being lazy in this case, but the fact remains that this is a big problem for people whom just didn't "test" their code well enough and relied on adodb to properly quote things, regardless of what the meta information about the table says the data type is.

I've also never seen a database throw an error if a column is defined as an int, and an int is passed to it in quote ('123') -- so I don't see any problem with just forcing a quoting policy across all non-special-case data types (BLOB is a special case) and letting the rest of us concentrate on business logic instead of data type casting in a loosely-typed language like PHP.

Anybody else have thoughts on this, or similar experiences?

Thanks,

--
Jon Coulter
ledjon <at> ledjon.com

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

_______________________________________________
ADodb-general mailing list
ADodb-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/adodb-general

headers

Raghvendra Chourasia | 6 Mar 2007 08:06

ADODB readonly mode is not working (PHP and Oracle)

Hi,
I am connecting PHP 5 with Oracle 10g Express Edition using ADODB, Operating system is Windows XP Professional. I want to access data in read only mode. When I did changes $readOnly = true; in adodb.inc.php even though I am able to run insert,update, delete query. Why Read Only mode is not working when I connect PHP with Oracle. Any solution plz.
Thanks,
Ajit

Hi,

Raghvendra S Chourasia

flat no.201 , Umang Apts,

Nari Ring Road, Angulimaal Nagar,

Nagpur -26

Cell no. -9850302388

Here’s a new way to find what you're looking for - Yahoo! Answers

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

_______________________________________________
ADodb-general mailing list
ADodb-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/adodb-general

headers

Raghvendra Chourasia | 6 Mar 2007 08:15

ADODB readonly mode is not working (PHP and Oracle)

Hi,
I am connecting PHP 5 with Oracle 10g Express Edition using ADODB, Operating system is Windows XP Professional. I want to access data in read only mode. When I did changes $readOnly = true; in adodb.inc.php even though I am able to run insert,update, delete query. Why Read Only mode is not working when I connect PHP with Oracle. I saw php function like oci_connect() but I could not get any option like readonly.
Any solution plz.
Thanks,
Ajit

Here’s a new way to find what you're looking for - Yahoo! Answers

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

_______________________________________________
ADodb-general mailing list
ADodb-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/adodb-general

headers

Erik Wickstrom | 8 Mar 2007 23:30

Redirect Debug Output?

Hi,

I need to customize the debug output of ADOdb. Is there a function that can be overloaded, or maybe some other "hook" that cane be used?

Basically I need to put the debeg output into an array instead of printing it tho screen...

Thanks for your help!

Erik

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

_______________________________________________
ADodb-general mailing list
ADodb-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/adodb-general

headers

Chris Edwards | 9 Mar 2007 01:53

Re: Redirect Debug Output?

Erik Wickstrom wrote:
> Hi,
> 
> I need to customize the debug output of ADOdb.  Is there a function that 
> can be overloaded, or maybe some other "hook" that cane be used?
> 
> Basically I need to put the debeg output into an array instead of 
> printing it tho screen...
> 
> Thanks for your help!
> 
> Erik
> 
> 
> ------------------------------------------------------------------------
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> ADodb-general mailing list
> ADodb-general <at> lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/adodb-general

wrap the call with an output buffer.  ob_start()

look it up on php.net

--

-- 
Chris Edwards
Software Engineer, Nullsoft Winamp
AOL
http://www.winamp.com
edwardschris05 <at> aol.com / 703-265-1840

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

headers

Bartłomiej Pióro | 9 Mar 2007 09:07

Re: Redirect Debug Output?

Hello

This is what i am using (this works without touching ADODB at all).

define('ADODB_OUTP',"nameOfTheFunction");
function outputDebug($text,$newline)
{
	// Do here what you want to do
}

Hope this helps
Regards
Bart

Erik Wickstrom napisał(a):
> Hi,
> 
> I need to customize the debug output of ADOdb.  Is there a function that 
> can be overloaded, or maybe some other "hook" that cane be used?
> 
> Basically I need to put the debeg output into an array instead of 
> printing it tho screen...
> 
> Thanks for your help!
> 
> Erik
> 
> 
> ------------------------------------------------------------------------
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> 
> __________ NOD32 Informacje 2104 (20070308) __________
> 
> Wiadomosc zostala sprawdzona przez System Antywirusowy NOD32
> http://www.nod32.com lub http://www.nod32.pl 
> 
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> ADodb-general mailing list
> ADodb-general <at> lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/adodb-general
> 
> 
> __________ NOD32 Informacje 2104 (20070308) __________
> 
> Wiadomosc zostala sprawdzona przez System Antywirusowy NOD32
> http://www.nod32.com lub http://www.nod32.pl 
> 

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
ADodb-general mailing list
ADodb-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/adodb-general

headers

Bartłomiej Pióro | 13 Mar 2007 15:27

AdoDB Fatal Error under PHP 5.2 -> Solution

Hello,

If you are using PHP 5.2 you can sometime see the error :
Nesting Level to deep .....

This is because 5.2 differntly behave in some situations (see 
http://www.bigroom.co.uk/blog/php-nesting-level-too-deep-recursive-dependency/ 
for more info).

To correct this error you have to go to adodb-active-record.inc.php
and modify line no 45:

Before :
if ($d->db == $db) return $k;

After :
if ($d->db === $db) return $k;

I need confirmation from adodb author about this, but this solution 
seemed to work for my case.

Hope this helps if someone encounter error like mine.

Regards
Bart

PS: This works correctly under windows Apache Friends basic installation 
with 5.2
B

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

headers

Paolo Morandi | 15 Mar 2007 10:56

AutoExecute UPDATE problem with oci8

I have a problem with AutoExecute in oci8 interface.
My call are:
AutoExecute('utenti', array of fields to update, 'UPDATE',
"cod_utente='prova'")
This call fail.
If i look the sql generated i find:
UPDATE utenti SET ........ WHERE cod_utente='prova') where rownum <=
:adodb_offset

In adodb-lib.inc.php function _adodb_getupdatesql after the line 465:
        preg_match('/\sWHERE\s(.*)/is', $rs->sql, $whereClause);
The element 1 of  $whereClause field are: cod_utente='prova') where
rownum <= :adodb_offset

Can help me?

An other help: i must make portable this MySql SQL statement:

    select data_scadenza, successivo from pagine where ((data_scadenza
    between date_sub('2007-03-14', INTERVAL '25' day) and
    date_add('2007-03-14', INTERVAL '26' day)) or (data_scadenza <
    date_sub('2007-03-14', INTERVAL '25' day) and
    date_add(data_scadenza, INTERVAL successivo day) >=
    date_sub('2007-03-14', INTERVAL '25' day))) and tipo_pagina='C' and
    lingua='IT'

I have maked two Database Function in Oracle for simulate date_sub and
date_add , but my problem are the execution of the interval on the table
field 'successivo' (an integer). The function are:
DATE_ADD:

    CREATE OR REPLACE function date_add(data1 in STRING, intervallo IN
    INTERVAL DAY TO SECOND )
    return date IS
    data2 DATE;
    BEGIN
    select to_date(data1, 'yyyy-mm-dd') + intervallo into data2 from dual ;
    return(data2);
    END;
    /

DATE_SUB:

    CREATE OR REPLACE function date_sub(data1 in STRING, intervallo IN
    INTERVAL DAY TO SECOND )
    return date IS
    data2 DATE;
    BEGIN
    select to_date(data1, 'yyyy-mm-dd') - intervallo into data2 from dual ;
    return(data2);
    END;
    /

Any suggestion?

Thank

Paolo Morandi

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

headers

chamath gunasekara | 23 Mar 2007 05:42

Hello ....

Hi ....

I'm chamath from sri lanka. I'm a student of university of colombo school of computing. I'm 3rd year undergraduate.

regards,

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

_______________________________________________
ADodb-general mailing list
ADodb-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/adodb-general

2	May 2013
1	April 2013
3	March 2013
1	February 2013
4	January 2013
3	December 2012
2	November 2012
4	October 2012
6	September 2012
2	August 2012
2	July 2012
3	June 2012
4	May 2012
1	April 2012
4	March 2012
1	February 2012
2	January 2012
2	December 2011
3	November 2011
3	October 2011
3	September 2011
3	August 2011
3	July 2011
7	June 2011
4	May 2011
4	April 2011
6	March 2011
2	February 2011
2	January 2011
4	December 2010
2	November 2010
3	October 2010
3	September 2010
3	August 2010
3	July 2010
5	June 2010
2	May 2010
3	April 2010
9	March 2010
4	February 2010
6	January 2010
16	December 2009
2	November 2009
2	October 2009
5	September 2009
15	August 2009
36	July 2009
19	June 2009
35	May 2009
19	April 2009
13	March 2009
13	February 2009
6	January 2009
36	December 2008
21	November 2008
15	October 2008
16	September 2008
1	August 2008
1	July 2008
4	June 2008
8	May 2008
13	April 2008
5	March 2008
6	February 2008
9	January 2008
4	December 2007
7	November 2007
2	October 2007
4	September 2007
5	August 2007
9	July 2007
2	June 2007
1	May 2007
7	April 2007
9	March 2007
7	February 2007
3	January 2007
6	December 2006
2	November 2006
10	October 2006
6	September 2006
9	August 2006
3	July 2006
10	June 2006
6	May 2006
7	April 2006
9	March 2006
8	February 2006
6	January 2006
2	December 2005
10	November 2005
17	October 2005
9	September 2005
4	August 2005
6	July 2005
19	June 2005
7	May 2005
1	April 2005

Mon	Tue	Wed	Thu	Fri	Sat	Sun

			1	2	3	4
5	6	7	8	9	10	11
12	13	14	15	16	17	18
19	20	21	22	23	24	25
26	27	28	29	30	31