Thought I’d give this plugin a try:
convert tStartDate from short system date to seconds
convert tEndDate from short system date to seconds
dbResetQuery
dbWhere "category", pItemName
dbWhere "date >=", tStartDate
dbWhere "date <=", tEndDate
dbOrderBy “date"
put dbGet(sq(tTableName)) into tTranData
tStartDate and tEndDate are in seconds.
The SQL generated is
SELECT * FROM ‘my table' WHERE category = :1 AND date <= :3 ORDER BY date
Why is it not including tStartDate?
Can anyone help?
Thanks
Terry
_______________________________________________
use-livecode mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
