can ignore this .. sorted it .. thanks >>-----Original Message----- >>From: Jennifer Gavin-Wear [mailto:[EMAIL PROTECTED] >>Sent: 04 March 2006 16:33 >>To: CF-Talk >>Subject: OT: SQL Question >> >> >>using a "between": >> >>where getdate() between tbl.fromdate and tbl.todate >> >>i'm getting a problem using the getdate, says it expects a column >>whereas i >>want to use the getdate >> >>any ideas anyone please? >> >>thanks, Jenny >> >>-- >>No virus found in this outgoing message. >>Checked by AVG Free Edition. >>Version: 7.1.375 / Virus Database: 268.1.2/274 - Release Date: 03/03/2006 >> >> >> >>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234190 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54