On Nov 14, 2007 9: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.
check tblblogentries.username = tblusers.username -- Charlie Griefer ================================================ "...All the world shall be your enemy, Prince with a Thousand Enemies, and whenever they catch you, they will kill you. But first they must catch you, digger, listener, runner, prince with a swift warning. Be cunning and full of tricks and your people shall never be destroyed." ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293320 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
