使用CFFeed创建RSS提要时出错:值应该是字符串

Question

我试图使用cffeed在ColdFusion中使用数据库中的数据创建RSS。但是，当我尝试运行它时，我在第24行(这是cffeed行)上得到了一个错误：

详细信息：值应该是字符串 消息:创建提要时异常。

以下是代码：

<cfquery name="messages" datasource="showcase_Uk">
   select * from t_items where pid = 2 and spid = 45 ORDER BY uploadDate DESC
</cfquery>

<cfset myStruct = StructNew() />
<cfset mystruct.link = "http://showcase.com" />
<cfset myStruct.title = "Examples" />
<cfset mystruct.description = "Examples from UK Showcase" />
<cfset mystruct.pubDate = Now() />
<cfset mystruct.version = "rss_2.0" />
<cfset myStruct.item = ArrayNew(1) />

<cfloop query="messages">
   <cfset myStruct.item[currentRow] = StructNew() />
   <cfset myStruct.item[currentRow].guid = structNew() />
   <cfset myStruct.item[currentRow].guid.isPermaLink="YES" />
   <cfset myStruct.item[currentRow].guid.value = '#messages.id#' />
   <cfset myStruct.item[currentRow].pubDate = createDate(year(#messages.uploadDate#), month(#messages.uploadDate#), day(#messages.uploadDate#)) />
   <cfset myStruct.item[currentRow].title = xmlFormat(#messages.name#) />
   <cfset myStruct.item[currentRow].description = StructNew() />
   <cfset myStruct.item[currentRow].description.value = xmlFormat(#messages.description#)>
</cfloop>

<cffeed action="create" name="#myStruct#" overwrite="true" xmlVar="myXML">

<cfoutput>#myXML#</cfoutput>

任何帮助都会很好。

Answer 1

我在http://cflive.net/上测试了下面的代码，它在Adobe下运行得很好。因此，我认为错误在查询数据中。

<!--- Your query
<cfquery name="messages" datasource="showcase_Uk">
   select * from t_items where pid = 2 and spid = 45 ORDER BY uploadDate DESC
</cfquery>
--->

<!--- Building a new Query --->
<cfset messages = QueryNew("id,uploadDate,name,description")>
<cfset QueryAddRow(messages, 1)>

<cfset QuerySetCell(messages, "id", "123", 1)>
<cfset QuerySetCell(messages, "description", "a string", 1)>
<cfset QuerySetCell(messages, "name", "another string", 1)>
<cfset QuerySetCell(messages, "uploadDate", Now(), 1)>

<!--- From here on it is your code again --->
<cfset myStruct = StructNew() />
<cfset mystruct.link = "http://showcase.com" />
<cfset myStruct.title = "Examples" />
<cfset mystruct.description = "Examples from UK Showcase" />
<cfset mystruct.pubDate = Now() />
<cfset mystruct.version = "rss_2.0" />
<cfset myStruct.item = ArrayNew(1) />

<cfloop query="messages">
   <cfset myStruct.item[currentRow] = StructNew() />
   <cfset myStruct.item[currentRow].guid = structNew() />
   <cfset myStruct.item[currentRow].guid.isPermaLink="YES" />
   <cfset myStruct.item[currentRow].guid.value = '#messages.id#' />
   <cfset myStruct.item[currentRow].pubDate = createDate(year(#messages.uploadDate#), month(#messages.uploadDate#), day(#messages.uploadDate#)) />
   <cfset myStruct.item[currentRow].title = xmlFormat(#messages.name#) />
   <cfset myStruct.item[currentRow].description = StructNew() />
   <cfset myStruct.item[currentRow].description.value = xmlFormat(#messages.description#)>
</cfloop>

<cffeed action="create" name="#myStruct#" overwrite="true" xmlVar="myXML">

<!--- Show the complete xml --->
<cfoutput>#myXML#</cfoutput>
<br><br>
<cfoutput>#XMLFormat(myXML)#</cfoutput>