So your users need access to Exchange and data from outside your organisation. Sure you can set up RPC over HTTPS and various other tools to access the data. I just find OpenVPN very good, convenient and reliable. And after battling to find a good simple HOWTO, I put this together. It’s a quick and [...]

Question: I am trying to create a form where I can cut an paste records in a textarea and submits each record as new row in mysql. Example: I have records such like this. —- Toyota Honda BMW —- I would like to copy the text and paste it in a textarea then hit submit.  [...]

AIDE (Advanced Intrusion Detection Enviornment) is a tool to check the file integrity. It is an opensource substitute for TRIPWIRE. It allows to take snapshots of all the major configuration files, binaries as well as libraries stats. And helps to find which binaries have been changed in case of compromisation of the system. This can [...]

Question: I need to be able to copy one file to multiple directories, the only problem is the multiple directories have item that is unknown. So I have a file that is located in c:\folder1\somefile.txt I want to copy this file to the users home directories: \\server\homes\user1\folder1\ \\server\homes\user2\folder1\ \\server\homes\userA\folder1\ \\server\homes\userX\folder1\ \\server\homes\user5\folder1\ ….. Everything is the [...]

Question: Hi, I have an issue with an ASP.NET web page that has been developed to log people into an external application. Assuming we open IE and have all cookies, internet files and cache cleared, and enter the address of the website it works correctly and performs its function. If I close IE and reopen [...]

Question: I have to update my mysql db. I have to update a  field if it matches 1 of 184 zipcodes. I have a list of zipcodes but dont have any idea of how to created the statment. UPDATE `cart`.`cart_cust` SET `s_county` = ‘2′ WHERE  (zipcode could be one of 184) Solution: UPDATE `cart`.`cart_cust` SET [...]

Question: I’m using MySQL 5.1, and I’m trying to calculate a percentage. Basically, I have a huge database with all the information regarding projects. What I’m trying to do is the following: all the user requirements are stored in the database. Some of them will be implemented through configuration and others through development. I’m trying [...]

Question: I have 2 tables.. tblDetails HFID | TID | Grade ——————– 1040 | 1 | NULL 1040 | 2 | NULL 1040 | 2 | NULL 5670 | 3 | NULL 5670 | 4 | NULL 8879 | 5 | NULL tblMain TID | DPI ————– 1 | 3.4 2 | 5.6 3 | [...]

Question: Hi, I have a text input box for users to leave messages. I have noticed that if one of them uses an ampersand the rest of the text is cut off and not stored in the database. I have tried many things like mysql_real_escape_string() and encodeURI but nothing solve the problem. What can I [...]

VPNs (virtual private networks) aim to provide secure communications within distributed enterprises, among business partners, and between mobile workers and corporate IT resources. VPNs make use of the public Internet, and for that reason, advocates view the technology as more cost-effective than dial-up networking — with its attendant phone-line costs — and dedicated WANs. To [...]