Recent content by aalnaif

Thanks Matt, That's exactly what I was looking for!

Hi, I know the title is confusing, but I have a column in which all rows are zero except one, which is equal to "1". I would like a formula to set a cell equal to the next column in that row (which is equal to 1). For example, take the following data (seperated into two columns): 0 | Bob 0 |...

I forgot to mention that I am using Windows XP.

Hi, I'm at work, and I left my computer to go to eat lunch. For some reason, when I returned all of my files in My Documents on my local drive were automatically deleted. Does anyone know why this could have possibly occured? No one else had access to my computer while I was gone.

I was wondering about the filtering sequence that MySQL performs on AND gates. For example, consider the following query: select * from expl_table where ColA > 30 and ColB < 15; Does MySQL first select rows where ColA > 30, and then further filter the resultset for ColB < 15, or does it...

I want a mechanism for recording the history of our employees' salaries. Using this mechanism, I should be able to easily obtain a salary given an employee's ID and a date. Any suggestions?

I am creating a temporary table which is simply a copy of two tables joined together, excluding rows which meet a certain criteria. For some reason, it is much faster for me to make a full copy of the joined tables, and then delete from the table the rows which meet the criteria, than it is to...

Do I have to initialize, set up, or configure sendmail in any way, or should it just work?

Yes I am sending email to the Network Solutions domain, but I am directly connected to the internet, so I don't want to use a relay. I just want to send mail directly.

I have an "employees" table which records which department each employee has worked in, and the date that each employee started working in their departments. Since it is possible for an employee to change departments, a single employee can have several records in this table. For example...

/etc/mail/mailertable is an empty file

Is there a way not to use the mail.networksolutionsemail.com relay?

I am running Linux Fedora Core 5. I re-installed sendmail, and then restarted the sendmail service, and then ran the script shown in my first post again. But username@domain.com still isn't receiving the email. Here is what I see in the maillog now: Mar 31 10:16:25 localhost sendmail[19026]...

When I run tail -f /var/log/maillog, I see: Mar 30 10:21:38 localhost sendmail[7919]: 12UGLcmM007919: from=local_user, size=55, class=0, nrcpts=1, msgid=<200703301621.12UGLcmM007919@localhost.localdomain>, relay=local_user@localhost Mar 30 10:21:38 localhost sendmail[7919]: 12UGLcmM007919...

I wrote the following simple bash script to send mail: #!/bin/bash SUBJECT="testsubj" EMAIL="username@domain.com" EMAILMESSAGE="/tmp/emailmessage.txt" echo "testbody">$EMAILMESSAGE /bin/mail -s "$SUBJECT" "$EMAIL" < $EMAILMESSAGE The script runs fine (no errors are returned), but...