Debugging with clients, SQL in and exist, and IE cache Problems

1. How can I work with the client on the server?

The procedure is as follows:

A. Release the first version of the project on the local IIS and cannot be changed later.Code, Must be consistent with the released code on the machine.
B. Tell the client the IP address of the Local Machine for the client to call. (Not localhost)
C. If the program is not running: DEBUG = "additional process =" check all processes = "and append w3wp processes.

2. SQL statement in

Example

Update t_org_cap set isactive = 'n' where contactname in (select cname from t_org_contact where isactive = 'n ')

If you write an exist statement, yes

Update t_org_cap set isactive = 'n' where exists (select cname from t_org_contact where cname = t_org_cap.contactcname and isactive = 'n ')

3.ProgramIt took four hours to solve a bug. In view, Ajax calls the Controller method, but fails to get in after the breakpoint is set. The strange thing is that the Ajax success callback function is successfully executed. This problem does not occur in chrome. Finally, after consultation and discussion, I found that the reason is that the IE cache will invalidate Ajax. A search is a classic problem that many people have encountered. Solution: Add a random parameter to the Ajax call URL.

4. It took another half a day to work with the client. Finally, a bug was found: it is dangerous to use the "=" symbol to compare the datetime type. Because "=" compares the Tink value of datetime, rather than the literal value. The solution is to write the dt1.tostring. Equals (dt2.tostring) method to be equal. For comparison, use ">" and "<.