Rick, I do not know what database you are using but your posted example is different than what I posted up. You have a where clause after the paranthesis'd section for your inserted values where the method I use is to use a sub-query within that section. I think your placement of the where clause is the root of your problems but depending on what database you are using the ultimate syntax to do what you want to do might vary.
On Fri, May 16, 2008 at 10:04 AM, Rick Faircloth <[EMAIL PROTECTED]> wrote: > Thanks for the reply, Aaron, but the CF app log > is saying there's an error with "not exists" or "not in"... > > So, the problem is definitely in that part. Just got to find > the right syntax. > > I've always used "not in" in subqueries, but never used (that I can > remember) a subquery inside an insert query. > > > > > -----Original Message----- > > From: Aaron Rouse [mailto:[EMAIL PROTECTED] > > Sent: Friday, May 16, 2008 10:58 AM > > To: CF-Talk > > Subject: Re: What's wrong with this query? > > > > When I have done this, I used a NOT EXISTS, so something like this random > > example I just pulled from Google: > > > > http://archives.postgresql.org/pgsql-general/2003-06/msg01683.php > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305428 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
