Web Design & Development Blog
This blog covers a lot of technical web development issues, focusing especially on Joomla, Drupal, and other open-source CMSes & platforms. Not all our posts are for web developers; we also make sure to write posts for those who are not technical.
20 December 2010 Downgrading from SQL Server 2008 to Express
category:
Web Design and Development
Ever needed to downgrade from SQL Server 2008 to SQL Server 2008 Express, but ran into problems, such as application framework authentication (aspnet) problems? Try this simple fix; delete the files/folders from C:\Users\{YourUserName}\AppData\Local\Microsoft\Microsoft SQL Server Data.
This may also helps those upgrading from Express to the full-fledged SQL server. This trick was the only thing that worked for me after many hours of debugging.
I hope it helps someone!
15 December 2010 Joomla 1.6 RC1 Now Available
category:
Website Owners
Joomla has finally announced the first release candidate of Joomla 1.6. The final release is due January 11, 2011, with no current plans for a second release candidate. So, the end (of 1.5) is near!
19 November 2010 ASP.net MenuItem mouseovers? Not so fast ..
category:
Web Design and Development
I had some ASP.net 4.0 Hyperlinks and Images and tried converting them to MenuItems, but it’s not possible to set a mouseover without some REALLY clunky workarounds (see here .. and other examples as well). Also, you can’t assign an ID to a MenuItem, nor a class, so you can’t do it with CSS either. Well, you could (using CSS’s nth-child selector) … but not cross-browser. I’m a bit baffled that the MenuItems don’t take an ID, CSS class, OR mouseover easily!! It’s a very common requirement or at least a commonly used design feature / effect, and ASP.net’s been around long enough to have added this at some point!
Maybe I’m missing something obvious here .. ?
Also, since I was using images for the menu items, I needed to hide the text. I managed to hide the text from the menu items, keeping only the image. But when you edit the menu, you can no longer see the menu item names, so you may get lost when trying to edit the menu items. It isn’t ideal, especially if you need to hand the project off to a customer who wants to edit the menu on their own. Again … why the lack of elegance when .net can do so many great things otherwise? There should be a simple option to hide the text.
12 November 2010 Stop Skype plugin from messing up your phone numbers!
category:
Web Design and Development
Ever see a phone number get all messed up by the Skype plugin for Firefox and Internet Explorer? It’s annoying. You’re thinking “I’ll just add this phone number, save the page / module / block / whatever” and be done with it, but you’d be wrong. Many Skype users unwittingly see many phone numbers displayed as clickable Skype links that let them place a call directly to that number.
You can stop this from happening in a couple ways:
- You could make the phone number a graphic
- Insert some hidden code into the phone number that prevents the Skype plugin from detecting it as a phone number.
Example
Before:
Phone: (555) 123-4567
After:
Phone: (555)<span style="display: none;">.</span> 123-4567
The hidden period is enough to stop the Skype plugin from workings its magic / evil. This technique was tested using Joomla but will work anywhere.
08 October 2010 Phoca Download CB Plugin
category:
Joomla Developers
A Community Builder plugin for Joomla 1.5 that displays a user’s files. If the user is viewing his/her own profile, the user can also delete the file from the frontend, which is not yet supported officially by Phoca Download itself! Download it here
15 July 2010 Free Generation International Wins Grant from Chase Giving
category:
News
FGI has received a $20,000 grant from Chase Giving.
Free Generation International / EXIHT International are actively engaged in putting an end to human trafficking, and recently won $20,000 from Chase Giving. Find out more about FGI at freegenerationintl.org or read about our design of the FGI site.
Read more about the grant at FGI's Facebook page.
11 July 2010 Easy tab highlighting with included PHP menu
category:
Web Design and Development
I recently reworked a simple PHP site that uses standalone PHP files containing only HTML. We needed to redesign the navigation bar, which was simple a series of clickable images. These files were not generated by a Dreamweaver template or anything like that, meaning that we would have had to manually change each file every time there was a change to the menu. That seemed very annoying to me, so I created a file called navbar.php and included it into all the pages, using the standard PHP include;
A sample navigation tab would then look like this;
That simply uses the function to tell it which file name to match to the current page’s file name:
isactive(‘consulting.php’);
The end result is that on consulting.php, the HTML output for that tab would look like this:
.. and that is done automatically using a single included file.
06 July 2010 please vote for EXIHT in Africa
category:
Web Design and Development
please vote for EXIHT in Africa.. an anti human trafficking nonprofit. Your vote will help with their funding: http://bit.ly/d3p5Ip
Update: your votes helped EXIHT in Africa raise $20,000 from Chase!!
30 June 2010 Email Links vs. web-based e-mail clients
category:
Web Design and Development
Take a look at http://www.lunarpages.com/sales-questions/. Their “Send us your question” button is nice … but they really ought to list the email address on the page too. Clicking it will launch your default e-mail program, even if you don’t use one. For many people that means it will try to open Windows Mail, Outlook, or Thunderbird, even if they only use Gmail or Hotmail.
Not everyone uses Outlook, Thunderbird, etc (e-mail clients), and assuming that can cost you potential leads and business.
Someone who uses only web-based e-mail will want to be able to quickly copy and paste the e-mail address. Now, you can of course right-click and copy the link address, but then you still have to remove the “mailto:” part. Why put your visitors through so much unnecessary trouble if you really want them to contact you?
There are some valid concerns about attracting spam, but those can be mostly overcome using JavaScript cloaking. I think it would be preferable to receive some spam AND more e-mails from your site visitors, than it would be to receive less spam and fewer e-mails from your site visitors, but maybe it’s just me.
28 June 2010 Field Length Dependent MySQL Text Replacement
category:
Web Design and Development
Suppose you have a MySQL database table containing US 5-digit zip codes, except some of them are just three or four digits long because they had leading zeros, and those sometimes get dropped. Here’s how to add them back in;
For 3-digit zip codes:
UPDATE zipcodes SET zip = CONCAT(’00′, zip) WHERE LENGTH(zip) = 3
This will turn ’123′ into ’00123′.
For 4-digit zip codes:
UPDATE zipcodes SET zip = CONCAT(’0′, zip) WHERE LENGTH(zip) = 4
This will turn ’1234′ into ’01234′.
More Articles...
- Impressions of Joomla 1.6 Beta 3
- loving @freshbooks for invoicing
- Client login for Joomla 1.5 banner component
- Freshbooks and time management
- Monitoring Joomla for file changes
- Find Joomla section ID for article or category
- Google Chrome “mixed content” / SSL issue
- www subdomains (or lack thereof)
- Migrating from FrontPage to Joomla
- Basecamp for time tracking, FreshBooks for invoicing
Page 3 of 5




