Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Haishen
-
How to set amount of pages when printing (from[] - to[])
Hi! I have a somewhat irritating problem. I´ve implemented Printable on a class that i wish to print, it can print the amount of pages that is interresting by render the graphics with an offset depending on pageIndex in the print() function (in other words I dont implement Pageable). But how... -
Exchange a subselect with appropriate syntax in mySQL
To Bromrrrrr!!! Sorry man, I was dead wrong...the code worked perfectly...thank you! // Kowalski -
Exchange a subselect with appropriate syntax in mySQL
Thanx Bromrrrrr for your suggestion, but unfortunately it semms to return all objects in the table... ...hmmm either I get some clever solution to this or i'll simply have to loose my face and re-write into two Queries :) !!! Thanks a bunch anyway! // Haishen -
Exchange a subselect with appropriate syntax in mySQL
Hi! I just can't figure out how to re-write this Query so that it fits mySql, can someone plz help me!!! SELECT * FROM Object WHERE name NOT IN((SELECT objectName FROM Booking WHERE startDate >= ? AND startDate < ? OR stopDate > ? AND stopDate <= ? OR startDate <= ? AND stopDate >= ?)) Obove...
