In all my cfm references I cannot find a single example of a common task, although you
see this kind of thing being used everywhere.
What I want to do is select from a pair of drop down lists (like Month and Year) and
then display only the records from November 2002, for instance.
How do you
firstyear#) and
(e.category=c.cat_no or e.category2=c.cat_no
order by event_no, firstyear
check out http://208.249.126.159/calendar/webcalendar_first.cfm
T
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 6:31 AM
To: CF-Talk
Subject:
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?
be locked in to just looking at a month:
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 11, 2002 6:31 AM
> To: CF-Talk
> Subject: Another Newbie Problem
>
>
> In all my cfm references I cannot find a s
: 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 way
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 o
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).
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 trou
L 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.
Greg
Sure, thanks for the interest.
We have severa
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 vari
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
ement...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
Sent: Wednesday, December 11, 2002 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
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
14 matches
Mail list logo