Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Grouping and Page Breaking
Basic report generating question. I have a dataset that I would like to sort, group, and print all fancy like. The kind of basic report one could generate with MS Access. Field names are: Name - Name of person who owns record Sname - First Last Name Address - 1313 Mocking Bird Lane City -... -
Complex Sort
What I would like to do is iterate through the file sorting on the ZIP field, evenly distributing the records through out the file. Example if my file contains the following quantities of zip codes. QTY ZIP 3 98765 2 12345 2 78934 Then my file would be sorted somewhat... -
DBI Number of Rows Changed
Quick question on DBI. Using the following example code. my $sql = qq{ UPDATE table set field1 = "A" WHERE field2 = "" }; $dbh->do( $sql ); What would I need to do to return the total number of records that were changed? Thank you. FL -
Using Perl to Crunch Numbers in a SQL Table
It has been quite some time since I have had to code anything, and I am at a complete loss of where to start. I do have notes from long ago about making a connection to my database. But past that I just don't know where to begin or how to approach this problem. I need to produce a report based... -
Calendar Dates for SQL Lookup
I am going to attempt to create a Perl script to handle calculating reoccurring call statistics for an inbound call center. I am very new at Perl and am hoping to use all of you fine people as a sounding board to make sure I am going down the right path. Each day a table is created in a SQL...
