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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Query for order number of customer contacts
Hi, I'm a little bit stumped trying to put together a query that will list a customer Id, and the number of times their Id appears in the History table. I'm using two tables (simplified); Customers id Name History id CustomerId I tried the following query; SELECT... -
Ordering problem
Hi, I have two tables, one containing account details and the second containing the account history. I'm trying to pull the date the account was last updated along with the account details in a single query; SELECT a.id, a.contact_name, a.username, a.status, b.timestamp FROM accounts a... -
Looping through an object property containing an array
Hi, I have an object with a property containing an array, eg; --------------------------------------- #!/usr/bin/perl use strict; my $Obj = main->new; exit 0; sub new { my $class = shift; bless { property => ['zero', 'one', 'two', 'three'] }, $class; }... -
Changing the domain in the "From" header
Hi, Our MS guys have an exchange server configured with an invalid internal domain name[0]. All local exchange mailboxes forward to real-world corresponding mailboxes on our sendmail mailserver. The problem here, is that the "From" address will always show up as...- rawkin
- Thread
- Replies: 1
- Forum: Sendmail, Inc.: Sendmail
-
Sorting Arrays
Hi, I'm using an array of hashes to hold some data - a simplified example as follows; my @values; $values[0]{'name'} = "Bob"; $values[0]{'age'} = 41; $values[1]{'name'} = "Fred"; $values[1]{'age'} = 25; ... $values[25]{'name'} = "Joe"; $values[25]{'age'} = 38... -
Looping through properties of an object
Hi, I'm wanting to perform a series of regex's on a number of properties for an object. I've tried something similar to; # ------------------------ my $object = class->new("xxxxxx"); foreach my $field (@fields) { my $item = $object->{$field}; # .. then perform regex's on $item...
