10714 Posts in 2392 Topics by 1764 members
|Go to End|
16 September 2010 at 2:56am
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?
16 September 2010 at 12:31pm
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)
16 September 2010 at 9:05pm Last edited: 16 September 2010 9:05pm
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
20 September 2010 at 11:43am Last edited: 20 September 2010 11:44am
you'r right, done. (r110932)
21 September 2010 at 8:23pm
Many thanks apiening
|Go to Top|