I'm trying to do something pretty basic with CFFEED ... basically from the docs I get this error
There is a problem in the column mappings specified in the columnMap structure. The query attribute input does not contain any column by the name of job_title. However it certainly does contain that column. Anything I am overlooking? <!--- Get the feed data as a query from the orders table. ---> <cfquery name="getJobs" datasource="dsngoeshere"> SELECT TOP 10 * FROM E_JOB WHERE state_id = 42 ORDER BY updated_date desc </cfquery> <cfdump var="#getJobs#"> <!--- Map the orders column names to the feed query column names. ---> <cfset columnMapStruct = StructNew()> <cfset columnMapStruct.publisheddate = "updated_date"> <cfset columnMapStruct.content = "description"> <cfset columnMapStruct.title = "job_title"> <cfset columnMapStruct.rsslink = "job_id"> <!--- Set the feed metadata. ---> <cfset meta = structNew()> <cfset meta.title = "Tennessee Jobs"> <cfset meta.link = "http://feedlink";> <cfset meta.description = "Recent Jobs"> <cfset meta.version = "rss_2.0"> <!--- Create the feed. ---> <cffeed action="create" query="#getJobs#" properties="#meta#" columnMap="#columnMapStruct#" xmlvar="rssXML"> <cfdump var="#XMLParse(rssXML)#"> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288550 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
