I dont understand why this statement does not work. LOGOUT is a datetime datatype in MySQL.
SELECT LOGIN, LOGOUT FROM ACTIVITYLOG WHERE EMPLOYEENUM = 3170 AND JOBNUM = 1072 AND LOGOUT = NULL The record im looking for LOGOUT is blank when i look at it in MySQL Front. I would think this means the field is NULL, but i return no records when i run this query. I have tried LOGOUT = '' LOGOUT = 0 LOGOUT = 0000-00-00 00:00:00 none of these return the record im trying to return. Does DATETIME have a NULL value? ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
