Re: Importing and Updating Non-Duplicate Records from 2 Tables

["IraMSN" <webforumsuser@xxxxxxxxxxxxxx>]

I noticed that after I posted the message.  MemberNumber is an INT. That is the 
way the other person originally set it up.

 It now updates the database and it doesn't bring in dups. It does however 
error out with an empty database or upon a second pass without any records 
needing updates. 

 Diagnostics: 
 Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]The DBMS 
returned an unspecified error. 
 The error occurred on line 10.

 This is line 10: and membernumber not in (<cfqueryparam list="yes" 
value="#valuelist(newsmember.membernumber)#" cfsqltype="cf_sql_integer">)

 I think it needs a CFIF to test for an empty membernumber. Can you please help 
me with this?

 Next it needs to determine if an existing members email address in the NetNews 
database has changed in Members and update the email address in NetNews. How 
can I do this?

 Thank you for the help. This has been a very easy "difficult" project and I am 
just burned out on the solution.