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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. aalnaif

    Excel: Selecting an adjacent column based on value of previous column

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

    Excel: Selecting an adjacent column based on value of previous column

    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 |...
  3. aalnaif

    Automatically Deleted Files on Local Drive

    I forgot to mention that I am using Windows XP.
  4. aalnaif

    Automatically Deleted Files on Local Drive

    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.
  5. aalnaif

    AND Gate Filtering Sequence in MySQL

    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...
  6. aalnaif

    History Table

    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?
  7. aalnaif

    Deleting rows faster than filtering rows

    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...
  8. aalnaif

    Bash mail not working

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

    Bash mail not working

    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.
  10. aalnaif

    Selecting the correct row in a table which records changes

    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...
  11. aalnaif

    Bash mail not working

    /etc/mail/mailertable is an empty file
  12. aalnaif

    Bash mail not working

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

    Bash mail not working

    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]...
  14. aalnaif

    Bash mail not working

    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...
  15. aalnaif

    Bash mail not working

    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...
  16. aalnaif

    Importing a constant value using mysqlimport

    Thanks elsenorjose! That fixes it!
  17. aalnaif

    Importing a constant value using mysqlimport

    Sorry, I meant to say that having all 4 columns included in a unique key means that 2 rows (not columns) cannot have the same combination of all 4 columns.
  18. aalnaif

    Importing a constant value using mysqlimport

    I have a tab-delimited .txt file with 3 columns, which I want to import into a table with 4 columns. All of the table's 4 columns are included in a unique key. The .txt file looks like this Bob Billy 23945 Adams John 34535 Smith Chris 34593 The column headings for the...
  19. aalnaif

    MySQL Storage

    This might be a Linux question, as it has to do with where MySQL stores its database tables when you install it in a Linux based OS (Cent OS). I want to put the MySQL tables and database information on a separate hard drive. I'm thinking the easiest way to do this is to mount the folder where...
  20. aalnaif

    Bash scripting - using variables in MySQL queries

    Thanks for all your advice... it works now after adding the quotes as Tony suggested. I also changed the datatype to date. Tony, I can't believe I missed where 1989 came from.

Part and Inventory Search

Back
Top