Newbie Select Problem URGENT

2001-03-08 Thread Ken Tuck
ure%') AND (listings.location LIKE '%AutoEmail.location%')) AND ((AutoEmail.residential = listings.residential) OR (AutoEmail.multi = listings.multi) AND (AutoEmail.farm = listings.farm) OR (AutoEmail.waterfront = listings.waterfront) OR (AutoEmail.commercial = listings.commercial) OR (Aut

Re: Newbie DATESTAMP problem

2001-02-27 Thread Ken Tuck
mall book on a big subject". What I was attempting to do was display the information on a "What's New" webpage for up to 36 hours and 168 hours. I fiddled with the timestamp values and it appears to be working fine. Cheers Ken Tuck Rolf Hopkins wrote: > Hi Ken, > > W

Newbie DATESTAMP problem

2001-02-26 Thread Ken Tuck
(date_sub(now()+0, interval 7 DAY)) && (kawarthas.agent1aid=Customer.MemberID) ORDER BY price;"); } -- Cheers! Ken Tuck EyeCreate Inc. Net~Solutions Design - Hosting - E-Commerce [EMAIL PROTECTED] http://www.eyecreate.net/ ph: 705 755-1120 fx: 705 743-9259