Re: (no subject)

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 [email protected] https://lists.sourceforge.net/lists/listinfo/rlib-users
-- 



-------------------------------------------------------------------------
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