Menu
▾
▴
rlib-users
|
From: Bob D. <bd...@si...> - 2004-12-07 13:52:31
|
So the PHP standalone ODBC test works?
Also, when you ./configure rlib there is a screen at the end saying how
RLIB is configured. Can you send that to me
Also what distro are you using?
On Mon, 2004-12-06 at 19:32 -0300, Cl=C3=A1udio Fortier wrote:
> Hi Bob, thanks for your response.
>=20
> I really need access ORACLE, but rlib have no native access for it. Bec=
ause this, i'm trying use unixODBC.
>=20
> unix ODBC works fine with the folow script:
> <html>
> <body>
>=20
> <?php
> $conn=3Dodbc_connect('oracle','u_test','u_test');=20
> if (!$conn)
> {
> exit("Connection Failed: " . $conn);=20
> }=20
> $sql=3D"SELECT * FROM TEN_PAC_PACIENTE";=20
> $rs=3Dodbc_exec($conn,$sql);=20
> if (!$rs)
> {=20
> exit("Error in SQL");
> }=20
> echo "<table><tr>";
> echo "<th>C=C3=B3digo</th>";
> echo "<th>Nome</th></tr>";
> while (odbc_fetch_row($rs))
> {
> $CODIGO=3Dodbc_result($rs,"PAC_PK_INT_CODIGO");
> $NOME=3Dodbc_result($rs,"PAC_CHR_NOME");
> echo "<tr><td>$CODIGO</td>";
> echo "<td>$NOME</td></tr>";
> }
> odbc_close($conn);
> echo "</table>";
> ?>
>=20
> </body>
> </html>
>=20
> ------------------- reply ---------------
> > From: bd...@si...
> > To: for...@ya...
> > Cc: rli...@li...
> > Subject: Re: [Rlib-users] ODBC text
> > Date: 2004-12-06 14:41:30
> > ----------------------------------
> > I haven't used it since I wrote it
> >=20
> > does any other app work w/ the unixodbc??
> >=20
> > - bob
> >=20
> > On Mon, 2004-12-06 at 08:41 -0300, Claudio Fortier wrote:
> > > Hi, i'm trying use rlib with unixodbc and PHP in linux
> > > rh8. Someone has used rlib with unixodbc? I need
> > > examples.=20
> > >=20
> > > My tests every returns the message "The connection was
> > > refused when attenpting to contact www.localhost.com"
> > >=20
> > > Please, help me.=20
> > >=20
> > >=20
> > > =09
> > > =09
> > > =09
> > > _______________________________________________________=20
> > > Yahoo! Mail - Agora com 250MB de espa=C3=83=C2=A7o gratuito. Abra=20
> > > uma conta agora! http://br.info.mail.yahoo.com/
> > >=20
> > >=20
> > > -------------------------------------------------------
> > > SF email is sponsored by - The IT Product Guide
> > > Read honest & candid reviews on hundreds of IT Products from real u=
sers.
> > > Discover which products truly live up to the hype. Start reading no=
w.=20
> > > http://productguide.itmanagersjournal.com/
> > > _______________________________________________
> > > Rlib-users mailing list
> > > Rli...@li...
> > > https://lists.sourceforge.net/lists/listinfo/rlib-users
> >=20
> >=20
> >=20
> > -------------------------------------------------------
> > SF email is sponsored by - The IT Product Guide
> > Read honest & candid reviews on hundreds of IT Products from real use=
rs.
> > Discover which products truly live up to the hype. Start reading now.
> > http://productguide.itmanagersjournal.com/
> > _______________________________________________
> > Rlib-users mailing list
> > Rli...@li...
> > https://lists.sourceforge.net/lists/listinfo/rlib-users
> >=20
>=20
|
|
From: Bob D. <bd...@si...> - 2004-12-07 21:15:29
|
Can I see the php file you created for RLIB causes the error?
- bob
On Tue, 2004-12-07 at 17:52 -0300, Cl=C3=A1udio Fortier wrote:
> Hi, Bob.
>=20
> I'm using Linux RedHat 8.
>=20
> Yes the PHP standalone ODBC test works.
>=20
> The PHP RLIB example array.php works too.
>=20
> There is the RLIB configuration:
>=20
>=20
> rlib-1.3.0:
>=20
> prefix: /usr/local
> compiler: gcc
> Memory debugging: no
> Warning Fun: no
> Crash detection: yes
> UTF8 disabled: no
>=20
> INPUTS:
> MYSQL: yes
> POSTGRE: yes
> ODBC: yes
>=20
> OUTPUTS:
> PDF: yes
> HTML: Always
> CSV: Always
> TEXT: Always
>=20
> BINDINGS:
> PHP: yes
> PHP entension dir: /usr/local/lib/php/extensions/no-debu=
g-non-zts
> -20020429
> PYTHON: no
> PYTHON version: 2.2
> PYTHON entension dir:
> JAVA: no
> PERL: no
> PERL entension dir:
>=20
> Music: Velvet Revolver
>=20
> Having Problems: rli...@li...
> Want to contribute: rli...@li...
>=20
>=20
>=20
> ------------------- reply ---------------
> > From: bd...@si...
> > To: cfo...@ib...
> > Cc: rli...@li...
> > Subject: Re: [Rlib-users] ODBC text
> > Date: 2004-12-07 10:52:16
> > ----------------------------------
> >=20
> > So the PHP standalone ODBC test works?
> >=20
> > Also, when you ./configure rlib there is a screen at the end saying h=
ow
> > RLIB is configured. Can you send that to me
> >=20
> > Also what distro are you using?
> >=20
> > On Mon, 2004-12-06 at 19:32 -0300, Cl=C3=83=C2=A1udio Fortier wrote:
> > > Hi Bob, thanks for your response.
> > >=20
> > > I really need access ORACLE, but rlib have no native access for it.=
Because this, i'm trying use unixODBC.
> > >=20
> > > unix ODBC works fine with the folow script:
> > > <html>
> > > <body>
> > >=20
> > > <?php
> > > $conn=3Dodbc_connect('oracle','u_test','u_test');=20
> > > if (!$conn)
> > > {
> > > exit("Connection Failed: " . $conn);=20
> > > }=20
> > > $sql=3D"SELECT * FROM TEN_PAC_PACIENTE";=20
> > > $rs=3Dodbc_exec($conn,$sql);=20
> > > if (!$rs)
> > > {=20
> > > exit("Error in SQL");
> > > }=20
> > > echo "<table><tr>";
> > > echo "<th>C=C3=83=C2=B3digo</th>";
> > > echo "<th>Nome</th></tr>";
> > > while (odbc_fetch_row($rs))
> > > {
> > > $CODIGO=3Dodbc_result($rs,"PAC_PK_INT_CODIGO");
> > > $NOME=3Dodbc_result($rs,"PAC_CHR_NOME");
> > > echo "<tr><td>$CODIGO</td>";
> > > echo "<td>$NOME</td></tr>";
> > > }
> > > odbc_close($conn);
> > > echo "</table>";
> > > ?>
> > >=20
> > > </body>
> > > </html>
> > >=20
> > > ------------------- reply ---------------
> > > > From: bd...@si...
> > > > To: for...@ya...
> > > > Cc: rli...@li...
> > > > Subject: Re: [Rlib-users] ODBC text
> > > > Date: 2004-12-06 14:41:30
> > > > ----------------------------------
> > > > I haven't used it since I wrote it
> > > >=20
> > > > does any other app work w/ the unixodbc??
> > > >=20
> > > > - bob
> > > >=20
> > > > On Mon, 2004-12-06 at 08:41 -0300, Claudio Fortier wrote:
> > > > > Hi, i'm trying use rlib with unixodbc and PHP in linux
> > > > > rh8. Someone has used rlib with unixodbc? I need
> > > > > examples.=20
> > > > >=20
> > > > > My tests every returns the message "The connection was
> > > > > refused when attenpting to contact www.localhost.com"
> > > > >=20
> > > > > Please, help me.=20
> > > > >=20
> > > > >=20
> > > > > =09
> > > > > =09
> > > > > =09
> > > > > _______________________________________________________=20
> > > > > Yahoo! Mail - Agora com 250MB de espa=C3=83=C6=92=C3=82=C2=A7o =
gratuito. Abra=20
> > > > > uma conta agora! http://br.info.mail.yahoo.com/
> > > > >=20
> > > > >=20
> > > > > -------------------------------------------------------
> > > > > SF email is sponsored by - The IT Product Guide
> > > > > Read honest & candid reviews on hundreds of IT Products from re=
al users.
> > > > > Discover which products truly live up to the hype. Start readin=
g now.=20
> > > > > http://productguide.itmanagersjournal.com/
> > > > > _______________________________________________
> > > > > Rlib-users mailing list
> > > > > Rli...@li...
> > > > > https://lists.sourceforge.net/lists/listinfo/rlib-users
> > > >=20
> > > >=20
> > > >=20
> > > > -------------------------------------------------------
> > > > SF email is sponsored by - The IT Product Guide
> > > > Read honest & candid reviews on hundreds of IT Products from real=
users.
> > > > Discover which products truly live up to the hype. Start reading =
now.
> > > > http://productguide.itmanagersjournal.com/
> > > > _______________________________________________
> > > > Rlib-users mailing list
> > > > Rli...@li...
> > > > https://lists.sourceforge.net/lists/listinfo/rlib-users
> > > >=20
> > >=20
> >=20
> >=20
> >=20
> > -------------------------------------------------------
> > SF email is sponsored by - The IT Product Guide
> > Read honest & candid reviews on hundreds of IT Products from real use=
rs.
> > Discover which products truly live up to the hype. Start reading now.
> > http://productguide.itmanagersjournal.com/
> > _______________________________________________
> > Rlib-users mailing list
> > Rli...@li...
> > https://lists.sourceforge.net/lists/listinfo/rlib-users
> >=20
>=20
|
|
From: Bob D. <bd...@si...> - 2004-12-08 13:58:07
|
Can you run it from the command line so I can see the exact error
messages?
- bob
On Wed, 2004-12-08 at 06:52 -0300, Cl=C3=A1udio Fortier wrote:
> Of course. There are the scrip and xml files:
>=20
> array_oracle.php
> <? dl ("librlib.so");
> $rlib =3D rlib_init();
> rlib_add_datasource_odbc($rlib, "odbcsusfacil", "u_susfacil", "u_susfa=
cil");
> rlib_add_query_as($rlib, "odbcsusfacil", "select * from ten_pac_pacien=
te", "ten_pac_paciente");
> rlib_add_report($rlib, "array_oracle.xml", "ten_pac_paciente");
> rlib_set_output_format_from_text($rlib, "pdf");
> rlib_execute($rlib);
> header(rlib_get_content_type($rlib));
> rlib_spool($rlib);
> rlib_free($rlib);
> ?>
>=20
> array_oracle.xml
> <?xml version=3D"1.0"?>
> <!DOCTYPE report >
> <Report fontSize=3D"9" orientation=3D"landscape">
> <Alternate>
> <NoData>
> <Output>
> <Line fontSize=3D"12">
> <literal>NO DATA</literal>
> </Line> =09
> </Output>
> </NoData>
> </Alternate>
> <ReportHeader>
> <Output>
> <Line fontSize=3D"11">
> <literal>Test Report (Normal) AND THE REPORT FORMAT IS: </literal>
> <field value=3D"r.format" width=3D"20"/>
> <field value=3D"eval('1+2')" width=3D"20"/>
> </Line>
> <Line fontSize=3D"11">
> <literal bold=3D"yes">Test Report (Bold)</literal>
> </Line>
> <Line fontSize=3D"11">
> <literal italics=3D"yes">Test Report (Italics)</literal>
> </Line>
> <Line fontSize=3D"11">
> <literal bold=3D"yes" italics=3D"yes">Test Report (Bold and Italics=
)</literal>
> </Line>
> <HorizontalLine size=3D"4" bgcolor=3D"'white'"/>
> </Output>
> </ReportHeader> =09
> <Breaks>=09
> <Break name=3D"break0" newpage=3D"no" headernewpage=3D"yes">
> <BreakHeader>
> <Output>
> <Line>
> <field value=3D"group" width=3D"20" align=3D"left" col=3D"1"/> =
=09
> </Line>
> </Output> =09
> </BreakHeader>
> <BreakFields>
> <BreakField value=3D"group"/>
> </BreakFields>
> <BreakFooter>
> <Output>
> <HorizontalLine size=3D"4" bgcolor=3D"'white'"/>
> <HorizontalLine size=3D"2" bgcolor=3D"'black'"/>
> <HorizontalLine size=3D"4" bgcolor=3D"'white'"/>
> <Line>
> <field value=3D"group" width=3D"20" align=3D"left" col=3D"1"/> =
=09
> </Line>
> <HorizontalLine size=3D"4" bgcolor=3D"'white'"/>
> <HorizontalLine size=3D"2" bgcolor=3D"'black'"/>
> <HorizontalLine size=3D"4" bgcolor=3D"'white'"/>
> </Output>
> </BreakFooter>
> </Break>
> </Breaks>
> <Detail>
> <FieldHeaders>
> <Output>
> <HorizontalLine size=3D"1" bgcolor=3D"'black'"/>
> <Line bgcolor=3D"'0xe5e5e5'">
> <literal width=3D"20" col=3D"1">First Name</literal>
> <literal width=3D"1"/>
> <literal width=3D"20" col=3D"2">Last Name</literal>
> <literal width=3D"1"/>
> <literal width=3D"20" col=3D"3">Color</literal>
> </Line>
> <HorizontalLine size=3D"1" bgcolor=3D"'black'"/>
> <HorizontalLine size=3D"4" bgcolor=3D"'white'"/>
> </Output>
> </FieldHeaders> =09
> <FieldDetails>
> <Output>
> <Line bgcolor=3D"iif(r.detailcnt%2,'0xe5e5e5','white')">
> <field value=3D"PAC_PK_INT_CODIGO" width=3D"20" align=3D"left" col=
=3D"1"/>
> <literal width=3D"1"/>
> <field value=3D"PAC_CHR_NOME" width=3D"20" align=3D"left" col=3D"2=
"/>
> <literal width=3D"1"/>
> <field value=3D"PAC_CHR_TELEFONE" width=3D"20" align=3D"left" col=3D=
"3"/>
> </Line>
> </Output>
> </FieldDetails>
> </Detail>
>=20
> <PageFooter>
> <Output>
> <Line>
> <literal>Page: </literal>=09
> <field value=3D"r.pageno" width=3D"3" align=3D"right"/>
> </Line>
> </Output>
> </PageFooter>
>=20
> <ReportFooter>
> </ReportFooter>
> </Report>
>=20
>=20
> ------------------- reply ---------------
> > From: bd...@si...
> > To: cfo...@ib...
> > Cc: rli...@li...
> > Subject: Re: [Rlib-users] ODBC text
> > Date: 2004-12-07 18:15:15
> > ----------------------------------
> > Can I see the php file you created for RLIB causes the error?
> >=20
> > - bob
> >=20
> > On Tue, 2004-12-07 at 17:52 -0300, Cl=C3=83=C2=A1udio Fortier wrote:
> > > Hi, Bob.
> > >=20
> > > I'm using Linux RedHat 8.
> > >=20
> > > Yes the PHP standalone ODBC test works.
> > >=20
> > > The PHP RLIB example array.php works too.
> > >=20
> > > There is the RLIB configuration:
> > >=20
> > >=20
> > > rlib-1.3.0:
> > >=20
> > > prefix: /usr/local
> > > compiler: gcc
> > > Memory debugging: no
> > > Warning Fun: no
> > > Crash detection: yes
> > > UTF8 disabled: no
> > >=20
> > > INPUTS:
> > > MYSQL: yes
> > > POSTGRE: yes
> > > ODBC: yes
> > >=20
> > > OUTPUTS:
> > > PDF: yes
> > > HTML: Always
> > > CSV: Always
> > > TEXT: Always
> > >=20
> > > BINDINGS:
> > > PHP: yes
> > > PHP entension dir: /usr/local/lib/php/extensions/no-=
debug-non-zts
> > > -20020429
> > > PYTHON: no
> > > PYTHON version: 2.2
> > > PYTHON entension dir:
> > > JAVA: no
> > > PERL: no
> > > PERL entension dir:
> > >=20
> > > Music: Velvet Revolver
> > >=20
> > > Having Problems: rli...@li...
> > > Want to contribute: rli...@li...
> > >=20
> > >=20
> > >=20
> > > ------------------- reply ---------------
> > > > From: bd...@si...
> > > > To: cfo...@ib...
> > > > Cc: rli...@li...
> > > > Subject: Re: [Rlib-users] ODBC text
> > > > Date: 2004-12-07 10:52:16
> > > > ----------------------------------
> > > >=20
> > > > So the PHP standalone ODBC test works?
> > > >=20
> > > > Also, when you ./configure rlib there is a screen at the end sayi=
ng how
> > > > RLIB is configured. Can you send that to me
> > > >=20
> > > > Also what distro are you using?
> > > >=20
> > > > On Mon, 2004-12-06 at 19:32 -0300, Cl=C3=83=C6=92=C3=82=C2=A1udio=
Fortier wrote:
> > > > > Hi Bob, thanks for your response.
> > > > >=20
> > > > > I really need access ORACLE, but rlib have no native access for=
it. Because this, i'm trying use unixODBC.
> > > > >=20
> > > > > unix ODBC works fine with the folow script:
> > > > > <html>
> > > > > <body>
> > > > >=20
> > > > > <?php
> > > > > $conn=3Dodbc_connect('oracle','u_test','u_test');=20
> > > > > if (!$conn)
> > > > > {
> > > > > exit("Connection Failed: " . $conn);=20
> > > > > }=20
> > > > > $sql=3D"SELECT * FROM TEN_PAC_PACIENTE";=20
> > > > > $rs=3Dodbc_exec($conn,$sql);=20
> > > > > if (!$rs)
> > > > > {=20
> > > > > exit("Error in SQL");
> > > > > }=20
> > > > > echo "<table><tr>";
> > > > > echo "<th>C=C3=83=C6=92=C3=82=C2=B3digo</th>";
> > > > > echo "<th>Nome</th></tr>";
> > > > > while (odbc_fetch_row($rs))
> > > > > {
> > > > > $CODIGO=3Dodbc_result($rs,"PAC_PK_INT_CODIGO");
> > > > > $NOME=3Dodbc_result($rs,"PAC_CHR_NOME");
> > > > > echo "<tr><td>$CODIGO</td>";
> > > > > echo "<td>$NOME</td></tr>";
> > > > > }
> > > > > odbc_close($conn);
> > > > > echo "</table>";
> > > > > ?>
> > > > >=20
> > > > > </body>
> > > > > </html>
> > > > >=20
> > > > > ------------------- reply ---------------
> > > > > > From: bd...@si...
> > > > > > To: for...@ya...
> > > > > > Cc: rli...@li...
> > > > > > Subject: Re: [Rlib-users] ODBC text
> > > > > > Date: 2004-12-06 14:41:30
> > > > > > ----------------------------------
> > > > > > I haven't used it since I wrote it
> > > > > >=20
> > > > > > does any other app work w/ the unixodbc??
> > > > > >=20
> > > > > > - bob
> > > > > >=20
> > > > > > On Mon, 2004-12-06 at 08:41 -0300, Claudio Fortier wrote:
> > > > > > > Hi, i'm trying use rlib with unixodbc and PHP in linux
> > > > > > > rh8. Someone has used rlib with unixodbc? I need
> > > > > > > examples.=20
> > > > > > >=20
> > > > > > > My tests every returns the message "The connection was
> > > > > > > refused when attenpting to contact www.localhost.com"
> > > > > > >=20
> > > > > > > Please, help me.=20
> > > > > > >=20
> > > > > > >=20
> > > > > > > =09
> > > > > > > =09
> > > > > > > =09
> > > > > > > _______________________________________________________=20
> > > > > > > Yahoo! Mail - Agora com 250MB de espa=C3=83=C6=92=C3=86=E2=80=
=99=C3=83=E2=80=9A=C3=82=C2=A7o gratuito. Abra=20
> > > > > > > uma conta agora! http://br.info.mail.yahoo.com/
> > > > > > >=20
> > > > > > >=20
> > > > > > > -------------------------------------------------------
> > > > > > > SF email is sponsored by - The IT Product Guide
> > > > > > > Read honest & candid reviews on hundreds of IT Products fro=
m real users.
> > > > > > > Discover which products truly live up to the hype. Start re=
ading now.=20
> > > > > > > http://productguide.itmanagersjournal.com/
> > > > > > > _______________________________________________
> > > > > > > Rlib-users mailing list
> > > > > > > Rli...@li...
> > > > > > > https://lists.sourceforge.net/lists/listinfo/rlib-users
> > > > > >=20
> > > > > >=20
> > > > > >=20
> > > > > > -------------------------------------------------------
> > > > > > SF email is sponsored by - The IT Product Guide
> > > > > > Read honest & candid reviews on hundreds of IT Products from =
real users.
> > > > > > Discover which products truly live up to the hype. Start read=
ing now.
> > > > > > http://productguide.itmanagersjournal.com/
> > > > > > _______________________________________________
> > > > > > Rlib-users mailing list
> > > > > > Rli...@li...
> > > > > > https://lists.sourceforge.net/lists/listinfo/rlib-users
> > > > > >=20
> > > > >=20
> > > >=20
> > > >=20
> > > >=20
> > > > -------------------------------------------------------
> > > > SF email is sponsored by - The IT Product Guide
> > > > Read honest & candid reviews on hundreds of IT Products from real=
users.
> > > > Discover which products truly live up to the hype. Start reading =
now.
> > > > http://productguide.itmanagersjournal.com/
> > > > _______________________________________________
> > > > Rlib-users mailing list
> > > > Rli...@li...
> > > > https://lists.sourceforge.net/lists/listinfo/rlib-users
> > > >=20
> > >=20
> >=20
> >=20
> >=20
> > -------------------------------------------------------
> > SF email is sponsored by - The IT Product Guide
> > Read honest & candid reviews on hundreds of IT Products from real use=
rs.
> > Discover which products truly live up to the hype. Start reading now.
> > http://productguide.itmanagersjournal.com/
> > _______________________________________________
> > Rlib-users mailing list
> > Rli...@li...
> > https://lists.sourceforge.net/lists/listinfo/rlib-users
> >=20
>=20
|
|
From: Bob D. <bd...@si...> - 2004-12-09 14:22:20
|
Ok.. now I need a stack trace
after it crashes you should have core.xxxxx
run gdb /usr/bin/php core.xxxxxxxxx
when you get to the gdb prompt type: bt
then send me the output
Thanks!
- bob
On Wed, 2004-12-08 at 18:32 -0300, Cl=C3=A1udio Fortier wrote:
> Hi, Bob.=20
>=20
> Using command line i correct some params errors and now the script has=
returned the folow:
>=20
> #php array_oracle.php
>=20
> Setting output encoding to ISO-8859-1
> Setting locale to [LC_CTYPE=3Dpt_BR;LC_NUMERIC=3DC;LC_TIME=3DC;LC_COLLA=
TE=3DC;LC_MONETARY=3DC;LC_MESSAGES=3DC;LC_PAPER=3DC;LC_NAME=3DC;LC_ADDRES=
S=3DC;LC_TELEPHONE=3DC;LC_MEASUREMENT=3DC;LC_IDENTIFICATION=3DC] FAILEDen=
coding is NULL or invalid [C]... using en_USencoding is NULL or invalid [=
C]... using en_USencoding is NULL or invalid [C]... using en_USencoding i=
s NULL or invalid [C]... using en_USencoding is NULL or invalid [C]... us=
ing en_USencoding is NULL or invalid [C]... using en_USencoding is NULL o=
r invalid [C]... using en_USencoding is NULL or invalid [C]... using en_U=
Sencoding is NULL or invalid [C]... using en_USencoding is NULL or invali=
d [C]... using en_USencoding is NULL or invalid
> [C]... using en_US** NUTS.. WE CRASHED
> Sair (core dumped)
>=20
> ------------------- reply ---------------
> > From: bd...@si...
> > To: cfo...@ib...
> > Cc: rli...@li...
> > Subject: Re: [Rlib-users] ODBC text
> > Date: 2004-12-08 10:57:46
> > ----------------------------------
> > Can you run it from the command line so I can see the exact error
> > messages?
> >=20
> > - bob
> >=20
> > On Wed, 2004-12-08 at 06:52 -0300, Cl=C3=83=C2=A1udio Fortier wrote:
> > > Of course. There are the scrip and xml files:
> > >=20
> > > array_oracle.php
> > > <? dl ("librlib.so");
> > > $rlib =3D rlib_init();
> > > rlib_add_datasource_odbc($rlib, "odbcsusfacil", "u_susfacil", "u_s=
usfacil");
> > > rlib_add_query_as($rlib, "odbcsusfacil", "select * from ten_pac_pa=
ciente", "ten_pac_paciente");
> > > rlib_add_report($rlib, "array_oracle.xml", "ten_pac_paciente");
> > > rlib_set_output_format_from_text($rlib, "pdf");
> > > rlib_execute($rlib);
> > > header(rlib_get_content_type($rlib));
> > > rlib_spool($rlib);
> > > rlib_free($rlib);
> > > ?>
> > >=20
> > > array_oracle.xml
> > > <?xml version=3D"1.0"?>
> > > <!DOCTYPE report >
> > > <Report fontSize=3D"9" orientation=3D"landscape">
> > > <Alternate>
> > > <NoData>
> > > <Output>
> > > <Line fontSize=3D"12">
> > > <literal>NO DATA</literal>
> > > </Line> =09
> > > </Output>
> > > </NoData>
> > > </Alternate>
> > > <ReportHeader>
> > > <Output>
> > > <Line fontSize=3D"11">
> > > <literal>Test Report (Normal) AND THE REPORT FORMAT IS: </liter=
al>
> > > <field value=3D"r.format" width=3D"20"/>
> > > <field value=3D"eval('1+2')" width=3D"20"/>
> > > </Line>
> > > <Line fontSize=3D"11">
> > > <literal bold=3D"yes">Test Report (Bold)</literal>
> > > </Line>
> > > <Line fontSize=3D"11">
> > > <literal italics=3D"yes">Test Report (Italics)</literal>
> > > </Line>
> > > <Line fontSize=3D"11">
> > > <literal bold=3D"yes" italics=3D"yes">Test Report (Bold and Ita=
lics)</literal>
> > > </Line>
> > > <HorizontalLine size=3D"4" bgcolor=3D"'white'"/>
> > > </Output>
> > > </ReportHeader> =09
> > > <Breaks>=09
> > > <Break name=3D"break0" newpage=3D"no" headernewpage=3D"yes">
> > > <BreakHeader>
> > > <Output>
> > > <Line>
> > > <field value=3D"group" width=3D"20" align=3D"left" col=3D"1"/=
> =09
> > > </Line>
> > > </Output> =09
> > > </BreakHeader>
> > > <BreakFields>
> > > <BreakField value=3D"group"/>
> > > </BreakFields>
> > > <BreakFooter>
> > > <Output>
> > > <HorizontalLine size=3D"4" bgcolor=3D"'white'"/>
> > > <HorizontalLine size=3D"2" bgcolor=3D"'black'"/>
> > > <HorizontalLine size=3D"4" bgcolor=3D"'white'"/>
> > > <Line>
> > > <field value=3D"group" width=3D"20" align=3D"left" col=3D"1"/=
> =09
> > > </Line>
> > > <HorizontalLine size=3D"4" bgcolor=3D"'white'"/>
> > > <HorizontalLine size=3D"2" bgcolor=3D"'black'"/>
> > > <HorizontalLine size=3D"4" bgcolor=3D"'white'"/>
> > > </Output>
> > > </BreakFooter>
> > > </Break>
> > > </Breaks>
> > > <Detail>
> > > <FieldHeaders>
> > > <Output>
> > > <HorizontalLine size=3D"1" bgcolor=3D"'black'"/>
> > > <Line bgcolor=3D"'0xe5e5e5'">
> > > <literal width=3D"20" col=3D"1">First Name</literal>
> > > <literal width=3D"1"/>
> > > <literal width=3D"20" col=3D"2">Last Name</literal>
> > > <literal width=3D"1"/>
> > > <literal width=3D"20" col=3D"3">Color</literal>
> > > </Line>
> > > <HorizontalLine size=3D"1" bgcolor=3D"'black'"/>
> > > <HorizontalLine size=3D"4" bgcolor=3D"'white'"/>
> > > </Output>
> > > </FieldHeaders> =09
> > > <FieldDetails>
> > > <Output>
> > > <Line bgcolor=3D"iif(r.detailcnt%2,'0xe5e5e5','white')">
> > > <field value=3D"PAC_PK_INT_CODIGO" width=3D"20" align=3D"left"=
col=3D"1"/>
> > > <literal width=3D"1"/>
> > > <field value=3D"PAC_CHR_NOME" width=3D"20" align=3D"left" col=3D=
"2"/>
> > > <literal width=3D"1"/>
> > > <field value=3D"PAC_CHR_TELEFONE" width=3D"20" align=3D"left" =
col=3D"3"/>
> > > </Line>
> > > </Output>
> > > </FieldDetails>
> > > </Detail>
> > >=20
> > > <PageFooter>
> > > <Output>
> > > <Line>
> > > <literal>Page: </literal>=09
> > > <field value=3D"r.pageno" width=3D"3" align=3D"right"/>
> > > </Line>
> > > </Output>
> > > </PageFooter>
> > >=20
> > > <ReportFooter>
> > > </ReportFooter>
> > > </Report>
> > >=20
> > >=20
> > > ------------------- reply ---------------
> > > > From: bd...@si...
> > > > To: cfo...@ib...
> > > > Cc: rli...@li...
> > > > Subject: Re: [Rlib-users] ODBC text
> > > > Date: 2004-12-07 18:15:15
> > > > ----------------------------------
> > > > Can I see the php file you created for RLIB causes the error?
> > > >=20
> > > > - bob
> > > >=20
> > > > On Tue, 2004-12-07 at 17:52 -0300, Cl=C3=83=C6=92=C3=82=C2=A1udio=
Fortier wrote:
> > > > > Hi, Bob.
> > > > >=20
> > > > > I'm using Linux RedHat 8.
> > > > >=20
> > > > > Yes the PHP standalone ODBC test works.
> > > > >=20
> > > > > The PHP RLIB example array.php works too.
> > > > >=20
> > > > > There is the RLIB configuration:
> > > > >=20
> > > > >=20
> > > > > rlib-1.3.0:
> > > > >=20
> > > > > prefix: /usr/local
> > > > > compiler: gcc
> > > > > Memory debugging: no
> > > > > Warning Fun: no
> > > > > Crash detection: yes
> > > > > UTF8 disabled: no
> > > > >=20
> > > > > INPUTS:
> > > > > MYSQL: yes
> > > > > POSTGRE: yes
> > > > > ODBC: yes
> > > > >=20
> > > > > OUTPUTS:
> > > > > PDF: yes
> > > > > HTML: Always
> > > > > CSV: Always
> > > > > TEXT: Always
> > > > >=20
> > > > > BINDINGS:
> > > > > PHP: yes
> > > > > PHP entension dir: /usr/local/lib/php/extensions=
/no-debug-non-zts
> > > > > -20020429
> > > > > PYTHON: no
> > > > > PYTHON version: 2.2
> > > > > PYTHON entension dir:
> > > > > JAVA: no
> > > > > PERL: no
> > > > > PERL entension dir:
> > > > >=20
> > > > > Music: Velvet Revolver
> > > > >=20
> > > > > Having Problems: rli...@li...
> > > > > Want to contribute: rli...@li...
> > > > >=20
> > > > >=20
> > > > >=20
> > > > > ------------------- reply ---------------
> > > > > > From: bd...@si...
> > > > > > To: cfo...@ib...
> > > > > > Cc: rli...@li...
> > > > > > Subject: Re: [Rlib-users] ODBC text
> > > > > > Date: 2004-12-07 10:52:16
> > > > > > ----------------------------------
> > > > > >=20
> > > > > > So the PHP standalone ODBC test works?
> > > > > >=20
> > > > > > Also, when you ./configure rlib there is a screen at the end =
saying how
> > > > > > RLIB is configured. Can you send that to me
> > > > > >=20
> > > > > > Also what distro are you using?
> > > > > >=20
> > > > > > On Mon, 2004-12-06 at 19:32 -0300, Cl=C3=83=C6=92=C3=86=E2=80=
=99=C3=83=E2=80=9A=C3=82=C2=A1udio Fortier wrote:
> > > > > > > Hi Bob, thanks for your response.
> > > > > > >=20
> > > > > > > I really need access ORACLE, but rlib have no native access=
for it. Because this, i'm trying use unixODBC.
> > > > > > >=20
> > > > > > > unix ODBC works fine with the folow script:
> > > > > > > <html>
> > > > > > > <body>
> > > > > > >=20
> > > > > > > <?php
> > > > > > > $conn=3Dodbc_connect('oracle','u_test','u_test');=20
> > > > > > > if (!$conn)
> > > > > > > {
> > > > > > > exit("Connection Failed: " . $conn);=20
> > > > > > > }=20
> > > > > > > $sql=3D"SELECT * FROM TEN_PAC_PACIENTE";=20
> > > > > > > $rs=3Dodbc_exec($conn,$sql);=20
> > > > > > > if (!$rs)
> > > > > > > {=20
> > > > > > > exit("Error in SQL");
> > > > > > > }=20
> > > > > > > echo "<table><tr>";
> > > > > > > echo "<th>C=C3=83=C6=92=C3=86=E2=80=99=C3=83=E2=80=9A=C3=82=
=C2=B3digo</th>";
> > > > > > > echo "<th>Nome</th></tr>";
> > > > > > > while (odbc_fetch_row($rs))
> > > > > > > {
> > > > > > > $CODIGO=3Dodbc_result($rs,"PAC_PK_INT_CODIGO");
> > > > > > > $NOME=3Dodbc_result($rs,"PAC_CHR_NOME");
> > > > > > > echo "<tr><td>$CODIGO</td>";
> > > > > > > echo "<td>$NOME</td></tr>";
> > > > > > > }
> > > > > > > odbc_close($conn);
> > > > > > > echo "</table>";
> > > > > > > ?>
> > > > > > >=20
> > > > > > > </body>
> > > > > > > </html>
> > > > > > >=20
> > > > > > > ------------------- reply ---------------
> > > > > > > > From: bd...@si...
> > > > > > > > To: for...@ya...
> > > > > > > > Cc: rli...@li...
> > > > > > > > Subject: Re: [Rlib-users] ODBC text
> > > > > > > > Date: 2004-12-06 14:41:30
> > > > > > > > ----------------------------------
> > > > > > > > I haven't used it since I wrote it
> > > > > > > >=20
> > > > > > > > does any other app work w/ the unixodbc??
> > > > > > > >=20
> > > > > > > > - bob
> > > > > > > >=20
> > > > > > > > On Mon, 2004-12-06 at 08:41 -0300, Claudio Fortier wrote:
> > > > > > > > > Hi, i'm trying use rlib with unixodbc and PHP in linux
> > > > > > > > > rh8. Someone has used rlib with unixodbc? I need
> > > > > > > > > examples.=20
> > > > > > > > >=20
> > > > > > > > > My tests every returns the message "The connection was
> > > > > > > > > refused when attenpting to contact www.localhost.com"
> > > > > > > > >=20
> > > > > > > > > Please, help me.=20
> > > > > > > > >=20
> > > > > > > > >=20
> > > > > > > > > =09
> > > > > > > > > =09
> > > > > > > > > =09
> > > > > > > > > _______________________________________________________=
=20
> > > > > > > > > Yahoo! Mail - Agora com 250MB de espa=C3=83=C6=92=C3=86=
=E2=80=99=C3=83=E2=80=A0=C3=A2=E2=82=AC=E2=84=A2=C3=83=C6=92=C3=A2=E2=82=AC=
=C5=A1=C3=83=E2=80=9A=C3=82=C2=A7o gratuito. Abra=20
> > > > > > > > > uma conta agora! http://br.info.mail.yahoo.com/
> > > > > > > > >=20
> > > > > > > > >=20
> > > > > > > > > -------------------------------------------------------
> > > > > > > > > SF email is sponsored by - The IT Product Guide
> > > > > > > > > Read honest & candid reviews on hundreds of IT Products=
from real users.
> > > > > > > > > Discover which products truly live up to the hype. Star=
t reading now.=20
> > > > > > > > > http://productguide.itmanagersjournal.com/
> > > > > > > > > _______________________________________________
> > > > > > > > > Rlib-users mailing list
> > > > > > > > > Rli...@li...
> > > > > > > > > https://lists.sourceforge.net/lists/listinfo/rlib-users
> > > > > > > >=20
> > > > > > > >=20
> > > > > > > >=20
> > > > > > > > -------------------------------------------------------
> > > > > > > > SF email is sponsored by - The IT Product Guide
> > > > > > > > Read honest & candid reviews on hundreds of IT Products f=
rom real users.
> > > > > > > > Discover which products truly live up to the hype. Start =
reading now.
> > > > > > > > http://productguide.itmanagersjournal.com/
> > > > > > > > _______________________________________________
> > > > > > > > Rlib-users mailing list
> > > > > > > > Rli...@li...
> > > > > > > > https://lists.sourceforge.net/lists/listinfo/rlib-users
> > > > > > > >=20
> > > > > > >=20
> > > > > >=20
> > > > > >=20
> > > > > >=20
> > > > > > -------------------------------------------------------
> > > > > > SF email is sponsored by - The IT Product Guide
> > > > > > Read honest & candid reviews on hundreds of IT Products from =
real users.
> > > > > > Discover which products truly live up to the hype. Start read=
ing now.
> > > > > > http://productguide.itmanagersjournal.com/
> > > > > > _______________________________________________
> > > > > > Rlib-users mailing list
> > > > > > Rli...@li...
> > > > > > https://lists.sourceforge.net/lists/listinfo/rlib-users
> > > > > >=20
> > > > >=20
> > > >=20
> > > >=20
> > > >=20
> > > > -------------------------------------------------------
> > > > SF email is sponsored by - The IT Product Guide
> > > > Read honest & candid reviews on hundreds of IT Products from real=
users.
> > > > Discover which products truly live up to the hype. Start reading =
now.
> > > > http://productguide.itmanagersjournal.com/
> > > > _______________________________________________
> > > > Rlib-users mailing list
> > > > Rli...@li...
> > > > https://lists.sourceforge.net/lists/listinfo/rlib-users
> > > >=20
> > >=20
> >=20
> >=20
> >=20
> > -------------------------------------------------------
> > SF email is sponsored by - The IT Product Guide
> > Read honest & candid reviews on hundreds of IT Products from real use=
rs.
> > Discover which products truly live up to the hype. Start reading now.
> > http://productguide.itmanagersjournal.com/
> > _______________________________________________
> > Rlib-users mailing list
> > Rli...@li...
> > https://lists.sourceforge.net/lists/listinfo/rlib-users
> >=20
>=20
|
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X