Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 2134F6359D9; Thu, 5 Mar 2009 14:29:51 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 29119-01-6; Thu, 5 Mar 2009 14:29:48 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from jupiter.marktest.pt (delta.marktest.pt [80.251.174.116]) by mail.postgresql.org (Postfix) with ESMTP id 176A06364A0; Thu, 5 Mar 2009 14:25:45 -0400 (AST) Received: from suite (suite.marktest.pt [10.61.90.236]) by jupiter.marktest.pt with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id F4V561DM; Thu, 5 Mar 2009 18:25:40 -0000 Message-ID: <002e01c99dbf$c8b96f40$ec5a3d0a@marktestcr.marktest.pt> From: "Oliveiros Cristina" To: "Jhonny Velasquez c." , , References: Subject: Re: uso de dblink en php Date: Thu, 5 Mar 2009 18:25:38 -0000 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_002B_01C99DBF.C8A1A180" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.002 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001, NORMAL_HTTP_TO_IP=0.001 X-Spam-Level: X-Archive-Number: 200903/6 X-Sequence-Number: 32249 This is a multi-part message in MIME format. ------=_NextPart_000_002B_01C99DBF.C8A1A180 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Escribe tu duda en ingles, por favor Saludos, Oliveiros ----- Original Message -----=20 From: Jhonny Velasquez c.=20 To: pgsql-sql@postgresql.org ; pgsql-php@postgresql.org=20 Sent: Thursday, March 05, 2009 3:50 PM Subject: [SQL] uso de dblink en php hola a todos =20 estoy programando en php tengo el siguiente esquema de BD =20 BDACADEMICA personas(idpersona, nombres, paterno) BDSIAP PersonasDatosActualizables(idpersona, direccion, telefono)=20 =20 son dos bases de datos, de las cuales mediante una sola consulta = quiero unir los datos de la misma persona, creo que se puede hacer con = dblink, no se si hay otra forma mejor.=20 =20 $result=3Dpg_query( $linkacademica,"SELECT personas.nombres, = personas.paterno, s.direccion, s.telefono, FROM personas INNER JOIN = dblink('dbname=3Dbdsiap port=3D5432 host=3Dlocalhost user=3Dusuario = password=3Dclave,'SELECT idpersona, direccion, telefono FROM = personasdatosactualizables') AS s(idpersona character(15), direccion = character varying(50), telefono character varying(25)) ON = personas.idpersona =3D s.idpersona"); =20 usando db link me da el siguiente error, supongo que es por las = comillas, he intentado con comillas dobles y simples pero nada, tambien = he intentado usar variables. Warning: pg_query() [function.pg-query]: Query failed: ERROR: error de = sintaxis en o cerca de =ABFROM=BB at character 69 in = /var/www/finanzas/prueba.php on line 16 =20 =20 espero su ayuda =20 saludos =20 jhonvels -------------------------------------------------------------------------= ----- check out the rest of the Windows Live=99. More than mail=96Windows = Live=99 goes way beyond your inbox. More than messages ------=_NextPart_000_002B_01C99DBF.C8A1A180 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable
Escribe tu duda en ingles, por = favor
 
Saludos,
Oliveiros
----- Original Message -----
From:=20 Jhonny=20 Velasquez c.
To: pgsql-sql@postgresql.org = ; pgsql-php@postgresql.org =
Sent: Thursday, March 05, 2009 = 3:50=20 PM
Subject: [SQL] uso de dblink en = php

hola a todos
 
estoy programando en = php
tengo el=20 siguiente esquema de = BD
 
BDACADEMICA
 personas(idpersona,=20 nombres, = paterno)

BDSIAP
 PersonasDatosActualizables(idpersona,=20 direccion, telefono)

 
son dos bases de datos, de las = cuales=20 mediante una sola consulta quiero unir los datos de la misma persona, = creo que=20 se puede hacer con dblink, no se si hay otra forma mejor.=20
 
   $result=3Dpg_query( $linkacademica,"SELECT=20 personas.nombres, personas.paterno, s.direccion, s.telefono, FROM = personas=20 INNER JOIN dblink('dbname=3Dbdsiap port=3D5432 host=3Dlocalhost = user=3Dusuario=20 password=3Dclave,'SELECT idpersona, direccion, telefono FROM=20 personasdatosactualizables') AS s(idpersona character(15),=20 direccion character varying(50), telefono character varying(25)) = ON=20 personas.idpersona =3D s.idpersona");

 
usando db link = me da el=20 siguiente error, supongo que es por las comillas, he intentado con = comillas=20 dobles y simples pero nada, tambien he intentado usar=20 variables.

Warning: pg_query() [function.pg-query<= /A>]:=20 Query failed: ERROR: error de sintaxis en o cerca de =ABFROM=BB at = character 69 in=20 /var/www/finanzas/prueba.php on line=20 = 16
 
 
espero= su=20 ayuda
 
saludos
 
jhonvels


check out the rest of the Windows Live=99. More than mail=96Windows = Live=99 goes way=20 beyond your inbox. More than messages ------=_NextPart_000_002B_01C99DBF.C8A1A180--