-
rss.cfm now looks for additional url parameters - basically the same as index.cfm. The feed can now be filtered by category, so if you want, you can syndicate just my ColdFusion content, and nothing else.
-
getEntries returns two new cols: categoryIDs and CategoryNames. These are both lists where the Nth ID matches the Nth name.
-
Index.cfm updated to show categories and pass filtering information to rss.cfm.
I'm not entirely happy with the code in getEntries. It seems to me that there should be an easier way to do this:
Table A has records. Table B has records. Table C is a table that defines relationships between A and B. I want to select from A and set a value, "B", which represnts all the records in C where C.A_ID = A.ID. I know it can be done with a stored procedure, but I'm surprised there isn't a way to do this in simple SQL. Something like:
select id, name, categoryNames as (select ....),
Archived Comments
You''re close:
Select id, name, (select foo from tableB) as categoryNames
from tableA
At least that''s how I''m doing it in SQL Server 2000
hofo
That only works when the subquery returns one record. Some blog entries have N categories assigned to them.
Can you provide a "usage guide" for rss.cfm for folks who read your blog that way? What is the URL API?
I''ve been thinking about the short mode vs. long mode (ala whether to provide the full content of a post vs. a summary with link to the main post) and I have a question ergarding formatting. Should the full post contain the "raw" text, with not HTML formatting, or would you prefer it to come across with HTML formatting included? I''m not sure how the blog readers everyone is using handles the whitespace in the RSS feed, but I''d think you wouldn''t want to get a big jumble if the blog post contains both text and code.