Re: Another Newbie Problem

Dina Hess wrote: Actually, any attempt to apply the word standard to the many flavors of SQL probably *is* questionable. :) Not at all. There have been official SQL standards since 1987. You seem to confuse the lack of conforming implementations with the absence of a standard. But I'm

RE: Another Newbie Problem

Rick... I'm relatively new to CF myself, but managed to develop a calendar app that does among other things, the two variable query you reference... keep in mind, the solutions are not always laid out nicely to see In the situation you reference (the month/year scenario), I set up a database that

RE: Another Newbie Problem

Thanks for the response and nice product, but we're dealing with a legacy db with thousands of records. Besides, while what you propose is certainly a work around, is this the most elegant or programmerly solution? Are there other ways of doing this?

RE: Another Newbie Problem

Here's how I would do it: Given two form variables, Form.dataMonth and Form.dataYear I would create the start and end dates and use those: cfset startDate=CreateDate(Form.dataYear, Form.dataMonth, 1) cfset endDate=CreateDate(Form.dataYear, Form.dataMonth, DaysInMonth(startDate)) cfquery

RE: Another Newbie Problem

: Another Newbie Problem Thanks for the response and nice product, but we're dealing with a legacy db with thousands of records. Besides, while what you propose is certainly a work around, is this the most elegant or programmerly solution? Are there other ways of doing

RE: Another Newbie Problem

Rick, Can you explain your situation a little more in depth? There are datepart() functions that allow us to compare parts of dates. Greg Sure, thanks for the interest. We have several thousand records in a db with a standard odbc datetime stamp column. We want to be able to filter

RE: Another Newbie Problem

Quoting [EMAIL PROTECTED]: We have several thousand records in a db with a standard odbc datetime stamp column. We want to be able to filter out end of month statistics (all trouble calls in November, 2002, for instance) by using a set of drop down menus (month, year, type of call).

Re: Another Newbie Problem

Sent: Wednesday, December 11, 2002 9:44 AM Subject: RE: Another Newbie Problem Quoting [EMAIL PROTECTED]: We have several thousand records in a db with a standard odbc datetime stamp column. We want to be able to filter out end of month statistics (all trouble calls in November

RE: Another Newbie Problem

Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 8:57 AM To: CF-Talk Subject: RE: Another Newbie Problem Rick, Can you explain your situation a little more in depth? There are datepart() functions that allow us to compare parts of dates

RE: Another Newbie Problem

Brillant! That did it. Thanks to all who assisted, particular Al. Rick -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 11 December, 2002 09:40 To: CF-Talk Subject: RE: Another Newbie Problem Here's how I would do it: Given two form variables

Re: Another Newbie Problem

Dina Hess wrote: Well, Jochem, has already given you some valuable information but since Month() and Year() are standard SQL functions Maybe they work in some non-standard implementation, but that does not make them standard functions. There is no reference to a Month() or a Year() function

RE: Another Newbie Problem

...but then that's just me. -Original Message- From: Luce, Greg [mailto:[EMAIL PROTECTED]] Sent: 11 December 2002 16:19 To: CF-Talk Subject: RE: Another Newbie Problem If you have a search form with a month select and a year selectbox. And you're searching for records with call_date

Re: Another Newbie Problem

10:49 AM Subject: Re: Another Newbie Problem Dina Hess wrote: Well, Jochem, has already given you some valuable information but since Month() and Year() are standard SQL functions Maybe they work in some non-standard implementation, but that does not make them standard functions