User Profile

ComputerTechie · Jan 27 '12, 11:57 AM

I cam up with the following solution.

Code:

SELECT customers.`First Name`,customers.`Last Name`,customers.idcustomer,scrub.idscrub,scrub.`First`,scrub.Last
FROM customers ,scrub
WHERE customers.`First Name` = scrub.`First` AND customers.`Last Name` = scrub.Last
ORDER BY customers.idcustomer  



DELETE FROM customers c
WHERE EXISTS (SELECT 'X' FROM scrub
WHERE c.`First Name` = scrub.`First`

...

ComputerTechie · Jan 26 '12, 01:28 PM

lgm001,

You need to test what you wrote. it does not work but i did come up with a solustion that i will post. soon.

CT

ComputerTechie · Jan 25 '12, 01:46 PM

Sorry i did post the older code here is new line

Code:

if (holder2.equalsIgnoreCase(holder1) && holder2a.equalsIgnoreCase(holder1a))

as for the compare you can not as for are i know use = and have to use .equals

Code:

if (holder2.equalsIgnoreCase(holder1) && holder2a.equalsIgnoreCase(holder2)){

CT

ComputerTechie · Jan 25 '12, 12:29 PM

i would get another harddrive such as usb hard drive then boot off a linux live and copy them to the usb hard drive then reinstall os.

there are several linux live cd on the internet.

CT

ComputerTechie · Jan 25 '12, 12:26 PM

what antivirus software is on each server comes to mind.

have you tried a 3 party pdf viewer like fox reader?

CT

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Compare Two DataBase