?Custom Variable Using SQL2RSS and RSS2HTML

Dominated4Life · Joined: 18 Nov 2012 Posts: 1 Location: San Francisco

Greetings,

I have a sql database storing business names, addresses, phone numbers, etc and I am using SQL2RSS to create a feed that my html page calls using the RSS2HTML script.

I have successfully connected all databases and scripts. My problem is that I can only get the process to work using the predefined variables, such as:

ItemTitle
ItemLink
ItemDescription
etc

I have more information that Id like to display than available variable options.

Solution: I would like to add custom variables to the script, such as:

BusinessName
BusinessAddress
BusinessAddress2
BusinessCity
BusinessState
BusinessZip
BusinessPhone
BusinessReviewTitle
BusinessReviewLink

I cant seem to figure out how to add these to the scripts so I can modify my templates: sql2rss_ItemTemplate.xml (SQL2RSS) and sample-template.html (RSS2HTML)

Does anyone know how?

Thanks!

Zachary