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!

Register Log in
  • Congratulations strongm 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. gelboe

    SELECT DISTINCT statement

    thanks but i have already tried these methods, they work as you explain above but this is not the result i want. I want to select * columns but only under the condition of "email" being DISTINCT I have looked high and low and dont think this can be done, any further thoughts? thanks again gelboe
  2. gelboe

    SELECT DISTINCT statement

    I have a working select distinct statement that returns a recordset to ASP containing all records from my table, each record with a unique "email" value "SELECT DISTINCT email from myTable" However in addition the email address I also want all other columns of data in my recordset i.e. dob...
  3. gelboe

    virtusertable and remote recipients

    Hi, I have a mailbox setup on freebsd running with sendmail. I want to direct all mail coming into enquiries@mydomain.com to myName@hotmail.com I placed the following entry into the virtusertable file enquiries@mydomain.com myName@hotmail.com then i rebuilt the .db file and restarted...
  4. gelboe

    .lock mailbox

    Yeh, Ouch! The server and the accounts were setup by another administrator, I have recently taken over the server so I am not farmiliar with the disk usage and quota situation but I will take some time to sort it now i think. I have deleted the mailbox and all is well again. Thanks so much...
  5. gelboe

    .lock mailbox

    Hi, Thanks for this, it is all really helpful stuff. The only reason I think that the mailbox/allocated disk space is full is because the user of the mailbox has not ever! deleted a mail message from this box because they had not performed the action you described in Option 3 in your post...
  6. gelboe

    .lock mailbox

    Hi thanks for your help. I see how the lock file operates now. However I think the mail box for the "myMailBox" account is full and I need to delete a number of messages form this mailbox. I cannot login to the user account using SSH, I am using Putty for Windows and a soon as I enter the...
  7. gelboe

    .lock mailbox

    Hi, I have a pop3 mail box setup on freebsd. I can no longer connect to it to collect my mail and having looked on the server under the su account: /var/mail/ on listing the contents the following appears: mymailboxname mynailboxname.lock The mailbox has obviously been locked perhaps due to...

Part and Inventory Search

Back
Top