Hi,

I have a complex query that I place into the SQL section and I get the result "no error", but no results... can DB Plumber take SQL like the following:

SELECT bi.ID,bi.Quantity,bi.Cost, BookingItemGroupID,abi.ActivityID,a.Name,abi.ScheduleID,s.StartDate,s.StartTime
FROM BookingItem bi, CourseBookingItem abi ,Activity a,Schedule s
WHERE bi.ClassName = 'CourseBookingItem' AND bi.ID = abi.ID AND a.ID = abi.ActivityID AND s.ID = abi.ScheduleID
AND bi.BookingItemGroupID IN (
   SELECT big.ID FROM BookingItemGroup big 
   WHERE big.BookingID = (
      SELECT ID FROM Booking WHERE OrderRefNumber = 'EGS200006'
   )
) 
ORDER BY bi.BookingItemGroupID ASC;

And if not, what would the limits be?

hi swaiba,

actually you can feed it any query you like cause it just passes it to the underlying db using your silverstripe db connection.

"no error" is a db plumber msg saying that your query is ok, it just didn't return any results apparently.

if you send me a test dump of your data as a pm or post simplified test data here i can have a look. (schema + data)

Oops - this was indeed no data - I'm sorry - may I suggest changing the message to 'no data' or similar to indicate this for people like me :)

you'r right, done. (r110932)

Many thanks apiening