Yep, there is a bug. You have to use uppercase for the column names. http://www.coldfusionjedi.com/index.cfm/2007/7/29/Columnmap-Gotcha-with-CFFEED
On 9/16/07, Brian Peddle <[EMAIL PROTECTED]> wrote: > 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)#"> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288551 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
