Let us assume you have tasks scheduled for a given day in a planner. You wish to select all tasks in the given day. The following query will serve the purpose (the DATE function does the trick)
select * from task where DATE(startdatetime) = DATE('2010-05-29');
For Ajax support when the date is selected using rich:calendar, we can add the following
<a:support event="onchanged" ajaxSingle="true" reRender="scheduleenddatetime">
<a:ajaxListener type="org.ajax4jsf.ajax.ForceRender"/>
</a:support>
Please note that the event is onchanged instead of onchange
I bought a Canon LBP2900B printer yesterday and successfully installed it in Ubuntu (10.4). I had 64 bit Ubuntu installed and hence downloaded the file http://codebin.cotescu.com/canon/lbp_driver/CanonCAPTdriver.tar.gz and executed the command sudo ./canonLBP_install.sh LBP2900 (LBP2900 is same as LBP2900B) after navigating to the directory where i extracted the tar file.
Further details can be found at http://radu.cotescu.com/2010/03/20/how-to-install-canon-lbp-printers-in-ubuntu/