I am probably being dense or showing my ignorance here, but I have a legacy
database that I need to run a query on like the following. Can anyone tell me
how I can achieve the following. Right now I am getting an error that PubYear
is not a valid column. Thank you!
SELECT AdINFO_Publication,
ADINFO_PUBLICATIONDATE_YEAR+ '-' + ADINFO_PUBLICATIONDATE_MONTH
+ '-01' AS PubYear
FROM crAdInfo
AND PubYear BETWEEN #dateformat(startdate,"yyyy-mm-dd")# AND
#dateformat(enddate,"yyyy-mm-dd")#
Any Help is appreciated. Thanks!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290994
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
