Just a self-reference to TSQL code used to clean up multiple records in a table column by removing a dash from the value.
SELECT TOP 10 * FROM table_name WHERE some_logic
SELECT replace(column_name, '-', '') as [New column_name] FROM table_name WHERE some_logic
UPDATE table_name SET column_name = replace(column_name, '-', '') WHERE some_logic
We been working on a new project which has a very short time line and several people are involved adding to the complexity of the project. The application calls for lectures being streamed over the web utilizing the same technology we use for our online lectures which takes some of the pressure away since the system has been tested and it is a scalable application.
What is this all about? well, today while coming up with some technical requirements for the project one of my colleagues said we should only support Internet Explorer. I walked in late to the meeting and caught him mid-sentence so I asked what that was for since our applications are 100% cross-browser. Now, to his credit, this is an application that used to require IE as its only player but the version we are running these days don’t have this limitation. I argued that we should not require IE for our users when the application also supports Firefox and Safari.
His response to listing IE as the only supported browser was to limit the number of variables when we have to deal with technical support questions. A valid argument but it is not 1991 anymore and we need to make sure that we support all of our users not just that use a specific platform. Specially when the technical choices we have made support multiple platforms. I agreed to take all issues with non-IE browsers but I know that won’t be a problem. I would be far more concerned about the user having the proper media player installed and updated than having the proper browser
.
So I don’t forget about it in the future.
UPDATE mt_entry SET entry_allow_comments=2 WHERE entry_blog_id = # AND entry_allow_comments = 1 AND entry_created_on <= DATE_SUB(CURDATE(), INTERVAL 7 DAY)
I am currently looking into WordPress and the functionality it can provide as a content management system (CMS) for a fairly basic website. I’ve installed the core package to take a close look at the functionality, specially because I was not able to find any content describing the strategy for a project like this one. Many claim that WP is great but I will have to find out by myself.
The time-consuming aspect of this kind of research is the time I have to spend becoming familiar with the syntax, functions and overall code strategy which WP provides. I have succesfully used MovableType (MT) as the CMS behind a couple of projects so I feel very comfortable with that package. However, I need an alternative for the project I have in mind and WP appears to be a good candidate. The project site will be very basic with only a couple of sections being heavy on the "dynamic" aspect. I hope to spend some time during the holiday break getting to know WordPress a little better.
Some links for future reference: WordPress as a CMS, A complete CMS and WordPress 1.5 as a web site CMS
Using unobtrusive javascript to provide "back to top" links without extra markup. (source: Web-Graphics)