rlib-users — RLIB Users Mailing List

[Rlib-users] Unable to compile rlib 1.3.0 Opteron 64 bit CPU

[Billy S. <bi...@sc...>]

Hello,

I am trying to compile rlib 1.3.0 on a server with dual AMD Opteron (tm)
Processor 848 (64 bit) CPU's running Red Hat Enterprise Linux AS (version
3 update 2).

Info about server:
[foo rlib-1.3.0]$ uname -a
Linux host.somewhere.com 2.4.21-15.ELsmp #1 SMP Thu Apr 22 00:09:01 EDT
2004 x86_64 x86_64 x86_64 GNU/Linux
[foo rlib-1.3.0]$

I am using GNU Make 3.8.0, gcc version 3.4.3. The configure script works
fine (see output below), but make gives an error about conflicting types
for llabs. I have tried enabling and disabling various options availble to
configure (disabling everything) and still get the error.

Any help to get this compiled would be greatly appreciated.



Output of configure:
[foo rlib-1.3.0]$ ./configure --with-pythonver=2.4
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for gawk... gawk
checking whether make sets $(MAKE)... yes
checking whether to enable maintainer-specific portions of Makefiles... no
checking for gcc... gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ANSI C... none needed
checking for style of include used by make... GNU
checking dependency style of gcc... gcc3
checking whether make sets $(MAKE)... (cached) yes
checking for a BSD-compatible install... /usr/bin/install -c
checking build system type... x86_64-redhat-linux-gnu
checking host system type... x86_64-redhat-linux-gnu
checking for a sed that does not truncate output... /bin/sed
checking for egrep... grep -E
checking for ld used by gcc... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking for /usr/bin/ld option to reload object files... -r
checking for BSD-compatible nm... /usr/bin/nm -B
checking whether ln -s works... yes
checking how to recognise dependent libraries... pass_all
checking how to run the C preprocessor... gcc -E
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking dlfcn.h usability... yes
checking dlfcn.h presence... yes
checking for dlfcn.h... yes
checking for g++... g++
checking whether we are using the GNU C++ compiler... yes
checking whether g++ accepts -g... yes
checking dependency style of g++... gcc3
checking how to run the C++ preprocessor... g++ -E
checking for g77... g77
checking whether we are using the GNU Fortran 77 compiler... yes
checking whether g77 accepts -g... yes
checking the maximum length of command line arguments... 32768
checking command to parse /usr/bin/nm -B output from gcc object... ok
checking for objdir... .libs
checking for ar... ar
checking for ranlib... ranlib
checking for strip... strip
checking if gcc static flag  works... yes
checking if gcc supports -fno-rtti -fno-exceptions... no
checking for gcc option to produce PIC... -fPIC
checking if gcc PIC flag -fPIC works... yes
checking if gcc supports -c -o file.o... yes
checking whether the gcc linker (/usr/bin/ld -m elf_x86_64) supports
shared libraries... yes
checking whether -lc should be explicitly linked in... no
checking dynamic linker characteristics... GNU/Linux ld.so
checking how to hardcode library paths into programs... immediate
checking whether stripping libraries is possible... yes
checking for shl_load... no
checking for shl_load in -ldld... no
checking for dlopen... no
checking for dlopen in -ldl... yes
checking whether a program can dlopen itself... yes
checking whether a statically linked program can dlopen itself... yes
checking if libtool supports shared libraries... yes
checking whether to build shared libraries... yes
checking whether to build static libraries... no
configure: creating libtool
appending configuration tag "CXX" to libtool
checking for ld used by g++... /usr/bin/ld -m elf_x86_64
checking if the linker (/usr/bin/ld -m elf_x86_64) is GNU ld... yes
checking whether the g++ linker (/usr/bin/ld -m elf_x86_64) supports
shared libraries... yes
checking for g++ option to produce PIC... -fPIC
checking if g++ PIC flag -fPIC works... yes
checking if g++ supports -c -o file.o... yes
checking whether the g++ linker (/usr/bin/ld -m elf_x86_64) supports
shared libraries... yes
checking dynamic linker characteristics... GNU/Linux ld.so
checking how to hardcode library paths into programs... immediate
checking whether stripping libraries is possible... yes
checking for shl_load... (cached) no
checking for shl_load in -ldld... (cached) no
checking for dlopen... (cached) no
checking for dlopen in -ldl... (cached) yes
checking whether a program can dlopen itself... (cached) yes
checking whether a statically linked program can dlopen itself... (cached)
yes
appending configuration tag "F77" to libtool
checking if libtool supports shared libraries... yes
checking whether to build shared libraries... yes
checking whether to build static libraries... no
checking for g77 option to produce PIC... -fPIC
checking if g77 PIC flag -fPIC works... yes
checking if g77 supports -c -o file.o... yes
checking whether the g77 linker (/usr/bin/ld -m elf_x86_64) supports
shared libraries... yes
checking dynamic linker characteristics... GNU/Linux ld.so
checking how to hardcode library paths into programs... immediate
checking whether stripping libraries is possible... yes
checking for exit in -lc... yes
checking for exp in -lm... yes
checking for pkg-config... /usr/local/bin/pkg-config
checking for libxml-2.0 >= 2.6.0... yes
checking LIBXML_CFLAGS... -I/usr/local/include/libxml2
checking LIBXML_LIBS... -L/usr/local/lib -lxml2 -lpthread -lz -lm
checking for glib-2.0 >= 0.0.1... yes
checking LIBGLIB_CFLAGS... -I/usr/local/include/glib-2.0
-I/usr/local/lib/glib-2.0/include
checking LIBGLIB_LIBS... -L/usr/local/lib -lglib-2.0
checking for gmodule-2.0 >= 0.0.1... yes
checking LIBGMODULE_CFLAGS... -I/usr/local/include/glib-2.0
-I/usr/local/lib/glib-2.0/include
checking LIBGMODULE_LIBS... -Wl,--export-dynamic -L/usr/local/lib
-lgmodule-2.0 -ldl -lglib-2.0
checking for mysql_config... /usr/bin/mysql_config
checking for pg_config... /usr/bin/pg_config
checking for ODBC files... configure: WARNING: ODBC input method is not
going to be used
checking for php-config... no
*** WARNING: PHP NOT FOUND IN PATH.  RLIB WILL NOT BE COMPILED WITH
SUPPORT FOR IT
TEST 1
checking for a Python interpreter with version >= 2.4... python
checking for python... /usr/local/bin/python
checking for python version... 2.4
checking for python platform... linux2
TEST 2
-I ${prefix}/include/python2.4
checking for PERL files... configure: WARNING: PERL bindings are not going
to be used
checking iconv.h usability... yes
checking iconv.h presence... yes
checking for iconv.h... yes
checking for iconv_open... yes
checking for iconv_open in -liconv... no
checking for libiconv_open in -liconv... no
checking where to find iconv_open... libc
checking whether iconv takes const char ** or char **... char **
checking whether iconv takes ISO8859-1 or ISO-8859-1... ISO8859-1
checking cpdflib.h usability... yes
checking cpdflib.h presence... yes
checking for cpdflib.h... yes
checking for cpdf_init in -lcpdf... yes
checking for ANSI C header files... (cached) yes
checking fcntl.h usability... yes
checking fcntl.h presence... yes
checking for fcntl.h... yes
checking for unistd.h... (cached) yes
checking for an ANSI C-conforming const... yes
configure: creating ./config.status
config.status: creating Makefile
config.status: creating rlib.pc
config.status: creating libsrc/Makefile
config.status: creating src/Makefile
config.status: creating src/examples/Makefile
config.status: creating src/examples/common/Makefile
config.status: creating src/examples/c/Makefile
config.status: creating src/examples/php/Makefile
config.status: creating src/examples/python/Makefile
config.status: creating src/examples/java/Makefile
config.status: creating bindings/Makefile
config.status: creating bindings/php/Makefile
config.status: creating bindings/python/Makefile
config.status: creating bindings/perl/Makefile
config.status: creating bindings/java/Makefile
config.status: creating bindings/interfaces/Makefile
config.status: creating inputs/Makefile
config.status: creating inputs/mysql/Makefile
config.status: creating inputs/odbc/Makefile
config.status: creating inputs/postgre/Makefile
config.status: creating tests/Makefile
config.status: creating config.h
config.status: executing depfiles commands

rlib-1.3.0:

        prefix:                   /usr/local
        compiler:                 gcc
        Memory debugging:         no
        Warning Fun:              no
        Crash detection:          yes
        UTF8 disabled:            no

        INPUTS:
         MYSQL:                   yes
         POSTGRE:                 yes
         ODBC:                    no

   OUTPUTS:
         PDF:                     yes
         HTML:                    Always
         CSV:                     Always
         TEXT:                    Always

        BINDINGS:
         PHP:                     no
          PHP entension dir:
         PYTHON:                  yes
          PYTHON version:         2.4
          PYTHON entension dir:   ${exec_prefix}/lib/python2.4/site-packages
         JAVA:                    no
         PERL:                    no
          PERL entension dir:

        Music:                    Velvet Revolver

        Having Problems:          rli...@li...
        Want to contribute:       rli...@li...
[foo rlib-1.3.0]$

Output of make:
[foo rlib-1.3.0]$ make
make  all-recursive
make[1]: Entering directory `/usr/ftp/rlib-1.3.0'
Making all in libsrc
make[2]: Entering directory `/usr/ftp/rlib-1.3.0/libsrc'
source='parsexml.c' object='parsexml.lo' libtool=yes \
depfile='.deps/parsexml.Plo' tmpdepfile='.deps/parsexml.TPlo' \
depmode=gcc3 /bin/sh ../depcomp \
/bin/sh ../libtool --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I..
-I/usr/local/include/libxml2   -I/usr/local/include/glib-2.0
-I/usr/local/lib/glib-2.0/include   -I/usr/local/include/glib-2.0
-I/usr/local/lib/glib-2.0/include   -I'/usr/include/mysql' -I /usr/include
  -I /usr/local/include/python2.4       -g -O2 -c -o parsexml.lo `test -f
'parsexml.c' || echo './'`parsexml.c
mkdir .libs
 gcc -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/local/include/libxml2
-I/usr/local/include/glib-2.0 -I/usr/local/lib/glib-2.0/include
-I/usr/local/include/glib-2.0 -I/usr/local/lib/glib-2.0/include
-I/usr/include/mysql -I /usr/include -I /usr/local/include/python2.4 -g
-O2 -c parsexml.c -MT parsexml.lo -MD -MP -MF .deps/parsexml.TPlo  -fPIC
-DPIC -o .libs/parsexml.o
source='reportgen.c' object='reportgen.lo' libtool=yes \
depfile='.deps/reportgen.Plo' tmpdepfile='.deps/reportgen.TPlo' \
depmode=gcc3 /bin/sh ../depcomp \
/bin/sh ../libtool --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I..
-I/usr/local/include/libxml2   -I/usr/local/include/glib-2.0
-I/usr/local/lib/glib-2.0/include   -I/usr/local/include/glib-2.0
-I/usr/local/lib/glib-2.0/include   -I'/usr/include/mysql' -I /usr/include
  -I /usr/local/include/python2.4       -g -O2 -c -o reportgen.lo `test -f
'reportgen.c' || echo './'`reportgen.c
 gcc -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/local/include/libxml2
-I/usr/local/include/glib-2.0 -I/usr/local/lib/glib-2.0/include
-I/usr/local/include/glib-2.0 -I/usr/local/lib/glib-2.0/include
-I/usr/include/mysql -I /usr/include -I /usr/local/include/python2.4 -g
-O2 -c reportgen.c -MT reportgen.lo -MD -MP -MF .deps/reportgen.TPlo 
-fPIC -DPIC -o .libs/reportgen.o
source='layout.c' object='layout.lo' libtool=yes \
depfile='.deps/layout.Plo' tmpdepfile='.deps/layout.TPlo' \
depmode=gcc3 /bin/sh ../depcomp \
/bin/sh ../libtool --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I..
-I/usr/local/include/libxml2   -I/usr/local/include/glib-2.0
-I/usr/local/lib/glib-2.0/include   -I/usr/local/include/glib-2.0
-I/usr/local/lib/glib-2.0/include   -I'/usr/include/mysql' -I /usr/include
  -I /usr/local/include/python2.4       -g -O2 -c -o layout.lo `test -f
'layout.c' || echo './'`layout.c
 gcc -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/local/include/libxml2
-I/usr/local/include/glib-2.0 -I/usr/local/lib/glib-2.0/include
-I/usr/local/include/glib-2.0 -I/usr/local/lib/glib-2.0/include
-I/usr/include/mysql -I /usr/include -I /usr/local/include/python2.4 -g
-O2 -c layout.c -MT layout.lo -MD -MP -MF .deps/layout.TPlo  -fPIC -DPIC
-o .libs/layout.o
source='api.c' object='api.lo' libtool=yes \
depfile='.deps/api.Plo' tmpdepfile='.deps/api.TPlo' \
depmode=gcc3 /bin/sh ../depcomp \
/bin/sh ../libtool --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I..
-I/usr/local/include/libxml2   -I/usr/local/include/glib-2.0
-I/usr/local/lib/glib-2.0/include   -I/usr/local/include/glib-2.0
-I/usr/local/lib/glib-2.0/include   -I'/usr/include/mysql' -I /usr/include
  -I /usr/local/include/python2.4       -g -O2 -c -o api.lo `test -f
'api.c' || echo './'`api.c
 gcc -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/local/include/libxml2
-I/usr/local/include/glib-2.0 -I/usr/local/lib/glib-2.0/include
-I/usr/local/include/glib-2.0 -I/usr/local/lib/glib-2.0/include
-I/usr/include/mysql -I /usr/include -I /usr/local/include/python2.4 -g
-O2 -c api.c -MT api.lo -MD -MP -MF .deps/api.TPlo  -fPIC -DPIC -o
.libs/api.o
source='resolution.c' object='resolution.lo' libtool=yes \
depfile='.deps/resolution.Plo' tmpdepfile='.deps/resolution.TPlo' \
depmode=gcc3 /bin/sh ../depcomp \
/bin/sh ../libtool --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I..
-I/usr/local/include/libxml2   -I/usr/local/include/glib-2.0
-I/usr/local/lib/glib-2.0/include   -I/usr/local/include/glib-2.0
-I/usr/local/lib/glib-2.0/include   -I'/usr/include/mysql' -I /usr/include
  -I /usr/local/include/python2.4       -g -O2 -c -o resolution.lo `test
-f 'resolution.c' || echo './'`resolution.c
 gcc -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/local/include/libxml2
-I/usr/local/include/glib-2.0 -I/usr/local/lib/glib-2.0/include
-I/usr/local/include/glib-2.0 -I/usr/local/lib/glib-2.0/include
-I/usr/include/mysql -I /usr/include -I /usr/local/include/python2.4 -g
-O2 -c resolution.c -MT resolution.lo -MD -MP -MF .deps/resolution.TPlo 
-fPIC -DPIC -o .libs/resolution.o
source='util.c' object='util.lo' libtool=yes \
depfile='.deps/util.Plo' tmpdepfile='.deps/util.TPlo' \
depmode=gcc3 /bin/sh ../depcomp \
/bin/sh ../libtool --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I..
-I/usr/local/include/libxml2   -I/usr/local/include/glib-2.0
-I/usr/local/lib/glib-2.0/include   -I/usr/local/include/glib-2.0
-I/usr/local/lib/glib-2.0/include   -I'/usr/include/mysql' -I /usr/include
  -I /usr/local/include/python2.4       -g -O2 -c -o util.lo `test -f
'util.c' || echo './'`util.c
 gcc -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/local/include/libxml2
-I/usr/local/include/glib-2.0 -I/usr/local/lib/glib-2.0/include
-I/usr/local/include/glib-2.0 -I/usr/local/lib/glib-2.0/include
-I/usr/include/mysql -I /usr/include -I /usr/local/include/python2.4 -g
-O2 -c util.c -MT util.lo -MD -MP -MF .deps/util.TPlo  -fPIC -DPIC -o
.libs/util.o
util.c:37: error: conflicting types for 'llabs'
util.c:37: error: conflicting types for 'llabs'
make[2]: *** [util.lo] Error 1
make[2]: Leaving directory `/usr/ftp/rlib-1.3.0/libsrc'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/usr/ftp/rlib-1.3.0'
make: *** [all] Error 2
[foo rlib-1.3.0]$


Thank you in advance!
Billy-

Re: [Rlib-users] PHP problems

[Bob D. <bd...@si...>]

Seems like you didn't have php-devel installed.

If thats not the case can you rerun configure and send the last part of
the output.

thanks

- bob

>
> I have installed ClibPDF and RLib 1.3.0.
>
> I am running: PHP Version 4.3.8
>
> OS: Fedora Core 2.
>
> When I try to run the test code provided on the RLib site, I get the
> following error:
>
> Warning: dl(): Unable to load dynamic library '/usr/lib/php4/libr.so' -
> /usr/lib/php4/libr.so: cannot open shared object file: No such file or
> directory in /var/www/html/php/test.php on line 34
>
>
> I found other similar problems listed in the archives, and tried all of
> the solutions presented, but none seem to work.
>
> Can anybody help me?
>
> Thank you,
> Michael McInally.
>
>
>
>
> -------------------------------------------------------
> 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
>

[Rlib-users] PHP problems

[Michael M. <mci...@pi...>]

I have installed ClibPDF and RLib 1.3.0.

I am running: PHP Version 4.3.8

OS: Fedora Core 2.

When I try to run the test code provided on the RLib site, I get the
following error:

Warning: dl(): Unable to load dynamic library '/usr/lib/php4/libr.so' -
/usr/lib/php4/libr.so: cannot open shared object file: No such file or
directory in /var/www/html/php/test.php on line 34


I found other similar problems listed in the archives, and tried all of
the solutions presented, but none seem to work.

Can anybody help me?

Thank you,
Michael McInally.

Re: [Rlib-users] ODBC text

[Bob D. <bd...@si...>]

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

Re: [Rlib-users] ODBC text

[Bob D. <bd...@si...>]

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

Re: [Rlib-users] ODBC text

[Bob D. <bd...@si...>]

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

Re: [Rlib-users] ODBC text

[Bob D. <bd...@si...>]

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

Re: [Rlib-users] Multple rows fields

[Bob D. <bd...@si...>]

Sadly No..

It's on my short term TODO list after graphing comes to life

- bob

On Sat, 2004-12-04 at 10:41 +0100, Matteo Ligabue wrote:
> I have to print a multiple row field (a "Note" field )  I can't know
> the number of lines in advance.
> Is there a way to achieve it with the library without a lot of work in
> PHP before printing?
> 
> 
> -------------------------------------------------------
> 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

Re: [Rlib-users] RE: SOmething to spot

[Bob D. <bd...@si...>]

On Sat, 2004-12-04 at 10:48 +0100, Matteo Ligabue wrote:
> > 
> > >           -print page header before report header
> > 
> > This could be an option
> > 
> 
> I will find it extremely useful, I have a lot of reports where i need
> to print header (logotype, etc) as the first thing in all my pages,
> and then a real report header .... I know I can duplicate page header
> in report header and use suppressPageHeaderFirstPage = yes, but  ...
> it's boring ....
> 

I'll try to do that this week

> Anyway, this wonderful tool DESERVE better documentation, how can I
> help (is there a complete feature list to work on, or 'it's all in the
> source'?).

Cool!! Someone wants to help!

docs are in rlib/doc

As far as features:
  look in src/pcode.c and there's a table of functions: +,-,val, ect 
  look in src/parsexml.c to see all of the options in XML you can have
  look in api.c to see the complete API


And if you have any questions just ask.. someone can explain

- bob

Re: [Rlib-users] ODBC text

[Bob D. <bd...@si...>]

I haven't used it since I wrote it

does any other app work w/ the unixodbc??

- bob

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=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. Start reading now.=20
> http://productguide.itmanagersjournal.com/
> _______________________________________________
> Rlib-users mailing list
> Rli...@li...
> https://lists.sourceforge.net/lists/listinfo/rlib-users

[Rlib-users] ODBC text

[Claudio F. <for...@ya...>]

Hi, i'm trying use rlib with unixodbc and PHP in linux
rh8. Someone has used rlib with unixodbc? I need
examples. 

My tests every returns the message "The connection was
refused when attenpting to contact www.localhost.com"

Please, help me. 


	
	
		
_______________________________________________________ 
Yahoo! Mail - Agora com 250MB de espaço gratuito. Abra 
uma conta agora! http://br.info.mail.yahoo.com/

[Rlib-users] RE: SOmething to spot

[Matteo L. <mat...@gm...>]

> 
> >           -print page header before report header
> 
> This could be an option
> 

I will find it extremely useful, I have a lot of reports where i need
to print header (logotype, etc) as the first thing in all my pages,
and then a real report header .... I know I can duplicate page header
in report header and use suppressPageHeaderFirstPage = yes, but  ...
it's boring ....

Anyway, this wonderful tool DESERVE better documentation, how can I
help (is there a complete feature list to work on, or 'it's all in the
source'?).

[Rlib-users] Multple rows fields

[Matteo L. <mat...@gm...>]

I have to print a multiple row field (a "Note" field )  I can't know
the number of lines in advance.
Is there a way to achieve it with the library without a lot of work in
PHP before printing?

Re: [Rlib-users] Total page number ...

[Bob D. <bd...@si...>]

Yea...

I've been meaning to do this.  It's kinda hard to do a "place holder" w/
the cpdf library.. but I'll take a crack at this soon

- bob

On Fri, 2004-12-03 at 09:10 +0100, Matteo Ligabue wrote:
> Another missing feature i really need is a r.totalpages field, to
> display something like:
> 'Page ' + r.pageno + ' of ' + r.totalpages in report footer.
> 
> I know you can't know in advance the total number of pages, but in
> other tools it's implemented this way : the rendereing drops a
> placeholder, then , before the final output, it goes back and replaces
> the placeholder with the real number of total pages ... of course this
> can be done that way only if the final output is buffered ... have to
> look at C sources ... (I have not written a single working line of C
> in years) ....
> 
> This obviously is only useful in page-oriented output styles (pdf)
> 
> 
> -------------------------------------------------------
> 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

Re: [Rlib-users] SOmething to spot ....

[Bob D. <bd...@si...>]

On Fri, 2004-12-03 at 08:55 +0100, Matteo Ligabue wrote:
> First of all, thank to all you guys for your wonderful job on the class ...
> After some trouble I get it working on PHP .. what a wonderful tool ...

Thanks!

> 
> Some points to spot:
> 
> 1) There should be an option, in the report tag, to set reportheader
> behaviour, something like:
>           -don't print page header on first page

use suppressPageHeaderFirstPage = yes


>           -print page header before report header

This could be an option

>           -print report header before page header (deafult, actual behaviour).
>     this could be very useful if you want to print logos and header in
> each page, and include only in the first a report header


The Report header comes out once before the page header. 

But for what you want to do you could just not use the report header and
put everything in the page header



> 
> 2) The XML should be obtained by a socket web request (like fopen in
> PHP) so you cna handle them dinamically.

If you try the beta release there is a new api function (1.3.0)

rlib_add_report_from_buffer(r, some_string)

So you can make a dynamic report and pass it in



> 3) There should really be a way to show errors in PHP pages ... it's
> very frustrating this way ...

We agree.  Error Reporting doesn't get passed up to the language
bindings nicley


> 
> Anyway, this tool is going to change my work ... thank you very much ...
> 
> 
> # =========================================================================
> # PHP CLASS : RReport
> #
> # Supported (in XML ): 
> #     <!-- include report.xml -->
> #     Should be alone on a line, includes the named report. Included
> report can include others ...
> #     #, // at the beginning of a line let the parser ignore the line
> 
> <?php
> 
> dl("librlib.so");
> 
> include_once( "class.dbengine.php" );
> 
> 
> $REPORT_DIR = "reports";
> $REPORT_CACHE_DIR = "reports/cache";
> 
> class RReport{
> 
> 	var $_rh;
> 	var $dbinit;
> 
> 	var $debug;
> 
> 	var $formato;
> 	var $parametri = Array( );
> 
> 	function RReport( $formato = 'pdf', $debug = 0 )
> 	{
> 		$this->_rh = rlib_init( );
> 		$this->formato = $formato;
> 		$this->dbinit = 0;
> 		$this->debug = 1;
> 	}
> 
> 	function qbe( $queryname, $table, $example, $limitstart = "", $limitsize = "" )
> 	{
> 		global $db;
> 
> 		$this->query( $queryname, $db->_qbequery( $table, $example),
> $limitstart, $limitsize );
> 		
> 	}
> 
> 	function query( $queryname, $sql  )
> 	{
> 		global $db;
> 
>                 if( $this->dbinit == 0 ){
>                         rlib_add_datasource_mysql($this->_rh,
> "local_mysql", $db->_dbhost, $db->_dbuser, $db->_dbpass, $db->_dbname
> );
>                         $this->dbinit = 1;
>                 }
>          	rlib_add_query_as($this->_rh, "local_mysql", $sql, $queryname );
> 	}
> 
> 	function addParameter( $name, $value )
> 	{
> 
> 		$this->parametri[$name] = $value;	
> 	}
> 
> 	function addReport( $fn )
> 	{
> 		global $REPORT_CACHE_DIR;
> 
> 		if( $this->debug || !file_exists( $REPORT_CACHE_DIR . "/" . $fn ) ){
> 			$f = fopen( $REPORT_CACHE_DIR . "/" . $fn, "w" );
> 			fputs( $f, $this->_parseReport( $fn ) );
> 			fclose( $f );
> 		}
>         	rlib_add_report( $this->_rh, $REPORT_CACHE_DIR . "/" . $fn );
> 	}
> 
> 	function _parseReport( $fn )
> 	{
> 		global $REPORT_DIR;
> 		global $REPORT_CACHE_DIR;
> 
> 		$righe = file( $REPORT_DIR . "/" . $fn );
> 		$ret = "";
> 		for( $i = 0; $i < sizeof( $righe ); $i++ )
> 		{
> 			$riga = trim( $righe[$i] );
> 			# ESCLUDO I COMMENTI
> 			if( substr( $riga,0,1 ) != "#" && substr( $riga, 0, 2 ) != "//" )
> 			{			
> 				if( substr( $riga, 0, 4 ) == "<!--" && substr( $riga, -3 ) == "-->" )
> 				{
> 					#riga di comando, estraggo ...
> 					$words = split( " ", trim( substr( $riga, 4, strlen( $riga ) - 7 ) ) );
> 					switch( strtolower( $words[ 0 ] ) )
> 					{
> 						case "include":
> 							$ret .= $this->_parseReport( trim( $words[ 1 ] ) );
> 							break;
> 						
> 					}
> 				}	
> 				else
> 				{
> 					$ret .= $riga . "\n";
> 				}
> 			}
> 
> 		}
> 		return $ret;
> 	}
> 
> 	function render( $fn = "stampa.pdf" )
> 	{
> 		$pars = array_keys( $this->parametri );
> 		for( $i = 0; $i < sizeof( $pars ); $i++ ){
> 	 		rlib_add_parameter( $this->_rh, $pars[ $i ], $this->parametri[$pars[$i]] ); 
> 		}
>                 rlib_set_output_format_from_text($this->_rh, $this->formato );
>                 rlib_execute($this->_rh);
> 
> 	        header(rlib_get_content_type($this->_rh ) );
> 	        if( $this->formato == "pdf" ){
> 		    header("Content-Disposition: inline; filename=" . $fn );
> 	        }
> 	        rlib_spool($this->_rh);
> 	        rlib_free($this->_rh);
> 	}
> }
> 
> 
> ?>
> 
> 
> -------------------------------------------------------
> 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

[Rlib-users] Total page number ...

[Matteo L. <mat...@gm...>]

Another missing feature i really need is a r.totalpages field, to
display something like:
'Page ' + r.pageno + ' of ' + r.totalpages in report footer.

I know you can't know in advance the total number of pages, but in
other tools it's implemented this way : the rendereing drops a
placeholder, then , before the final output, it goes back and replaces
the placeholder with the real number of total pages ... of course this
can be done that way only if the final output is buffered ... have to
look at C sources ... (I have not written a single working line of C
in years) ....

This obviously is only useful in page-oriented output styles (pdf)

[Rlib-users] SOmething to spot ....

[Matteo L. <mat...@gm...>]

First of all, thank to all you guys for your wonderful job on the class ...
After some trouble I get it working on PHP .. what a wonderful tool ...

Some points to spot:

1) There should be an option, in the report tag, to set reportheader
behaviour, something like:
          -don't print page header on first page
          -print page header before report header
          -print report header before page header (deafult, actual behaviour).
    this could be very useful if you want to print logos and header in
each page, and include only in the first a report header

2) The XML should be obtained by a socket web request (like fopen in
PHP) so you cna handle them dinamically.
    TO solve this I have written a minimal (alpha) class in PHP to
parse the report and cache; the main usage of this is use something
like an Include to share header and footer between a whole application
... I also use it to put comments in XML (it's appended to the
message)

3) There should really be a way to show errors in PHP pages ... it's
very frustrating this way ...

Anyway, this tool is going to change my work ... thank you very much ...


# =========================================================================
# PHP CLASS : RReport
#
# Supported (in XML ): 
#     <!-- include report.xml -->
#     Should be alone on a line, includes the named report. Included
report can include others ...
#     #, // at the beginning of a line let the parser ignore the line

<?php

dl("librlib.so");

include_once( "class.dbengine.php" );


$REPORT_DIR = "reports";
$REPORT_CACHE_DIR = "reports/cache";

class RReport{

	var $_rh;
	var $dbinit;

	var $debug;

	var $formato;
	var $parametri = Array( );

	function RReport( $formato = 'pdf', $debug = 0 )
	{
		$this->_rh = rlib_init( );
		$this->formato = $formato;
		$this->dbinit = 0;
		$this->debug = 1;
	}

	function qbe( $queryname, $table, $example, $limitstart = "", $limitsize = "" )
	{
		global $db;

		$this->query( $queryname, $db->_qbequery( $table, $example),
$limitstart, $limitsize );
		
	}

	function query( $queryname, $sql  )
	{
		global $db;

                if( $this->dbinit == 0 ){
                        rlib_add_datasource_mysql($this->_rh,
"local_mysql", $db->_dbhost, $db->_dbuser, $db->_dbpass, $db->_dbname
);
                        $this->dbinit = 1;
                }
         	rlib_add_query_as($this->_rh, "local_mysql", $sql, $queryname );
	}

	function addParameter( $name, $value )
	{

		$this->parametri[$name] = $value;	
	}

	function addReport( $fn )
	{
		global $REPORT_CACHE_DIR;

		if( $this->debug || !file_exists( $REPORT_CACHE_DIR . "/" . $fn ) ){
			$f = fopen( $REPORT_CACHE_DIR . "/" . $fn, "w" );
			fputs( $f, $this->_parseReport( $fn ) );
			fclose( $f );
		}
        	rlib_add_report( $this->_rh, $REPORT_CACHE_DIR . "/" . $fn );
	}

	function _parseReport( $fn )
	{
		global $REPORT_DIR;
		global $REPORT_CACHE_DIR;

		$righe = file( $REPORT_DIR . "/" . $fn );
		$ret = "";
		for( $i = 0; $i < sizeof( $righe ); $i++ )
		{
			$riga = trim( $righe[$i] );
			# ESCLUDO I COMMENTI
			if( substr( $riga,0,1 ) != "#" && substr( $riga, 0, 2 ) != "//" )
			{			
				if( substr( $riga, 0, 4 ) == "<!--" && substr( $riga, -3 ) == "-->" )
				{
					#riga di comando, estraggo ...
					$words = split( " ", trim( substr( $riga, 4, strlen( $riga ) - 7 ) ) );
					switch( strtolower( $words[ 0 ] ) )
					{
						case "include":
							$ret .= $this->_parseReport( trim( $words[ 1 ] ) );
							break;
						
					}
				}	
				else
				{
					$ret .= $riga . "\n";
				}
			}

		}
		return $ret;
	}

	function render( $fn = "stampa.pdf" )
	{
		$pars = array_keys( $this->parametri );
		for( $i = 0; $i < sizeof( $pars ); $i++ ){
	 		rlib_add_parameter( $this->_rh, $pars[ $i ], $this->parametri[$pars[$i]] ); 
		}
                rlib_set_output_format_from_text($this->_rh, $this->formato );
                rlib_execute($this->_rh);

	        header(rlib_get_content_type($this->_rh ) );
	        if( $this->formato == "pdf" ){
		    header("Content-Disposition: inline; filename=" . $fn );
	        }
	        rlib_spool($this->_rh);
	        rlib_free($this->_rh);
	}
}


?>

Re: [Rlib-users] RLIB 1.3.0 released

[Everton L. B. <ev...@fa...>]

Hi,
I found errors using the new rlib with php4 and php5.

everton@nsa3:~/workspace/sanovo_v1/gradecurricular$ php 
gradecurricular.php > a.pdf
PHP Warning:  dl(): Unable to load dynamic library 
'/usr/lib/php/extensions/no-debug-non-zts-20020429/librlib.so' - 
libr-1.3.0.so: cannot open shared object file: No such file or directory 
in /home/everton/workspace/sanovo_v1/gradecurricular/gradecurricular.php 
on line 1
PHP Fatal error:  Call to undefined function:  rlib_init() in 
/home/everton/workspace/sanovo_v1/gradecurricular/gradecurricular.php on 
line 13

The extensions directory is right and *.so files exists.

-- 
Everton Luis Berz


Bob Doan wrote:
> Fajitas!
> 
> I'm proud to announce the 1st official test release of RLIB 1.4
> 
> Features include:
> 
> * Parts
> * Fixed and Flow Layouts
> * Bold and Italics
> * Language Improvements such as "eval"
> * PHP Array input method
> * More stability?
> * Horizontal line's properties are more dynamic
> * Break's newpage is dynamic (for Carol)
> 
> And much more!!
> 
> Please give it a go
> 
> Also.. I'm now looking for people to help fix the RLIB manual.  PLEASE
> PLEASE PLEASE
> 
> You can download it from source forge
> 
> - bob
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: InterSystems CACHE
> FREE OODBMS DOWNLOAD - A multidimensional database that combines
> robust object and relational technologies, making it a perfect match
> for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8
> _______________________________________________
> Rlib-users mailing list
> Rli...@li...
> https://lists.sourceforge.net/lists/listinfo/rlib-users
> 

[Rlib-users] RLIB 1.3.0 released

[Bob D. <bd...@si...>]

Fajitas!

I'm proud to announce the 1st official test release of RLIB 1.4

Features include:

* Parts
* Fixed and Flow Layouts
* Bold and Italics
* Language Improvements such as "eval"
* PHP Array input method
* More stability?
* Horizontal line's properties are more dynamic
* Break's newpage is dynamic (for Carol)

And much more!!

Please give it a go

Also.. I'm now looking for people to help fix the RLIB manual.  PLEASE
PLEASE PLEASE

You can download it from source forge

- bob

Re: [Rlib-users] Date formatting

[Bob D. <bd...@si...>]

You need to tell RLIB that it's a date before you do that

use stod(Remit.Sent)

stod = string to date

- bob

On Fri, 2004-11-12 at 14:35 -0700, Carol Fouse wrote:
> I'm still having difficulty with the date formatting.  (I did a
> work-around for the previous problem.)
> 
> I have a field called Remit.Sent.  If I print this field with %s as the
> format, I get 08/02/2004.  What I want is August 2, 2004, so I tried
> using format = "'%B %e, %Y'"  but I get nothing printed out.  If I use
> format = "'!@%B %e, %Y'" I get a 1, which isn't even part of the date.
> I could do a work around for this, also, which involves doing a query to
> the table, substringing the date parts, and using an array of month
> names to construct the date in a variable, which I would then put in the
> query that is passed to rlib.  But I really think these date formats
> should work.
> 
> - Carol
> 
> 
> Try the date formatting with out the !@
> 
> - bob
> 
> On Tue, 2004-10-26 at 16:53 -0600, Carol Fouse wrote:
> > Here's something that looks weird.
> > 
> > If I have
> > 
> > <field value="date()" format="'!@%d-%b-%y'"/>
> > 
> > I get 26-Oct-04.
> > 
> > But if I have
> > 
> > <field value="Year.FinUpd" format="'!@%d-%b-%y'"/>
> > 
> > where Year.FinUpd is "08/09/2004", I just get 2004.
> > 
> > If I just have
> > 
> > <field value="date()"/>
> > 
> > I get 10/26/2004, so my Year.FinUpd is in the same format as date(), 
> > so why do I not get the same result (except for the actual data)with 
> > the format string?
> > 
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by:
> Sybase ASE Linux Express Edition - download now for FREE
> LinuxWorld Reader's Choice Award Winner for best database on Linux.
> http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click
> _______________________________________________
> Rlib-users mailing list
> Rli...@li...
> https://lists.sourceforge.net/lists/listinfo/rlib-users

[Rlib-users] Date formatting

[Carol F. <cf...@eh...>]

I'm still having difficulty with the date formatting.  (I did a
work-around for the previous problem.)

I have a field called Remit.Sent.  If I print this field with %s as the
format, I get 08/02/2004.  What I want is August 2, 2004, so I tried
using format = "'%B %e, %Y'"  but I get nothing printed out.  If I use
format = "'!@%B %e, %Y'" I get a 1, which isn't even part of the date.
I could do a work around for this, also, which involves doing a query to
the table, substringing the date parts, and using an array of month
names to construct the date in a variable, which I would then put in the
query that is passed to rlib.  But I really think these date formats
should work.

- Carol


Try the date formatting with out the !@

- bob

On Tue, 2004-10-26 at 16:53 -0600, Carol Fouse wrote:
> Here's something that looks weird.
> 
> If I have
> 
> <field value="date()" format="'!@%d-%b-%y'"/>
> 
> I get 26-Oct-04.
> 
> But if I have
> 
> <field value="Year.FinUpd" format="'!@%d-%b-%y'"/>
> 
> where Year.FinUpd is "08/09/2004", I just get 2004.
> 
> If I just have
> 
> <field value="date()"/>
> 
> I get 10/26/2004, so my Year.FinUpd is in the same format as date(), 
> so why do I not get the same result (except for the actual data)with 
> the format string?
> 

RE: [Rlib-users] RE: formatting

[Bob D. <bd...@si...>]

You can do it

value="iif(something == 0, '', something)" format="iif(something == 0,
'', '%d')

On Tue, 2004-11-09 at 10:24 -0700, Carol Fouse wrote:
> I have seen a suppressblank in one of the examples for suppressing an
> entire blank line.  How about a suppresszero for a value. So that when a
> value is zero, a blank is printed instead?
> 

RE: [Rlib-users] RE: formatting

[Carol F. <cf...@eh...>]

I have seen a suppressblank in one of the examples for suppressing an
entire blank line.  How about a suppresszero for a value. So that when a
value is zero, a blank is printed instead?

Re: [Rlib-users] RE: formatting

[Bob D. <bd...@si...>]

!=

On Mon, 2004-11-08 at 17:06 -0700, Carol Fouse wrote:
> What is the symbol for not equal?
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by:
> Sybase ASE Linux Express Edition - download now for FREE
> LinuxWorld Reader's Choice Award Winner for best database on Linux.
> http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click
> _______________________________________________
> Rlib-users mailing list
> Rli...@li...
> https://lists.sourceforge.net/lists/listinfo/rlib-users

[Rlib-users] RE: formatting

[Carol F. <cf...@eh...>]

What is the symbol for not equal?