RSS - creating xml in FP

[Mettá]

I am wondering if db content in an FP site can be used to create an RSS feed
in an FP2003 site.

If so, how, any pointers? Especially getting the db content into an xml
"page"

Thanks
M

 

[Mettá]

I had a go at creating an ASP page coded in xml as below.

It worked briefly, and then I changed something minor but cant see what it
was.

Any pointers would be appreciated

Thanks
M

<?xml version="1.0"?>
<rss version="2.0">
<channel>
<title>Channel Name</title>
<description>What this feed is about</description>
<link>http://www.site.org.uk/</link>

'Start db content
<item>
<title><%=FP_FieldVal(fp_rs,"RECtitle")%></title>
<description><%=FP_FieldVal(fp_rs,"RECdesc")%></description>
<link><%=FP_FieldVal(fp_rs,"RECweb")%></link>
</item>
'end db content

</channel>
</rss>

 

[Stefan B Rusynko]

The ASP engine does not parse xml files, only .asp files

You will need to create .asp page that generates a .xml file using FSO

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


|I had a go at creating an ASP page coded in xml as below.
|
| It worked briefly, and then I changed something minor but cant see what it
| was.
|
| Any pointers would be appreciated
|
| Thanks
| M
|
| <?xml version="1.0"?>
| <rss version="2.0">
| <channel>
| <title>Channel Name</title>
| <description>What this feed is about</description>
| <link>http://www.site.org.uk/</link>
|
| 'Start db content
| <item>
| <title><%=FP_FieldVal(fp_rs,"RECtitle")%></title>
| <description><%=FP_FieldVal(fp_rs,"RECdesc")%></description>
| <link><%=FP_FieldVal(fp_rs,"RECweb")%></link>
| </item>
| 'end db content
|
| </channel>
| </rss>
|
|
| --
| ---
| | >I am wondering if db content in an FP site can be used to create an RSS
| >feed in an FP2003 site.
| >
| > If so, how, any pointers? Especially getting the db content into an xml
| > "page"
| >
| > Thanks
| > M
| >
| > --
| > ---
| >
| >
|
|

 

[Thomas A. Rowe]

File System Object

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

FSO?

--
---

The ASP engine does not parse xml files, only .asp files

You will need to create .asp page that generates a .xml file using FSO

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


|I had a go at creating an ASP page coded in xml as below.
|
| It worked briefly, and then I changed something minor but cant see what it
| was.
|
| Any pointers would be appreciated
|
| Thanks
| M
|
| <?xml version="1.0"?>
| <rss version="2.0">
| <channel>
| <title>Channel Name</title>
| <description>What this feed is about</description>
| <link>http://www.site.org.uk/</link>
|
| 'Start db content
| <item>
| <title><%=FP_FieldVal(fp_rs,"RECtitle")%></title>
| <description><%=FP_FieldVal(fp_rs,"RECdesc")%></description>
| <link><%=FP_FieldVal(fp_rs,"RECweb")%></link>
| </item>
| 'end db content
|
| </channel>
| </rss>
|
|
| --
| ---
| | >I am wondering if db content in an FP site can be used to create an RSS
| >feed in an FP2003 site.
| >
| > If so, how, any pointers? Especially getting the db content into an xml
| > "page"
| >
| > Thanks
| > M
| >
| > --
| > ---
| >
| >
|
|

 

[Mettá]

FSO?

 

[Mettá]

Hi
FSO is new to me, so I know nothing! But I created an asp page with the
following, which did work but now wont?

Is there an obvious reason for not doing something like this?

Thanks
M

<?xml version="1.0"?>
<rss version="2.0">
<channel>
<title>TEST RSS FEED</title>
<link>http://www.SiteName.org.uk</link>
<description>RSS Event Feed TEST</description>
<!--#include file="_fpclass/fpdblib.inc"-->
<%
fp_sQry="SELECT * FROM qapp ORDER BY eid DESC"
fp_sDefault=""
fp_sNoRecords="None."
fp_sDataConn="dbname"
fp_iMaxRecords=10
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&ename=202&descrip=203&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<item>
<title><%=FP_FieldVal(fp_rs,"ename")%></title>
<link>http://www.metta.org.uk/</link>
<description><%=FP_FieldVal(fp_rs,"descrip")%></description>
</item><!--#include file="_fpclass/fpdbrgn2.inc"-->
<item>
<title>LAST</title>
<link>http://www.whatever/</link>
<description>last words</description>
</item>
</channel>
</rss>

--
---

File System Object

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

FSO?

--
---

The ASP engine does not parse xml files, only .asp files

You will need to create .asp page that generates a .xml file using FSO

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


|I had a go at creating an ASP page coded in xml as below.
|
| It worked briefly, and then I changed something minor but cant see
what it
| was.
|
| Any pointers would be appreciated
|
| Thanks
| M
|
| <?xml version="1.0"?>
| <rss version="2.0">
| <channel>
| <title>Channel Name</title>
| <description>What this feed is about</description>
| <link>http://www.site.org.uk/</link>
|
| 'Start db content
| <item>
| <title><%=FP_FieldVal(fp_rs,"RECtitle")%></title>
| <description><%=FP_FieldVal(fp_rs,"RECdesc")%></description>
| <link><%=FP_FieldVal(fp_rs,"RECweb")%></link>
| </item>
| 'end db content
|
| </channel>
| </rss>
|
|
| --
| ---
| | >I am wondering if db content in an FP site can be used to create an
RSS
| >feed in an FP2003 site.
| >
| > If so, how, any pointers? Especially getting the db content into an
xml
| > "page"
| >
| > Thanks
| > M
| >
| > --
| > ---
| >
| >
|
|