Then you could loop through the one table, convert the number to a string, compare and then if its there ignore, if its not add it.
----- Original Message ----- From: "Stephenie Hamilton" <[EMAIL PROTECTED]> To: "CF-Community" <[EMAIL PROTECTED]> Sent: Wednesday, October 16, 2002 9:51 AM Subject: RE: Db merge question > 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
