Rants, ramblings, and insights…

  • Firefox is downloading something - Why is there a flying blue arrow going from the top left of my screen into the download manger every time I visit a website? Who hacked me? That’s what I asked myself when I first say download activity every time I visited a different URL with FireFox. The problem was that I had to […]
  • Visual_Basic_for_Applications_logo_and_wordmark.svg VBA script – Dynamic WHERE clause with CSV Export - The script below dynamically creates SQL statements from MS-Access form fields and their values (if any). As an extra bonus, this will also generate a .csv file that contains query results if needed; otherwise you can leave that part out. *Disclaimer: This contains scripts I created as well as ones created by others that I […]
  • Uncaught exception ‘PDOException’:General error: 2014 - I received this error while I was testing out a prepared statement using PDO. This happened when criteria from a textbox added to the query’s WHERE clause within the prepared statement. Fatal error: Uncaught exception ‘PDOException’ with message ‘SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, […]
  • domino2 So You Want a Website? Here’s some things to know… - A website is an extension of just about every business. Some websites are great in that they are designed well and serve a purpose (or many). If done right, the very existence of a site gains visibility and provides information to potential and existing clients. Most larger companies have an in-house marketing department that is […]
  • Visual_Basic_for_Applications_logo_and_wordmark.svg Run a report in MS-ACCESS using a subform’s filtered criteria – VBA - I created a quick reporting system in MS-ACCESS that allows the user to search various criteria with the results returning in a subform. Those results could then be filtered in various ways which had to be reflected in the final report. This VBA script is what I used to capture the filtered results and include […]
  • Enable error messages with PHP - Use the code below to display error messages while debugging a PHP web page. You should only use this on local development server as anyone viewing the page will see some server-side logic. It has gotten me out of many a jam…. <?php ini_set("display_errors", 1);  //Display errors to the screen ini_set("track_errors", 1);  //Set last error […]
  • cobbler The Cobbler’s Children Have No Shoes - So there was this cobbler, right? A man who was so devoted to his craft and clients that his poor children went forgotten. Could the children at least grab a few leftover shoes from dad’s shop? Would it be bad marketing for a cobbler to have barefoot kids running around? Or, the children actually had […]
  • Emptying the trash on Android - I love my Droid…I really do, it does EVERYTHING! Except make a decent phone call… The other thing that it doesn’t do well is empty your email’s trash folder when you have over 1000 emails. I know, I know…I need to pay attention to that too but I forget, sometimes. I’m too busy tinkering with […]
  • A quick and dirty JavaScript pop-up - Digging through my stuff I found a simple JavaScript code I’ve used to create Pop-up windows AND allows for you to customize….simple, quick and dirty… function popUp(doc) { eval("page" + id + " = window.open(doc, '" + id + "', toolbar=0,scrollbars=0,location=0, statusbar=1, menubar=0,resizable=1, width=535,height=800, left = 390,top = 25');"); }
  • Server.CreateObject Failed on classic .asp page - When navigating to a classic .asp page I got the following error. Server object error ‘ASP 0177 : 8000401a’ Server.CreateObject Failed/directoryname/filename.asp, line 40 8000401a The site was working fine until migrating the application to a new development server so that narrowed the list of suspects down a bit…but where in the vast mess that is […]

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>