I have a query which successfully runs on PHP5, which I beleive has sqlite 2.8.11 embedded, but run it in sqliteplus (windows GUI using 2.8.12) it does not return any results. I have check with eZtools the provider of Sqliteplus and they can not find fault with their program. Is there any differences in these to versions which would stop the following query returning results.
sql-------------------------------------------------------------------------------------- SELECT C.extn_no AS extn_no, dest, dest_name, call_time, duration, cost, firstname, surname FROM call_data as C INNER JOIN users as U on C.extn_no = U.extn_no WHERE '1' = '1' AND call_time >= '2004-12-12 00:00:00' AND call_time <= '2004-12-12 23:59:59' AND direction = 'Out' AND U.user_id IN (SELECT user_id FROM grp_user WHERE group_id = '1') LIMIT 0,1 ------------------------------------------------------------------------------------------