Ok,
I just tried the query using the sqlite command tool 2.8.12 and I
get no results, whereas if I use PHP5 with sqlite 2.8.11 I get the expected
results.
Can some one tell me why this is or what I am doing wrong?
----- Original Message -----
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
-----------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
