Search results for query: *

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

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

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 = '...

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

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

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

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

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

$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...

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

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

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

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!

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

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

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

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

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

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

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?