Operand should contain 1 column(s) Error

[shogemuk]

Hi Guys,

I am trying to run the following script but I keep getting the following error Operand should contain 1 column(s)

 

UPDATE  x_orders

SET OrderStatus = 1

WHERE OrderID IN

(

SELECT    *

FROM        x_orders INNER JOIN

                      x_payments ON x_orders.OrderID = x_payments.OrderID

WHERE    (x_payments.PaymentComplete = 1) AND (x_orders.OrderStatus = 0))

 

 

Does anyone have any idea!

Thanks in advanced!!

[AyKay47]

remove the parenthesis from this line

 

WHERE     (x_payments.PaymentComplete = 1) AND (x_orders.OrderStatus = 0))

 

around your WHERE conditionals

[Muddy_Funster]

remove the parenthesis from this line

 

WHERE     (x_payments.PaymentComplete = 1) AND (x_orders.OrderStatus = 0))

 

around your WHERE conditionals

Why?

 

The problem is that the subquery is returning multiple fields, IN requires that a single field dataset is returned.  Don't use Select * in the subquery, only select the fild that you need for the comparison.

[shogemuk]

Thanks a lot for the help guys.  much appreciated

[The Little Guy]

Try this, it looks like you are missing a pair of parenthesis, and a limit

 

I am not sure if you can have a sub select inside of an in, but if you can I would assume it would look like this.

 

UPDATE  x_orders
SET OrderStatus = 1
WHERE OrderID IN(
(
	SELECT     *
	FROM         x_orders INNER JOIN
	x_payments ON x_orders.OrderID = x_payments.OrderID
	WHERE (x_payments.PaymentComplete = 1) AND (x_orders.OrderStatus = 0) limit 1
)
);

[Muddy_Funster]

Try this, it looks like you are missing a pair of parenthesis, and a limit

 

I am not sure if you can have a sub select inside of an in, but if you can I would assume it would look like this.

 

UPDATE  x_orders
SET OrderStatus = 1
WHERE OrderID IN(
(
	SELECT     *
	FROM         x_orders INNER JOIN
	x_payments ON x_orders.OrderID = x_payments.OrderID
	WHERE (x_payments.PaymentComplete = 1) AND (x_orders.OrderStatus = 0) limit 1
)
);

 

you didn't even read my post, did you?

[fenway]

Clearly not.

[The Little Guy]

of course I did... just not all of it