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

Microsoft on Thursday issued a cumulative critical patch for Internet Explorer that fixes eight vulnerabilities, including a hole targeted in the China-based attacks on Google and other U.S. companies. The security update is rated critical for all supported releases of IE 5, 6, 7, and 8, according to the advisory. The more severe vulnerabilities could [...]

Google (Nasdaq: GOOG) is reportedly looking into the possibility that one or more staff members at its office in China helped enable the attack on its infrastructure in mid-December. After the attack was discovered, some Google China employees were denied access to internal networks, while others were put on leave, and still others were sent [...]

Question: I created a mysql/php ssystem. There is one table and I am using the auto increment feature. In most case the record inserts correctly but there are case where the record does not insert. Could this be because the auto increment does not always work correctly and if it doens’t the mysql call fails. [...]

Question: Experts, how do I use the replace function to replace an Enter key stroke with a space or a carriage return with a space.  I need to use the ascii equilavent correct?  Here is what I tried and its not working select Replace(bt.View_Status,’^M CR’,”) from bit_rec_item bt Solution: Try this select REPLACE(REPLACE(bt.View_St atus, CHR(10), [...]