It's all in your SQL statement in Net.Data.
You can see some examples on my site here:
http://dhart.no-ip.info/ndmac/netdata.htm
You also want to only return a few rows at a time.
Bringing thousands of records to a browser screen is not good.
--
Please send all requests for Datacenter services to SFDCserv@xxxxxxx
Remember, I can't provide a precise answer to a vague question.
--
Douglas Hart - Principal Consultant
Level 3 - System i (AS/400) Technical Support
ITT Corporation - Enterprise Infrastructure (EI)
Americas East Data Center - Seneca Falls, NY
Voice: 315-568-7568 Doug.Hart@xxxxxxx
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Peter_Vidal@xxxxxxxx
Sent: Monday, February 02, 2009 10:01 AM
To: web400@xxxxxxxxxxxx; midrange-l@xxxxxxxxxxxx
Subject: Net.Data and data filters
Good morning all!
I have a file of 173,000 records that I want to display for the clients and allow them to filter the data by the different columns involved. I wanted to use Excel but we have the row limitation of the 65,536 rows so I thought about a way to do it using the browser. Currently, I know that I can easily use Net.Data to display this but I want to have data filters like I will do in Excel. I also have the Net.Data subfile technique some of you have shared with us but I still do not have an example of how to do a data filter technique like in Excel. I guess I can use CGIDEV very easily but I have not been fully exposed yet to it and I do not want to code this in RPG.
Any EASY technique / way out to this?
TIA,
PETER VIDAL
MAPICS IT TECHNICAL SUPPORT TEAM / SR SYSTEM ANALYST 10540 Ridge Rd., Suite 203, New Port Richey, FL 34654-5111 Tel:727-849-9999, x2414 Fax:727-815-3120 WWW.PALL.COM
"The ability to focus attention on important things is a defining characteristic of intelligence."
Robert J. Shiller, Irrational Exuberance
--------------------------------------------------------------------------------
Attention:
This communication may contain information that is confidential, privileged and/or exempt from disclosure under applicable law.
If you are not the intended recipient, please notify the sender immediately and delete the original, all attachments, and all copies of this communication.
--------------------------------------------------------------------------------
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
This e-mail and any files transmitted with it may be proprietary and are intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in error please notify the sender.
Please note that any views or opinions presented in this e-mail are solely those of the author and do not necessarily represent those of ITT Corporation. The recipient should check this e-mail and any attachments for the presence of viruses. ITT accepts no liability for any damage caused by any virus transmitted by this e-mail.
midrange.com
