Skip to main content
Anonymous
June 2, 2014
Answered

how to combine strings to get more info into an rss feed

When creating an rss feed, we only have 4 fields to use, date, title, content and link. How can i combine two fields creating one field out of two?

    This topic is closed to new replies. Start a new post to keep the conversation going.
    BKBK
    BKBKCorrect answer
    Community Expert
    June 4, 2014

    You could just modify the query accordingly. Do something like

    <!--- I am on MySQL, hence concat()--->

    <cfquery name="TestQuery" datasource="#application.dsn#">

    SELECT dev_ID, display_date, title, body, scripture, concat(title,'<br />',scripture) as extendedTitle

    FROM devotional

    where display_date = <cfqueryparam value ="#dateformat(now(), "YYYY-MM-DD")#" cfsqltype="cf_sql_date">

    </cfquery>

    View reply

    4 replies

    BKBK
    Community Expert
    BKBKCommunity Expert
    Community Expert
    June 3, 2014

    Could you show us the code you have so far? That would help the discussion.

    Translate
    Anonymous
    June 4, 2014

    I have highlighted the line I am trying to get to work. I am trying to get the title to

    <cfquery name="TestQuery" datasource="#application.dsn#">

    SELECT dev_ID, display_date, title, body, scripture

    FROM devotional

    where display_date = <cfqueryparam value ="#dateformat(now(), "YYYY-MM-DD")#" cfsqltype="cf_sql_date">

    </cfquery>

    <CFSET title = TestQuery.title & "<br />" & TestQuery.scripture>

    <cfscript>

    testStruct = StructNew();

    testStruct.version = "rss_2.0";

    </cfscript>

    <cfscript>

    testStruct = StructNew();

    testStruct.version = "rss_2.0";

    testStruct.title = "Daily Devotionals";

    testStruct.link = "http://mydailydevotionals.com/rss.xml";

    testStruct.description = "Providing Daily Devotionals feed";

    testStruct.pubDate = Now();

    columnMapStruct = StructNew();

    columnMapStruct.publisheddate = "display_date";

    columnMapStruct.title = "title";

    columnMapStruct.content = "body";

    columnMapStruct.rsslink = "dev_ID";

    </cfscript>

    <cffeed action = "create"

    query= "#TestQuery#"

    properties="#testStruct#"

    columnMap="#columnMapStruct#"

    outputFile = "rss.xml"

    overwrite = "yes">

    Translate
    BKBK
    Community Expert
    BKBKCommunity ExpertCorrect answer
    Community Expert
    June 4, 2014

    You could just modify the query accordingly. Do something like

    <!--- I am on MySQL, hence concat()--->

    <cfquery name="TestQuery" datasource="#application.dsn#">

    SELECT dev_ID, display_date, title, body, scripture, concat(title,'<br />',scripture) as extendedTitle

    FROM devotional

    where display_date = <cfqueryparam value ="#dateformat(now(), "YYYY-MM-DD")#" cfsqltype="cf_sql_date">

    </cfquery>

    Translate
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices