> 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'

- Kevin

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274360
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Reply via email to