On 4/2/07, Kevin Bales <[EMAIL PROTECTED]> wrote: > > if it's not in pound signs, CF won't think that it "owns" the function. > > > > can you paste the code you're using and specify how it "does not work > > in cfquery"? > > -- > > Charlie Griefer > > > My SQL looks like this.... > > SELECT * > FROM items > WHERE DatePart("yyyy",itemDate)='1933'
are you getting an error? no error but unexpected results in the query? my initial thought is to try without the single quotes around the value (1933). also, can you confirm that the itemDate column is a date datatype? -- Charlie Griefer ================================================ "...All the world shall be your enemy, Prince with a Thousand Enemies, and whenever they catch you, they will kill you. But first they must catch you, digger, listener, runner, prince with a swift warning. Be cunning and full of tricks and your people shall never be destroyed." ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274362 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4