ADODB General Discussion

vinicius | 6 Jan 2006 18:08

problem- migrate adodb3.4+postgresql 7.2.1 to adodb3.4+postgresql 7.4.8

im having problems to migrate a system that use adodb 3.4 and postgresql 7.2.1 
to postgresql 7.4.8, and i don't search the correct documentation. 

I want to know if adodb3.4 suport postgre7.4.8? 

--

-- 
Vinicius Dittgen
CDP - FCDL-RS
www.spcrs.com.br

"A mente que se abre a uma nova idéia
jamais volta ao seu tamanho original."
(Albert Einstein)

**Paz, Amor e Software Livre**


-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_idv37&alloc_id865&op=click

headers

Jack Lewis | 12 Jan 2006 02:48

Equivalent of MySQL's now() in GetUpdateSQL()?

How do you pass the equivalent of MySQL's now() for date-time columns to GetUpdateSQL()? For example, here is the old MySQL-specific SQL:

UPDATE foo SET bar='blah', dt_modified=now() WHERE id=1

Now I want to migrate to ADOdb's GetUpdateSQL(), so I try this:

$rs = $db->Execute("SELECT * FROM foo WHERE id = 1");
$foo_record['dt_modified'] = $db->DBTimeStamp(time());
$foo_record['bar'] = 'blah';
$sql = $db->GetUpdateSQL($rs, $foo_record);

Unfortunately, the generated SQL is invalid.
I think it's because the date-time is quoted. I miss now(), so what is the correct, clean way?

Jack

headers

Rob van Kraanen | 17 Jan 2006 10:59

Multiple Database objects

Hi,

I'm new to this list ans relative new to adodb.
I'm trying to create 2 database objects at the same time, and acces them.
The first object is set in the index:
$conn = ADONewConnection('mysql');
$conn->PConnect(xx,xx,xx,xx);
$conn->debug = false;
$conn->SetFetchMode(ADODB_FETCH_ASSOC);

the second object i make in a class, this is the code

$conn_dns_1 = ADONewConnection('mysql');
$conn_dns_1->PConnect(xx,xx,xx,xx);
$conn_dns_1->debug = true;
$conn_dns_1->SetFetchMode(ADODB_FETCH_ASSOC);

But when i initialize this object the first one is no longer usable.
I think it is an error with the &-option of adodb.

can anyone help me?

regards Rob

--

-- 
--
Lingewoud B.V.    |   Tel. +31 418 663963
Maasdijk 4        |   Fax. +31 418 663053
5328 BG Rossum    |     info <at> lingewoud.nl
The Netherlands   |      www.lingewoud.nl

headers

Alejandro Michelin Salomon ( Adinet | 18 Jan 2006 12:01

RE: Multiple Database objects (Rob van Kraanen)

Hi Rob:

Try to change this :

$conn->PConnect(xx,xx,xx,xx); ---> $conn->Connect(xx,xx,xx,xx); 

$conn_dns_1->PConnect(xx,xx,xx,xx); ---> $conn_dns_1->Connect(xx,xx,xx,xx);

Alejandro Michelin Salomon
Porto Alegre
Brasil

Rob van Kraanen wrote :

<Hi,

<I'm new to this list ans relative new to adodb.
<I'm trying to create 2 database objects at the same time, and acces them.
The first object is set in the index: $conn =3D <ADONewConnection('mysql');
$conn->PConnect(xx,xx,xx,xx); $conn->debug =3D false;
$conn->SetFetchMode(ADODB_FETCH_ASSOC);

<the second object i make in a class, this is the code

<$conn_dns_1 =3D ADONewConnection('mysql');
$conn_dns_1->PConnect(xx,xx,xx,xx);
<$conn_dns_1->debug =3D true; $conn_dns_1->SetFetchMode(ADODB_FETCH_ASSOC);

<But when i initialize this object the first one is no longer usable. I
think it is an error with the &-option of adodb.

<can anyone help me?

<regards Rob

<=2D-=20
<=2D-
<Lingewoud B.V.    |   Tel. +31 418 663963
<Maasdijk 4        |   Fax. +31 418 663053
<5328 BG Rossum    |     info <at> lingewoud.nl
<The Netherlands   |      www.lingewoud.nl

--

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.14.20/233 - Release Date: 18/1/2006

-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642

headers

Alfredo Yong | 18 Jan 2006 15:46

Re: Problems using GetOne in complex queries

Hi,

About the GetOne method of the ADOconnection object:

seems to work fine when there is a simple query, something like:

"select u_name from users when u_code=34"

But I have problems when trying to get things like:

"SELECT count(t.nt_titular)
         FROM noticias n
          LEFT JOIN noticias_temas t ON n.not_codigo = t.not_codigo
          LEFT JOIN noticias_fuentes f ON t.nt_codigo = f.nt_codigo
      WHERE n.not_codigo = 23 and char_length(trim(both from t.nt_titular)) > 0"

This query works fine when executing with the Execute method.

greetings,

--
Alfredo Yong
Sistemas web

headers

Rob van Kraanen | 19 Jan 2006 08:12

Re: RE: Multiple Database objects (Rob van Kraanen)

Thanks, it works!!!

But why can't i make multiple persistent connections?
Is there a specific reason for that, or just because?

regards Rob
On Wednesday 18 January 2006 12:01, Alejandro Michelin Salomon ( Adinet ) 
wrote:
> Hi Rob:
>
> Try to change this :
>
> $conn->PConnect(xx,xx,xx,xx); ---> $conn->Connect(xx,xx,xx,xx);
>
> $conn_dns_1->PConnect(xx,xx,xx,xx); ---> $conn_dns_1->Connect(xx,xx,xx,xx);
>
> Alejandro Michelin Salomon
> Porto Alegre
> Brasil
>
> Rob van Kraanen wrote :
>
> <Hi,
>
> <I'm new to this list ans relative new to adodb.
> <I'm trying to create 2 database objects at the same time, and acces them.
> The first object is set in the index: $conn =3D <ADONewConnection('mysql');
> $conn->PConnect(xx,xx,xx,xx); $conn->debug =3D false;
> $conn->SetFetchMode(ADODB_FETCH_ASSOC);
>
> <the second object i make in a class, this is the code
>
> <$conn_dns_1 =3D ADONewConnection('mysql');
> $conn_dns_1->PConnect(xx,xx,xx,xx);
> <$conn_dns_1->debug =3D true; $conn_dns_1->SetFetchMode(ADODB_FETCH_ASSOC);
>
>
> <But when i initialize this object the first one is no longer usable. I
> think it is an error with the &-option of adodb.
>
> <can anyone help me?
>
> <regards Rob
>
> <=2D-=20
> <=2D-
> <Lingewoud B.V.    |   Tel. +31 418 663963
> <Maasdijk 4        |   Fax. +31 418 663053
> <5328 BG Rossum    |     info <at> lingewoud.nl
> <The Netherlands   |      www.lingewoud.nl

--

-- 
--
Lingewoud B.V.    |   Tel. +31 418 663963
Maasdijk 4        |   Fax. +31 418 663053
5328 BG Rossum    |     info <at> lingewoud.nl
The Netherlands   |      www.lingewoud.nl

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