Daniel Kessler wrote: > At 4:02 PM -0500 2/2/05, CF-Talk wrote: > >>BlogCFM 0.92b is available. It now includes support for MySQL, >>PostgreSQL, and Access - SQL Server support will be coming soon (ONE >>query in the app doesn't work under SQL Server). > > > But not Oracle?
I didn't figure there'd be a whole lot of demand for running a blog app on Oracle =) Actually it shouldn't be too hard to convert. There are three issues with converting to Oracle #1 - Oracle can't group by clob fields, which I do in one query. but neither can SQL Server so I'm gonna solve that with the next release anyway. #2 - "COMMENT" isn't a valid column name in Oracle. So I'll have to go through and change that fieldname to something like "COMMENT_TEXT" ... I'll probably do that in the next release too.. #3 - Apparently there are no Month() and Year() functions, which is fine, neither does postgres... so I'll have to figure out how to create those functions too. I've done them for postgres so it shouldn't be all that difficult. - Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192871 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
