hi,
hmm i guess it should be
select CORFNBR, CODATE, COTIME, CONAME, CODESCR, COSPEAKER, COSPECIAL
from CONFERENCES, SPEAKERS
where CORFNBR IN (#ValueList(getconfnumbers.RCCORFNBR)#)
and COSPEAKER = SPRFNBR
and month(conferences.CODATE) >= #nextMonth#
----- Sabrina -----
----- Original Message -----
From: Erika L Walker
To: CF-Talk
Sent: Thursday, May 10, 2001 7:45 AM
Subject: SQL help, pretty please...
Some pointing in the right direction please....
I generate an email based upon a user's attendance of a conference on a
particular day. The email is going to tell the user when the next conference
is.
I pull a list of all conferences.
<!--- Set up the next month criteria --->
<cfset nextMonth = (DatePart("m", now()) + 1)>
Here is my SQL statement:
select CORFNBR, CODATE, COTIME, CONAME, CODESCR, COSPEAKER, COSPECIAL
from CONFERENCES, SPEAKERS
where CORFNBR IN (#ValueList(getconfnumbers.RCCORFNBR)#)
and COSPEAKER = SPRFNBR
and month(conferences.CODATE) = #nextMonth#
Works great if there is a conference in June (for next month).
But not if the next conference is in say, August.
So,.. I can't see the light here....it's on the tip of my brain, but I'm
having trouble figuring it out. I need to loop through an index of nextMonth
until it matches a month in the conference list, right?
Am I thinking in the right direction?
Signed,
Going Loopy. (yeah, yeah, yeah, I already am!)
Erika
(with a *K*)
-----------------------------------------------------
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
