Ok, I did some digging online and found I can use the exists (or not exists) function, but one of the fields is text and the other is numeric (I didn't design the db and the people do not want it redone) So now I need to be able to convert one of them to match the other, but only while I am doing this process... Arg! This is turning out to be a big PITA mainly due to the db design
~~ Stephenie > |-----Original Message----- > |From: Beth F [mailto:[EMAIL PROTECTED]] > |Sent: Wednesday, October 16, 2002 1:49 PM > |To: CF-Community > |Subject: Re: Db merge question > | > | > |In is like in a list of items you specify > | > |You can do a join that shows all the items in table A where > |the id field in table B is null > | > |----- Original Message ----- > |From: "Stephenie Hamilton" <[EMAIL PROTECTED]> > |To: "CF-Community" <[EMAIL PROTECTED]> > |Sent: Wednesday, October 16, 2002 9:34 AM > |Subject: RE: Db merge question > | > | > |> Okies...i thought there was a function in sql called "In"...but I > |> can't seem to find any info on it... What do you guys > |suggest would be > |> the best way to determine which rows are in one tabe, but > |not another > |> table? Both tables have the same layout (fields, etc) > |> > |> ~~ > |> Stephenie > |> > |> > |> > |> > |> > |> > |-----Original Message----- > |> > |From: Stephenie Hamilton > |[mailto:[EMAIL PROTECTED]] > |> > |Sent: > |Wednesday, October 16, 2002 12:31 PM > |> > |To: CF-Community > |> > |Subject: RE: Db merge question > |> > | > |> > | > |> > |After I update the old db, I don't need the new one... > |> > |I need to make the old one match the new one and for > |some reason > |> > |the customer doesn't want the old one just replaced > |with the new > |> > |one... > |> > | > |> > |I think I am going to create a tmp table in the old db, > |then bring > |> > |in the data from the new db so I can then see what > |needs to be done > |> > |to the old db as far as delete/insert/update etc... That way > |> > |everything is in one dsn. > |> > | > |> > |~~ > |> > |Stephenie > |> > | > |> > > |> > |> --- > |> Outgoing mail is certified Virus Free. > |> Checked by AVG anti-virus system (http://www.grisoft.com). > |> Version: 6.0.401 / Virus Database: 226 - Release Date: 10/9/2002 > |> > |> > |> > | ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_community This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
