Thread: [Rlib-users] (no subject)

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Saludos

Enrique Molina C=E1rcamo
Grupo Inabox, c.a.

Hi! I have a qustion! How can I compile rlib with
mysql and python! 

Discover Yahoo! 
Use Yahoo! to plan a weekend, have fun online and more. Check it out! 
http://discover.yahoo.com/

What distro are you running?

Make sure you have packages like "python-devel" and mysql-devel
installed

So RLIB can find them during autoconf

- bob

On Thu, 2005-05-12 at 08:07 -0700, Dimitar Balinov wrote:
> Hi! I have a qustion! How can I compile rlib with
> mysql and python! 
> 
> 

Hi,
  I'm having problems in executing and displaying more than 2 sql
queries. I want to generate two report tables. I have a table in my
mysql named clean. Which have following structure.

ID : STATUS : DATE : TIME: IP : from : to

I want to split tables based on the status field. The queries I'm executing are:
1.   SELECT * FROM clean WHERE status = 'sent'
2.   SELECT * FROM clean WHERE status = 'recv'

The output which I'm trying to get is:
______________________________
Sent
---------------------------------------------------
rows here...
____________________________
Recv
------------------------------------------------
rows here...

I've attached all the files and mysql dump. Kindly If any can guide me
how can I solve this scenario, I'll be very thankfull to you.

Thanks.

-- 
Hameed U. Khan
Registered Linux User #: 354374

"Beware of programmers who carry screwdrivers."

Are you trying to concatenate 2 reports or do you really want one report
w/ breaking around the status field?

- Bob 

On Fri, 2006-08-11 at 20:37 +0500, Hameed U. Khan wrote:
> Hi,
>   I'm having problems in executing and displaying more than 2 sql
> queries. I want to generate two report tables. I have a table in my
> mysql named clean. Which have following structure.
> 
> ID : STATUS : DATE : TIME: IP : from : to
> 
> I want to split tables based on the status field. The queries I'm executing are:
> 1.   SELECT * FROM clean WHERE status = 'sent'
> 2.   SELECT * FROM clean WHERE status = 'recv'
> 
> The output which I'm trying to get is:
> ______________________________
> Sent
> ---------------------------------------------------
> rows here...
> ____________________________
> Recv
> ------------------------------------------------
> rows here...
> 
> I've attached all the files and mysql dump. Kindly If any can guide me
> how can I solve this scenario, I'll be very thankfull to you.
> 
> Thanks.
> 
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________ Rlib-users mailing list Rli...@li... https://lists.sourceforge.net/lists/listinfo/rlib-users
-- 

Then you really want one query (order by your status) and you want to
use rlib breaks.

- Bob

On Fri, 2006-08-11 at 21:40 +0500, Hameed U. Khan wrote:
> I want to break around the status field.
> 
-- 

Thanks Bob. Thank you very much. But there is one more querstion.
Suppose I have one more table in my database with same structure name
spam. Now I want to start spam's report from new page or after clean
has finished. In this case what I should do?

On 8/11/06, Bob Doan <bd...@si...> wrote:
> Then you really want one query (order by your status) and you want to
> use rlib breaks.
>
> - Bob
>
> On Fri, 2006-08-11 at 21:40 +0500, Hameed U. Khan wrote:
> > I want to break around the status field.
> >
> --
>
>
>

-- 
Hameed U. Khan
Registered Linux User #: 354374

"Beware of programmers who carry screwdrivers."

On Sat, 2006-08-12 at 10:34 +0500, Hameed U. Khan wrote:
> Thanks Bob. Thank you very much. But there is one more querstion.
> Suppose I have one more table in my database with same structure name
> spam. Now I want to start spam's report from new page or after clean
> has finished. In this case what I should do?

You would add 2 queries and 2 reports before you call execute.  In the
main <Report> tag your would specify a query="name" of the query for the
report.

- Bob

> 
> On 8/11/06, Bob Doan <bd...@si...> wrote:
> > Then you really want one query (order by your status) and you want to
> > use rlib breaks.
> >
> > - Bob
> >
> > On Fri, 2006-08-11 at 21:40 +0500, Hameed U. Khan wrote:
> > > I want to break around the status field.
> > >
> > --
> >
> >
> >
> 
> 
-- 