Automatically create a URL/HREF in an Excel field

Published on Author JF1 Comment

You output 5000 rows of data into Excel for a client to review and need to make them all HREFs. The records in the excel come out of the database which their site uses and includes ArticleIDs that their site uses a URL variable to select the correct Article. We have this: ArticleID URL 456 And… Continue reading Automatically create a URL/HREF in an Excel field

View MySQL Char Set encoding for your database

Published on Author JFLeave a comment

Quick reference: For Schemas: SELECT default_character_set_name FROM information_schema.SCHEMATA S WHERE schema_name = “schemaname”; For Tables: SELECT CCSA.character_set_name FROM information_schema.`TABLES` T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA WHERE CCSA.collation_name = T.table_collation AND T.table_schema = “schemaname” AND T.table_name = “tablename”; For Columns: SELECT character_set_name FROM information_schema.`COLUMNS` C WHERE table_schema = “schemaname” AND table_name = “tablename” AND column_name = “columnname”; Thanks, as… Continue reading View MySQL Char Set encoding for your database

WordPress Plugin Selection Criteria

Published on Author JFLeave a comment

Here are a few of my selection criteria for using WordPress Plugins for myself and for clients. You may occasionally see strange things on this site as I frequently test plugins and themes. What is the latest version of WordPress it supports? Does it have market penetration? Is it consistently updated? How long has it… Continue reading WordPress Plugin Selection Criteria

Retrieving website credentials stored by Chrome password manager

Published on Author JFLeave a comment

Google Chrome is great for easily managing credentials for the various sights you visit. For convenience, these passwords are stored in local file that you access through Chrome itself. Copy & Paste this into your Chrome URI: chrome://settings/passwords You will see a list of credentials which you can search. To view the password, click on the… Continue reading Retrieving website credentials stored by Chrome password manager

Drupal, AJAX, PHP and max_input_vars

Published on Author JFLeave a comment

While developing a fairly list heavy website using Drupal 7 we reached a point where the common AJAX interface was breaking with an unknown error. The error suggested it was the AJAX function itself that it was breaking. Foolishly, we spent untold hours trying different version of JQUERY and looking into client side code to… Continue reading Drupal, AJAX, PHP and max_input_vars

WordPress on IIS 7.x 404 Error

Published on Author JFLeave a comment

There can be many reasons  a 404 error is generated when combining Windows, IIS, PHP,  and WordPress. Many of you/us out there use our Windows machines exclusively for a variety of reasons ( most often because gaming is where it’s at on Windows and consoles are for the strange). Because of this, we also develop on these… Continue reading WordPress on IIS 7.x 404 Error