Practical ProgrammingExperience is knowledge.
|
Make sure you download the latest release. I fixed a bug that showed up in jQuery 1.4.2 (thanks CK for bringing it to my attention)
See more at the original post, JQuery Google Suggest (jquery.gsugguest.js).
Key bindings for SSMS default to Visual Studio scheme… again folks I highly recommend taking the time to learn the shortcuts. Force yourself to use them and your speed will eventually be unmatched.
http://msdn.microsoft.com/en-us/library/ms174205(printer).aspx
Took a while to find a good printout…. but I highly recommend it if you are looking to code faster with Visual Studio.
Due to a hard drive failure the sample page “SEE IT IN ACTION” for jquery.gsuggest has been down. I rewrote the sample this morning. Keep the comments coming in!
See more at the original post, JQuery Google Suggest (jquery.gsugguest.js).
Those of you who do any cf programming have undoubtedly referenced Adobe’s LiveDocs quite a lot… however I find the way the site is structured to be a little slow with the frames and directory tree view. I noticed CFQuickDocs embedded as the default ColdFusion help in Eclipse (with the cf plugin) and it is nice and speedy…. check it out if you have time:
http://www.cfquickdocs.com
One of the drives in the programmers.org server decided to die last night as I was running defrag. Not a big deal, figured I could hot swap it out since I have plenty machiens to pull parts from. Unfortunately I discovered since the drive, while nearly exact in size and speed, was not compatible with an automatic-rebuild for this paticular raid card (PERC something or other).
After beating my head against the wall looking for a rebuild utility in the controller configuration application, I eventually discovered when the auto-rebuild fails you have to perform a manual rebuild with Dell’s OpenManage Software. I didn’t have this installed, go figure.
My apologies if you experienced any noticeable outtages.
If you find yourself using terminal services a lot to manage various systems you will undoubtedly forget to logout of your sessions from time to time. Depending on the number of allowed and active sessions you could find yourself in a jam and unable to login.
I found myself in a jam and needed to restart terminal services remotely. Here is how I did it.
Yesterday evening, It occurred to me that a simple solution to this is to just restart the services from the command line. You might be wondering, since you can’t get in to run the command how this would work. You have two options:
To execute a command from a web script you will need to do two things. First create a batch file with the commands you wish to execute. Second write a script to securely execute those commands.
[remote.bat]
net stop “Terminal Services”
net start “Terminal Services”
REM echo reboot the machine
REM shutdown -r -t 0
[/remote.cfm]
<cfparam name=”url.key” default=”">
<cfif url.key eq “xya58IE9tsr”>
<cfexecute name=”#expandPath(”remote.bat”)#” variable=”foo”></cfexecute>
<cfoutput>#foo#</cfoutput>
</cfif>
—–
You will see the above script checks for a specific url.key in order to execute… you could easily limit this to a paticular IP or integrate another security method. Just remember not to leave it wide open or you just might have an unauthorized user executing your batch (probably on accident).
*Note that in this case the batch and cfm file reside in the same directory and execute permissions are given by default to each folder in CF. With ASP .NET you will need to make sure you have the ACL set correctly for IUSR or the Impersonated Account inside web.config.
—–
If you don’t have access to an application server, rember to consider PsExec as an option. It is a free tool from Sysinternals, but I recommend you download it as part of a collection of PsTools.
To stop Terminal Services remotely, run :
psexec \\servername net stop “terminal services”
To start Terminal Services remotely, run :
psexec \\servername net start “terminal services”
*don’t forget to add your user account information for this to work. its [-u] & [-p] respectively. See /? or check out the July 2004 issue of Windows IT Pro Magazine for Mark’s article that covers advanced usage of PsExec.
If you manage lots of SQL Servers no doubt you will have some DTS Packages to work with…. my new install of Sql Server 2008 did not come with the features necessary to work with legacy DTS. (nord did 2005, I understand its depreciated, but this is annoying.)
Don’t be fooled by the install… the Compatibility Tools aren’t enough to get up and running. I found these instructions by Microsoft, which require MANUAL copying of DLLS and such.
http://msdn.microsoft.com/en-us/library/ms143755.aspx
But although I was able to get DTS to work in 2005, the same is not true for me in 2008… It’s time for me to fire up a new VM, hopefully you will have better luck.
I was unable to find an jQuery autocomplete / jQuery autosuggest plugin available that met my exacting standards. While there are a good number of plugins available in the plugin repository, they are either too large, poorly written, or simply do not work as expected. In addition to this, the ones I reviewed lacked extensibility and a good default configuration.
I decided to write my own jQuery autosuggest plugin (GSUGGSET), and give back to the community.
Download: jquery.gsuggest.js
Project Requirements
Default Configuration
Usage Information
While I wrote this plugin to be as simple and intuitive to use, there are some things you should be aware of before using it.
————————————
A. Using an Inline Dataset
An inline dataset is one that does not make a round trip to any server to get a collection of data used for the suggest-box. To use this, simply add the parameter suggestvalue=”" to your input:text. Note, the suggest_value must be a JSON Array.
html: <input type="text" name="attorney_name" value="" size="100" suggest="yes" suggestvalue='["Micah","Shawn","Charles"]' nosubmit>
*The sugget_value does not need to be sorted, thats handled automatically.
B. Using an Ajax Dataset
An AJAX dataset is one that communicates with a server in the background to get a collection of data (when necessary thanks to caching) used for the suggest-box. To do so, you will need to pass the address of your ajax call (wether that be a cfm page, asp .net, php, whatever) to the URL Config Option.
jQuery(document).ready(function(){jQuery.gsuggest({'debug':true,'url':'myAjaxPage.aspx'})});
That page will receive two url parameters in its get request: value & method. value is the value of the input:text after keyup and should be used to execute a query and return a JSON String Array. method is an identifier to allow multiple queries to be executed inside a single ajax page. I prefer to have all of my suggest queries in one file, suggest.cfc, and you will see that reflected in the defaults.
html: <input type="text" name="attorney_name" value="" size="100" suggest="yes" nosubmit>
MIT License/GNU License
http://www.opensource.org/licenses/mit-license.php
http://www.gnu.org/licenses/gpl.html
Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the “Software”), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so.
10 years in the making, but the standards body finally agreed. Here it is:
http://www.ecma-international.org/publications/files/ECMA-ST/ECMA-262.pdf
Any sufficiently advanced technology is indistinguishable from magicArthur C. Clarke
