Thanks Rudy. Blessings,
Graham ----- Original Message ----- From: "rudy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 11, 2002 12:16 PM Subject: Re: [CFTALKTor] grouping birthdates by month > > I noticed that the SQL syntax was from MySQL-- > > would it be different for Access2000? > > yes > > that's the nice thing about standards, there's so many to choose from > > with regard to dates, sql syntax is different in almost every database > > for example, a database may implement the sql standard INTERVAL data type > and allow its use in sql syntax -- or not > > ms access has a similar function to mysql's -- DateAdd > > not sure the access WHERE clause has that same neat trick about turning a 0 > into false, though, so you should use the access IIF() function instead > > > rudy > > - > You are subscribed to the CFUGToronto CFTALK ListSRV. > This message has been posted by: "rudy" <[EMAIL PROTECTED]> > To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ > Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ > This System has been donated by Infopreneur, Inc. > (http://www.infopreneur.net) > - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Graham Faulkner" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
