Posts

Showing posts from 2012

Access Denied from Xp to win 7 64 bit Shared Folder

access denied and account disable when access win 7 64 bit folder from Windows XP Here The Solutions Create Standard User from win 7 64 bit and name computer has "mserver" example : user - myprog Type simple Password for user Myprog examples : 123456 Create Folder Name examples : myvfp and shared for everyone and full control access. After that DONE In windows XP type Name or Server \\mserver (your computer name) If appear windows Logon Type user : myprog and Password :123456 and you can meat folder myvfp (vfp folder) If not than your Windows XP have some Problem has say : account disable or something error access denied ..... Click Start Run .... type : control userpasswords2 goto Advanced - and Click - Manage Password Click Add Type Name of Server : mserver username : myprog password : 123456 Restart your Computer and DONE Enjoy... Send me email if you have some problem at elchan99@gmail.com Thanks for your attentions

Cross Table Update with MySQL

Using MySQL version 4.0 or higher you can update a table by joining two or more tables together; note that the examples shown in this article are not possible with MySQL 3.23 or earlier. By joining two tables together you can update one table based on fields in associated records in another table. Let's say for example you have a product table which stores information about products and a productPrice table which has pricing information and you want to update the prices based on when the product was created (in the examples below you want to discount all your older stuff to 80% of the current price). In MySQL you can do this in one of two ways. The first is do do a join using commas, like so: UPDATE product p, productPrice pp SET pp.price = pp.price * 0.8 WHERE p.productId = pp.productId AND p.dateCreated < '2004-01-01' The second way is to use inner join syntax as shown below. This syntax is slightly more flexible as it means you can use left and right joins as well