hi Sorry for that and for the post that are doubled it seemed to me that it's
not posting because it took a while to see it so i resent it again many
times...
anyway the startyear and eventmonthstart comes from a <cfset> i declared before
the query which takes the datepart("yyyy", startdate) and datepart("m",
Startdate) so the query would be this if it would go right
<cfquery name="GetEvents" datasource="sql1">
SELECT *
FROM GetEvents
WHERE datepart("yyyy", StartDate) = #form.YearChosen#
AND Datepart("m", StartDate) = #form.MonthChosen#
ORDER By StartDate
</cfquery>
thanks again
alex
>and i do not see any StartYear or EventMonthStart columns in there...
>the columns in the query you originally posted? where are they coming from?
>
>Azadi Saryev
>Sabai-dee.com
>http://www.sabai-dee.com/
>
>
>
>alex poyaoan wrote:
>>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315274
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
