Excel is a great program for manipulating data and then using it to concatenate a SQL string. Recently, I've found that when I copy concatenated string which looks perfect in excel, it adds quotes around the text when I try and paste them into a text editor or SQL manager. These quotes are unnecessary and I don't want them there.
I've found that if there are line breaks in your concatenated text, then excel will try and preserve the string by adding surrounding quotes.
I've found that by removing the line breaks - Excel will paste un-quoted text. If this doesn't help you and excel is still randomly quoting your text, let me know and maybe we can figure it out together.
Labels: Social-Learning
I've learned over the years that a good blog stays on topic so to fight my urge to be completely random at times, I've sectioned my blog off into a few different sections, one of them being 'myBlog'. This particular section will stray around and you can expect things in myBlog to be fairly random and non-related to anything specific. For example, I'll use this section to reply to a random blog post, test something out or making a personal post. The rest of my blog sections will stay relevant to the other posts and hopefully you'll find them semi-interesting. Then you'll want to subscribe their respective XML feeds!
Hope that clears things up for ya!
Labels: myblog
When first mentioned, I didn't know how to set an Auto-Reply to new followers on Twitter. I wasn't sure if it was a Twitter App setting or a setting within Twitter.
I have found out from RavenSEO's John Henshaw that you have to use a 3rd party application like TweetLater. That was just the first one I found. I'm sure there's a lot more out there and being developed. It seems like you can use this sort of technology to have a Tweet go out whenever you update your blog. That's a nice thing to keep in mind.
Labels: Social-Learning
I'm developing a relationship with a SEO and I want to hand him over some access to Google Analytics Reporting Data. The problem I'm having it that it seems as of (12/23/2008), Google Analytics only allows us to restrict specific domains and not specific reports. I'm particularly confused by this Google FAQ article titled ' How do I restrict a user's access to certain domains or reports?. It seems that it should be re-written as 'How do I restrict user's access to certain domains and their reports?'.
Right now it just seems to be an all-or-nothing game when it comes to distributing access to your GA reports. I'll be sure to update this post when I become aware of how to change access to specific reports within a particular domain within Google Analytics.
I've been using Picasa, Google's acquired digital photo management software for a few years now and I've always thought it was the cat's meow when it came to 'easily importing photos', 'doing very-small touch-ups', sharing, sending photos to print shops, TAGGING and so much more. But on my recent upgrade to version 3, I'm almost driven to the point where I can't use the software anymore. Something is seriously off with the Tagging and I can't figure it out. All I can find is this post ( Discussions > Something Broken in Picasa 3? > Removing tags and searching ).
Initially to me, it seems it could be...
I look forward adding a solution to this problem when, and if, I finally figure out the answer.
Labels: Social-Learning
 |
| From mygear |
I've incorporated 3 businesses and every time I do it, I get a better feel, tax-wise, for what a business is and how it should be optimized for profitability at the end of the year and not just on paper. When running a business, it's so important to understand your taxes and maintain good accounting practices. If you're not aware of taxes or accounting you could be working your butt off and running your business into the ground and not even now it. Or you could think you have money you don't really have.
I've spent a lot of time over the past few years trying to understand my taxes and perfect my accounting practices so my knowledge base on the subject is always increasing; however, I think I've found a pretty good book and believe it should help just about everyone interested in their business taxes. The book is called "JK Lasser's Small Business Taxes 2009: Your Complete Guide to a Better Bottom Line" by Barbara Weltman. You can read through this book or use it as a reference. It will help you understand how to define most financial activities of your business and exclude others, ultimately giving you a better perspective and more control of your business.
Labels: Social-Buying
What's poppin Kunal? I love seeing the work that came from the Olin classes you took. It was way too bad for us that Olin was just coming to be as we were leaving. I would have loved to get more involved, hang out with the students more and take some of their classes.
Labels: myblog
I recently got back into the photography game and tried to find a pretty good SLR camera which would allow me to capture some of the great visual experiences that life has to offer. I knew (as of Nov 2009) that for the past couple years, the Rebel XT was meeting peoples needs and it had been the top used SLR camera, and overall camera, on Flickr.com
 |
| From contentimgs |
So I did a little research and found that the XTi got an upgrade (Canon XSi) and it was gaining early popularity, getting good reviews and taking some beautiful shots. I've had the Canon XSi for about 4 months now and I'm really happy with it. At this point, the Canon 40D is the only other camera I would have liked to spend more time reviewing before getting the XSi. Once you get the camera, finding good lens is more complicated and time consuming. Happy Shooting!
 |
| From mygear |
Labels: Social-Buying
SmugMug has been my favorite photo sharing service for about 6 months now. I'm so impressed with the quality of their service and the enthusiasm of their community. In my opinion, it's the best place for a budding photographer to start, especially if they are looking to start as a professional photographer.
Tagging is a critical feature in all digital photo galleries and there is simply no better way to manage photos in the digital age. Privacy is also important. Unfortunately,on SmugMug - tagging and privacy are not available at the same time. With Smugmug, when you make a gallery private, your viewers can't see your tags. I know of one example where a teacher takes a few hundred pictures at her students event and puts them on SmugMug in a private gallery. Parents go online and see the private photos; however, they can't find their child's pictures because tags are disabled. I've got another example where I photographed a private art collection and the ownered wanted it to be private. But without tags, browsing through the photos is UN-enjoyable.
Not having this feature is driving me to remain non dedicated to SmugMug and continue to use other services. To their benefit, not a lot of services offer private galleries like SmugMug does so I can't determine how good other services are at blending tags and privacy. But I will say - as a web developer, I know this is technologically possible and they just need to do it.
In the meantime, Picasa Web combined with the syncing functionality of Picasa 3 is really growing on me.
Labels: Social-Ping
I don't get it but sometimes programs that you use day in and day out just bug out. For me, Dreamweaver CS3 started crashing when I opened particular Coldfusion (.CFM) files. I could almost predict which ones would make it crash (files calling functions from other files). In some cases, I could get the file open but when I went to change some code, Dreamweaver would crash again. This made no sense to me and a lot of online sources said this had to do with the installation but I didn't believe it.
The solution for me, thanks to Martin Perry, was to delete the winfilecache.+\.dat file which can be found by going here:
 |
| From contentimgs |
On Windows Xp, the file is at:-
[drive]:\Documents and Settings\[username]\Application Data\Adobe\Dreamweaver
9\Configuration
On Windows Vista, you can find it in:-
[drive]:\Users\[username]\AppData\Roaming\Adobe\Dreamweaver 9\Configuration
or accessible via windows explorer in
Desktop\[username]\Roaming\Adobe\Dreamweaver 9\Configuration
I recommend just deleting it if you have it. It's a small file and you can put it back if you need too. I actually tried putting the file back to see if I could recreate my problem for documentation purposes but it I couldn't get it to came back. I figure that's a good thing.
Labels: Social-Learning
Recently, my Exchange Server company upgraded their SSL to a Wildcard Certificate. As you probably know if this article has peaked your interests, Mobile 5 devices don't like this. In order to get your device to accept this configuration, you'll need to make 1 modification to your phones registry. This process is Really Easy and quick (10 minutes) so don't be shy.
Here's the link: PHM Smartphone Regedit. The file I downloaded is called "Smartphone 2002, 2003 (ARM/PXA)". This file will have an extension '.CAB'. Save it to a local folder on your computer. There is nothing you need to do to this file on your computer
Use Windows Explorer or whatever you'd like to copy that .cab file onto your phone.
Just click it or open it. It installs quite easy. After the installation, you'll see a link to "PHM Registry Editor" in your programs.
Navigate to 'Hkey_Current_User' > 'Software' > 'Microsoft' > 'ActiveSync' > 'Partners'. Once you click on partners, you'll see registry entries.
When you select a row and hit values, you get a list of attributes for that registry entry. *Special Note* I repeated this step for both the registry entries you see in the above step.
You'll notice if you scroll down the list, you won't see an attribute called 'Secure'. We need to add this and set it's value to '0'. So lets start by adding the DWORD Key!
Behold, you'll see 'Secure' and it's got a value of '0'!
At this point, you can just continue your Exchange Syncing with your Treo 700w or other smartphone and everything should work. Enjoy!
If this doesn't work for you, you might want to restore or format your device and start from scratch. On a palm, you need to take of the battery case and push the reset button and hold the power button. If you are hooked up to an exchange server, this isn't a big deal because all your contacts and email will populate once you get it connected.
Labels: Social-Learning
November 2008 December 2008 January 2009 February 2009 April 2009 May 2009
