Archive of UserLand's first discussion group, started October 5, 1998.
Re: How to populate a DB from a RSS channel in Cold Fusion
Author: James Carlyle Posted: 9/15/1999; 5:56:53 AM Topic: How to populate a DB from a RSS channel in Cold Fusion Msg #: 11023 (In response to 11001) Prev/Next: 11022 / 11024
Fabrice and ZacI've just thought of a possible way of doing this. Use XSL to transform the RSS to WDDX, and then go from WDDX to the database inside Cold Fusion by deserialising the WDDX to a CF query object.
i.e.
insert into NEWS(title,link,summary)
values ('#title#','#link#','#summary#')
Let me know if you work on this stylesheet. I'd like to persuade Allaire to offer more out-of-the-box support for popular formats like RSS and ScriptingNews. BTW, ColdFusion cannot be used as a XML-RPC server at the moment, since it cannot access the POST payload except by name/value pairs. Otherwise I would have added a XML-RPC interface for xmlTree. Sim Simeonov tells me that this should be addressed in the next version.
There are responses to this message:
- Re: How to populate a DB from a RSS channel in Cold Fusion, Mesplé Fabrice, 9/15/1999; 7:48:50 AM
- Re: How to populate a DB from a RSS channel in Cold Fusion, Mesplé Fabrice, 9/15/1999; 7:58:22 AM
This page was archived on 6/13/2001; 4:52:36 PM.
© Copyright 1998-2001 UserLand Software, Inc.