| Subject: | Re: Importing and Updating Non-Duplicate Records from 2 Tables |
|---|---|
| From: | "paross1" <webforumsuser@xxxxxxxxxxxxxx> |
| Date: | Wed, 20 Feb 2008 20:04:18 +0000 (UTC) |
| Newsgroups: | macromedia.coldfusion.database_access |
Just add a [b]<CFIF qryMember.recordcount NEQ 0></cfif>[/b] around your CFLOOP, so if qryMember doesn't return any rows, you don't do any inserts. Phil |
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| ||
| Previous by Date: | Re: Importing and Updating Non-Duplicate Records from 2 Tables, Dan Bracuk |
|---|---|
| Next by Date: | Re: Importing and Updating Non-Duplicate Records from 2 Tables, IraMSN |
| Previous by Thread: | Re: Importing and Updating Non-Duplicate Records from 2 Tables, Dan Bracuk |
| Next by Thread: | Re: Importing and Updating Non-Duplicate Records from 2 Tables, IraMSN |
| Indexes: | [Date] [Thread] [Top] [All Lists] |