Saturday, June 23, 2012

MySQL Workbench: Copy Table Structure and Data

Right mouse click the table you want to copy and choose, "Send to SQL Editor -> Create Statement"
Select all and execute the statement (lightening bolt icon)
In SQL statement, change table name
Then execute the statement:

INSERT INTO `table2` SELECT * FROM `table1`

Tuesday, June 5, 2012

Installing Coldfusion 10 on Windows 2008

When installing CF10 on 2008, you may receive on error message telling you that ASP.NET, ISAPI Extensions and ISAPI Filters needed to be installed.  Despite having these roles installed, the CF10 installer may still tell you they are not.  The little bit of information this error message leaves out is that CGI needs to be installed as well.  Once you have ASP.NET, ISAPI Extensions, ISAPI Filters AND CGI installed, the error message should go away.

Friday, April 22, 2011

Firefox 4 does not prompt to save tabs on exit

The solution that worked for me was to set the configuration flag in about:config to:
  • > browser.showQuitWarning to true

There are several popular solutions to this issue that did not work for me. Some that I came across while researching this issue:

Coldfusion Dynamic File Path Code

There are plenty of sites out there with this exact code and I use it in almost every site I've written, but I'll remember where it is if I post it here.

#GetDirectoryFromPath(GetCurrentTemplatePath())#
#GetDirectoryFromPath(GetCurrentTemplatePath())#somedir\somedir2\

Watch your slashes for different OS's.

Monday, April 18, 2011

Prevent Cisco AnyConnect client from starting at boot in Windows 7

A recent upgrade to the Cisco AnyConnect Secure Mobility Client causes the anyconnect client to load at windows startup. This is a pain in the ass since I'm not always going to connect to my VPN when I start windows. Thanks for taking the MS approach on this one Cisco. Thanks also for not providing a simple way to turn this off via the UI. To prevent this client from loading at boot:

start -> type: msconfig.exe
click the tab "startup"
uncheck "Cisco AnyConnect Secure Mobility Client"
click "ok"
click "exit without restart"

Thursday, March 10, 2011

Windows 7: Cannot boot from CD - Code error: 5

UPDATE: I've used this method to create a new bootable DVD:  http://www.unawave.de/windows-7-tipps/code5-error.html

The method detailed below works only about 20% of the time and it's a hassle to find a floppy (or even a floppy drive sometimes).

Symptom: When attempting to boot older hardware with the Windows 7 install DVD, you receive the error message "Cannot boot from CD - Code error: 5"

Problem: The Windows 7 install DVD has multiple file systems not supported by some older BIOS software. To read more about the differences, please read: AlfaMikeDelta's posts.

Solution 1: Upgrade your BIOS to a version that supports booting UDF file systems.

Solution 2: Use a linux boot manager to help emulate the missing BIOS instructions. I used the Gujin boot disk and followed the directions from AlfaMikeDelta's above post:

- Download latest version of Gujin from sourceforge
- Use your favourite decompressing software to unGzip/unTar
- Inside the uncompressed folder, you will find a file named "full.img.gz", unGzip this file too.
- Now you will have a file named "floppy.144", this is the floppy image.
- Download a "Floppy Image Writer", for exmple RawWrite (or WinImage).
- Grab a floppy and write the file "floppy.144" to it.
- Put the Windows 7 DVD in the drive.
- Boot your PC with the floppy, it will show a screen searching for boot records in your computer, follow the instructions about the video resolution.
- Once you are inside the GUI, there will be a list of supported booteable media, press the "F" key corresponding to the one that reads "no emul" or "no emulation" (it should be your DVD)
- Pay attention to the message "Press any key to boot from CD or DVD" and do so when it appears.

Installation should continue as planned from there.

Sunday, December 12, 2010

Chrome OS - Saving items to the Download directory

For those of you lucky enough to be part of the cr-48 pilot program, you may have run into an issue with figuring out how to save items from a cloud-app to your Downloads directory. I ran into this problem when trying to email a friend via gmail something I'd created in Aviary. If you're not familiar with the Chrome OS filesystem or filesystems in general, it's easy to get confused.

The Problem: Attempting to attach a file to an email in Gmail/Apps Email via Chrome OS, Gmail only allows the user the option to attach files from the "Downloads" directory. Unless you've save a file in this directory, you cannot send it as an attachment in Gmail on your Chrome OS enabled device.

The Reason: Application developers who have created browser/cloud based applications have done so assuming users would be using their apps on traditional operating systems where the user has full access to the filesystem. For this reason, when prompting the user to save something, it brings up a file browser that dumps users into some "default" file path. In the case of Aviary, it dumps the user into /. In an effort to make things "easier" for users, Google has decided that if users are going to send files to people, they will either exist in the cloud (and have the option of being sent to users from the cloud based app) or the user will have downloaded the files to the only place native ChromeOS apps have access to, the "downloads" directory. Now to be fair, some of this is speculation on my part, so feel free to weigh-in with your own opinions (even though they're wrong!). And to be fair to Aviary, they allow everything you produce in their apps to be shared via public urls.

The Solution: When prompted with a save file dialog or a browse dialog, navigate to - /home/chronos/user/Downloads/ - and save your files there. From this spot, users will be able to access files via the "Downloads" shortcut (control+o) or from within Gmail when attempting to attach files.