This is part of The Pile, a partial archive of some open source mailing lists and newsgroups.
From: coopl <coopl@ippc2.orst.edu> Subject: Re: Looking for Perl CGI to search and display a flatfile database Reply-To: coopl <coopl@ippc2.orst.edu> Organization: Dept. Entomology, OSU References: <8hgijf$6br$1@nnrp1.deja.com> <393D20CD.AE1CBA31@attglobal.net> Message-ID: <393E9ED9.522F2499@ippc2.orst.edu> Newsgroups: comp.infosystems.www.authoring.cgi Approved: Self-Moderation <authoring-cgi@boutell.com> NNTP-Posting-Host: 206.125.69.82 Date: 7 Jun 2000 12:13:35 -0600 X-Trace: 7 Jun 2000 12:13:35 -0600, 206.125.69.82 Lines: 48 X-Original-NNTP-Posting-Host: 204.157.220.254 Path: nntp.stanford.edu!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.cwix.com!natasha.rmii.com!nntp-cust.primenet.com!huge.aa.net!206.125.69.82 Xref: nntp.stanford.edu comp.infosystems.www.authoring.cgi:90269 I highly recommend DBI/DBD::Sprite and DB_Browser, http://www.summersault.com/software/db_browser/ DB_Browser will get you up and running in very little time. I think DBI:Sprite is much better than DBI:CSV because it is simpler, more self-contained, easier to use, and perhaps more standard with Oracle. It is newer, and not yet at CPAN, and not easy to find, so not many people use it yet. Find it at http://turnerville.virtualave.net/ DBD::RAM may be almost as good, it is also newish, but I have not tried it. Also, I have used a "SimpleDB" from Webtechniques, Apr 1998, by Paul Helinski, http://www.webtechniques.com/archives/1998/04/helinski/ which also works well but is less database- independant and does not use DBI or SQL, always a good thing to learn. Good Luck! : wawork@hotmail.com wrote: : : : : I'm looking for a perl program to search and display a flatfile : : database. I have a tab separated file of agency contacts. Using grep : : and sed I created a simply web program to search and display. Now I : : would like to go one step further and be able to search by field. : : : : Are there any free perl programs that can do search and display? We : : don't need any delete/add capabilities. : : The Perl modules DBD::CSV or Text::CSV would surely be of great : assistance in parsing such a file. -- Leonard Coop Dept IPPC & Entomology -- PLEASE NOTE: comp.infosystems.www.authoring.cgi is a SELF-MODERATED newsgroup. aa.net and boutell.com are NOT the originators of the articles and are NOT responsible for their content. You can SELF-APPROVE your first posting by writing the word 'passme' on a line by itself.