No, you _can_ use the query method, you just need to ensure your data has a full URL. THere are a few ways of doing it.
1) Add a new col to your query named something, and loop over your query and use querySetCell to set a full url. _Then_ you feed the query to cffeed. 2) Modify your SQL so what when you select your stuff, you make a new col with the full url. Something like select name, title, goo, 'http://www.coldfusionjedi.com/foo.cfm?id='+id as fulllink My SQL skills stink so that may be a bit off. I prefer method 1. On Jan 10, 2008 5:15 PM, Ryan Bentley <[EMAIL PROTECTED]> wrote: > Thanks Mr. C, > > I actually did read the docs on cffeed, and I did not see anywhere there that > the rsslink, had to be matched to a full url. As a matter of fact, their > example (granted , a very simple one) used the ID field as well for the > rsslink column. > > I also checked your blog as well, and did not find anything that addressed > this particular issue. Guess I probably missed it or browsed over by mistake. > > So, in the end if I do not have a column in the database that contains the > full url, then I cannot use the query method to create a rss feed? > > Thanks for the help. :) > > >You are a bit off. The RSSLINK column in your query should be a full > >url, not a partial URL. > > > >So you need to modify your query so that you have a column with the > >full link, and then pass it to CFFEED. > > > >Don't feel too bad - it's not like you could have the CFFEED chapter > >in the Developer's Guide. ;) > > > >You should search my blog too - I've written about a number of CFFEED > >"issues" folks should be aware of. > > > > > >On Jan 10, 2008 3:19 PM, Ryan Bentley <[EMAIL PROTECTED]> wrote: > >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296447 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
