Thursday, November 20, 2008 ..:: Forums ::.. Register  Login
 Forums Minimize
SearchForum Home
     
  Mainstream Forums  Help  Subquery return...
 Subquery returned more than 1 value
 
jneumann
24 posts
Joined
3/10/2008
Subquery returned more than 1 value
Posted: 22 May 08 4:24 PM
I have a campaign that i have been using for the past couple of months and recently encountered a problem. If i try and remove a target list from the campaign i get an error that says "Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. The statement has been terminated." This only happens for this one campaign, in other campaigns i can remove them without a problem. I have found what stored procedure is called when you click to remove a target list, but cant figure out why it would break just for that one campaign. I thought the problem might reside in the Prospect_List_Campaigns table, but i dont see why more than one entry would come up.
support
2098 posts
1st
Joined
1/3/2006
Re: Subquery returned more than 1 value
Posted: 22 May 08 8:37 PM

I suspect that the problem in spPROSPECT_LIST_CAMPAIGNS_Delete is that we should be using an in clause with reference to the sub query.

Please contact our support directly staff for the fix.
 Page 1 of 1
NextPreviousNo Rating
  Mainstream Forums  Help  Subquery return...
Forum Home  Search       

Copyright (c) 2006-2008 SplendidCRM Software, Inc. All Rights Reserved.   Terms Of Use  Privacy Statement
DotNetNuke® is copyright 2002-2008 by Perpetual Motion Interactive Systems Inc.
SplendidCRM and SplendidCRM Software are trademarks of SplendidCRM Software, Inc. SugarCRM is a trademark of SugarCRM Inc. in the United States, the European Union and other countries. All other trademarks used in this web site are the property of their respective owners.