Forums Register Login

Hibernate Criteria for Subquery

+Pie Number of slices to send: Send
Hi,

Please help me to form a criteria for this query

UPDATE tickets
SET seller_cobrand = :arg1
WHERE id IN (SELECT T.id FROM tickets T, events E
WHERE
T.event_id = E.id AND
E.event_date > SYSDATE AND
T.SELLER_ID = :arg2 AND
T.quantity_remain > 0 AND
T.end_date > SYSDATE AND
T.system_status IN ('ACTIVE','INACTIVE'))
+Pie Number of slices to send: Send
Criteria can only be used for reading data, so there is noch way to do an update like the one you posted.
Could you hold this kitten for a sec? I need to adjust this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 1485 times.
Similar Threads
Game on SQL
How to extract current month and year's records alone
JDBC - Date
Need help in an query development
set value in part of parameter
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 03:42:15.