> 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