Hi,
I have a couple of custom tables in the db & a view called show categories.
The idea is to only show categories based on the logged in users country. Those results will appear in a dropdown for a form
Ive created a feed below which relies on a user token. When I run the feed in preview I get a blank area in the screen. When I attempt to run the feed by going to
http://mywebsite.net/DesktopModules/XModPro/Feed.a... I get a blank screen
When I go to add it to a form the feed doesnt appear as a datasource (which Im guessing should happen.
Here is my code
<xmod:Feed ContentType="text/html">
<ListDataSource CommandText="SELECT Name, Categoryid FROM vw_Category where Name = @Country">
<Parameter Name="Country" Value='[[User:Country]]' DataType="String" />
</ListDataSource>
<HeaderTemplate></HeaderTemplate>
<ItemTemplate>
<span[[Name]]></span>
<span[[Categoryid]]></span>
</ItemTemplate>
<FooterTemplate></FooterTemplate>
</xmod:Feed>
when i run the sql query against the db it returns the required results.
Was hoping to get some assistance as to where I might be going wrong.
Thanks in advance
Todd