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 Chriss Miller 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: *

  • Users: 999Dom999
  • Content: Threads
  • Order by date
  1. 999Dom999

    How to restore emails with DOAS enabled?

    My usual way of restoring emails was: Restore mail file to a different location, rename it. Open current and renamed mail files in Domino Admin Copy and paste the emails that were needed. Now I have DOAS, I have to do the same as above but copy it into the mail folder of the domino server due...
  2. 999Dom999

    Weird string problem

    I'm creating a query its long so I won't post it all but this part in question. $first = date('Y-m-d', mktime(0, 0, 0, 10, 1, $y)); $last = date('Y-m-t', mktime(0, 0, 0, 10, 1, $y)); $dateQuery = " ITRAN.IT_DUE >= { d '$first'} AND ITRAN.IT_DUE <= { d '$last'} AND "; So $dateQuery outputs...
  3. 999Dom999

    Combine 2 queries

    I'm simplifying my actual queries, but hope this gets across what I'm trying to do, here goes: QUERY 1 SELECT SA_MODEL,SALES_QTY FROM SALES RESULT MODEL SALES QTY ABC123 5 ABC124 5 QUERY 2 SELECT OUT_MODEL,OUT_SALES_QTY FROM TRANS WHERE IT_STATUS = 'A' AND IH_CREDIT = ' AND IH_STKSAVE = '...
  4. 999Dom999

    Summing problem

    I'm creating a web reporting app using PHP and connect to our VFP9 database with MS OLE DB Provider for VFP9. I was previously using ODBC but it couldn't do embedded select statements so switched to OLE DB which has more functionality but I'm getting problems with the exact same query that...
  5. 999Dom999

    Combining 2 table results

    I have 2 tables with identical columns names. I have model numbers in each that I want return and if they are in both tables I want them to sum. I tried to use union but it just added the same model number twice. Any ideas how to achieve this below: Table 1 --------------- Model quantity...
  6. 999Dom999

    Need to Order By SUM'd value

    Here is my statement SELECT SNAME.SN_TERRTRY, SLOOK.LK_DESC, SUM(SANAL.SA_QTY),SUM(SANAL.SA_COST),SUM(SANAL.SA_TRVALUE) FROM SANAL INNER JOIN SNAME ON SANAL.SA_ACCOUNT = SNAME.SN_ACCOUNT JOIN SLOOK ON SLOOK.LK_CODE = SNAME.SN_TERRTRY GROUP BY SNAME.SN_TERRTRY ORDER BY ???? I want the sort...
  7. 999Dom999

    Remote desktop over vpn behaves different to over LAN

    I can't quite get my head around this. The problem is poor connectivity between servers when using remote desktop over a VPN but fine when over a LAN. This has only just started happening. I have a terminal server windows 2003, on this we run a Pegasus Opera client from another 2003 server both...
  8. 999Dom999

    Need to replicate mail files between servers

    We have one main mail server, then a blackberry server and a new remote office server. All 8.5.1. I moved the mail file from the main mail server to the new remote office server. All working great. One user has a blackberry this syncs his address book within his mail file (inotes) with the...
  9. 999Dom999

    return the last ten entries, in decending order

    $row_count = mysql_num_rows(mysql_query("SELECT id FROM en_news"))-10; $query= "SELECT id,date,title FROM en_news LIMIT $row_count ,10"; Above is the solution of the first part of the question but I want the last entry to display first. I tried: $query= "SELECT id,date,title FROM en_news...
  10. 999Dom999

    8.5.1 released Traveler support for Iphone

    The much awaited 8.5.1 is here. Just got it installed and iphones set up. Works great and may make my blackberry redundant. Was so easy to set up especially on the iphone itself. Has anyone else done this as I have a few questions: So far it doesn't appear you can accept a calendar...
  11. 999Dom999

    Record Locks, how to implement?

    I have created a product database which will now be used by many people. The problem is if 2 people are editing a record then one will lose information when the second submits. The main problem with locking records is if some edits then closes the page it remains locked. I have searched around...
  12. 999Dom999

    IE7 will not print properly beyond page 1

    Please view this in IE7 http://www.project999.co.uk/boxes.html My internal product database fills these boxes on a search results page. I have been trying to make them print out properly. I changed the float:left for: float:none ! important; display:inline ! important; This made them...
  13. 999Dom999

    Regex help

    I really need to get my head around regex but in the meantime please can someone help me with a validation form I need this line to change so that it matches all punctuation except for these 3 characters "&", "'" and "/" var illegalChars= /[\(\)\<\>\,\;\:\\\"\[\]]/ ; Cheers!
  14. 999Dom999

    Moved mail file can't move back

    Short version - Mail file moved to server, then moved back but the server it moved to still thinks its there and delivers emails to it. In domino admin for both servers it says the right server in my person document. Is there somewhere else that tells the server where the mail file resides...
  15. 999Dom999

    Export Database data

    Is there a way to export all data to text or csv file? We have a notes product database, it does have an export to csv facility built in, but it doesn't output all the fields, description being a main one. I'm in the process of writing a new product database and I want to import the old data...
  16. 999Dom999

    DSBL.ORG listed my server but site is down? How do I unlist?

    What a completely irresponsible service to block my server and not have a website running to unlist. My server is not an open relay or been used for spam so no idea why I am on it in the first place. Apparantly spam cop uses this list by default and we are getting loads of email rejections...
  17. 999Dom999

    Archiving best practice?

    Even though we now have bigger disks we get huge amounts of emails with large attachments. Everyone are too scared to delete any emails and the 2gb mail file limit is now out the window with some now getting to 10GB+. We have one server and about 60 users with email. I have set up archiving on...
  18. 999Dom999

    Footer and browser issues

    Here is what I'm working on http://www.zeonltd.co.uk/zeon/ If you restore down the browser or the low resolution adds a scroll bar when you scroll up and down the footer doesn't automatically adjust to the bottom of the screen. #footer { position: absolute; bottom:0px; clear: left...
  19. 999Dom999

    Deleted user by mistake any way to recover quickly??

    Hit delete on the wrong user, still have their mail file. Is it best to recreate the user and attach it to the existing mail file, or an easy way to undelete??
  20. 999Dom999

    BES userlist blank after upgrade to 4.1.4

    Running Domino upgraded from 4.0 to 4.1.4 all seemed to be good, ran for a few months, then tried to add a new user for the first time. When you click on "add user" the list is blank no server at the top and no users. Any ideas?

Part and Inventory Search

Back
Top