Thanks to ScottP, the issue has been resolved. Here is what I did wrong...
tblBlogEntries.username = tblUsers.name The correct scenario... tblBlogEntries.username = tblUsers.username Thanks ScottP! Matt On Nov 14, 2007 11:48 AM, Matt Quackenbush <[EMAIL PROTECTED]> wrote: > I have just done a fresh install of BlogCFC (v 5.9), but I have a ton of > "posts" that I am importing from an old database (not a BlogCFC database). > I wrote up a little script to pull the data and then insert it into > BlogCFC's tblBlogEntries, and have assigned each post to a category by > inserting into tblBlogEntriesCategories. I then refreshed the cache. All > of that ran nice and smooth. > > The "new" posts show up in the post count for the category in the Archives > By Subject pod. They also show up on the calendar, meaning that the days > with posts are now links to display that day's posts. They also show up if > I do a raw query/dump of the tblBlogEntries table. However, nothing shows > up in the posts section. All I get is: "sorry, there are no blog entries > available that match your criteria". Same message on the home page, the day > page, the month page, the category page. > > Any ideas as to what I am doing wrong? > > > Thanks in advance, > > Matt > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293314 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
