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 use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode