David Mineer's Blog

2011-06-29T17:22:00.003-06:00

I have officially moved this blog to http://www.davemineer.com

No matter what blog software I use in the future this should be the URL pointing to that blog. Please update your aggregator. Does anybody even follow this lame blog?

2011-05-27T21:50:00.001-06:00

How do I add a user on ubuntu 11.04?

Long time ago I got a dell mini 9 inch and the kids kind of like it but the keys are really small, so is the screen so there wasn't a lot of love. Then we lost the power adapter and it sat idle for a long time. Probably 6 months. I found a replacement power cord on ebay for about $7 and now we can use it again.

it came with XP but that was running slow so I installed ubuntu on it to try and make it more interesting. I think it worked. I kind of have fun with it. Just a toy so far and really it will probably be that way for ever cause it is so small.

Back to the point. I want it to work right when I logon which means I want some stuff saved as part of my user profile, but I don't want the kids getting on to my stuff either.

We added one user from the command line. My son actually did that, good job buddy! I found an article that shows how to do it via the gui interface:

http://www.liberiangeek.net/2011/03/addremove-users-ubuntu-11-04-natty-narwhal/

To summarize:
System Settings, System, Users and Groups

2011-05-27T13:56:00.000-06:00

IIS Manager Error: The process cannot access the file because it is being used by another process. (Exception from HRESULT: 0x80070020)

I am trying to set up a local dev environment again. Have tried apache, mysql and everything over the years, this time I am using IIS (Have also done that before) and MSSQL because our main DB is in MSSQL. I am having trouble installing coldfusion so I reboot and when it comes back up I try and start my web server but I get the error above. A netstat -ao tells me what is using what ports but the PID doesn't match anything in task manager, but from google search I see that skype defaults to port 80 if you let it. Shut down skype (only for a second cause I use it all the time) and my websites start up now.

Skype has option under Tools/Options/Advanced/Connection "Use port 80 and 443 as alternatives for incoming connections. Unchecked that and all should be well. Will see if I have any problems with skype. Another option is to start your webserver before you start skype which is probably what would happen if you let your webserver start automatically. I don't do that cause I don't always use it and don't want it hoggin resources on my dev machine. I use a batch script to start up what I need for my dev environment and the webserver is part of that.

Skype Version (5.3.0.111)

2011-05-23T09:13:00.000-06:00

Database Maintenance - Previous Thursday, Current Week, Last day of week.

We keep bumping into some bad field values from the old database. These usually aren't an issue in our new database but since we use the old one for some stuff it is important to keep it clean throughout. Each one of our records has 3 fields which correlate it to a specific publication of our newsletter. The first day of our publishing week, the week, and the last day of our publishing week. Some of our records were missing these values and I went in search of finding a way to bulk update. The biggest challenge was getting the beginning day of the week. We work on a Thursday - Wednesday week. The reasons for this are another blog post. Anyway to find the previous thursday of any week I used the following:

update table
set beg =
    CASE
        WHEN DATEPART(dw,date) in (5,6,7) THEN dateadd(dd,5-DATEPART(dw,date),date)
        ELSE dateadd(dd,1-(DATEPART(dw,date)+3),date)
    END
    WHERE beg is null

Basically, what happens is that it checks the day of the week and if it is 5,6, or 7, (that means Thursd, Fri, or Saturday) then it substracts 5 - that number. So if thursday would be 5-5 = 0 and datadd 0 would stay thursday(5). otherwise take the day and subtract from 1. This will always be a negative number which works with the datadd to get you back to the previous thursday. So, if it is a tuesday, that would be a 3. So 3+3 =6 and 1-6 = -5, so Tuesday - 5 days = mon,sun,sat,fri,thurs TADA! back to the previous thursday.

If there be an easier way, let me know.

I mentioned that I also had to get the end date and the week.

For the end date I simply updated the end = dateadd(dd,6,beg) where end is null

Don't get tricked into thinking that is a 7, it is a 6. That's always been a problem for me since there are 7 days in the week. but you add by 6 to get to where you need to be, I promise.

The week was simply a datepart(ww,end)-1. Why -1, just how it has always been for us. Calendar week 1 is sometimes very short, I think even 1 day if it is a saturday or something. Go learn about that, I just know for us we area always at sql(week) - 1 for our current week.

2011-05-06T14:17:00.000-06:00

jQuery autoselect

Today I wanted to use the jQuery autoselect feature to add an autoselect to an input field on a web page. I have heard alot about jQuery but until yesterday I really hadn't done anything with it. (how horrible is that) Yesterday I used it for the simple task of updating a text field with the value of a select dropdown field. Simple, this is all it took:

$("#jid").change(function(){
$("#city").val($("#jid option:selected").text());
});

Where jid is the select dropdown and city is the text input I wanted the text from the dropdown to be copied to.

The autocomplete was a little more complicated, but not much. I use the following as the basis for this project and pretty much just copied it and adapted it to my site:

http://www.coldfusionjedi.com/index.cfm/2010/4/12/Playing-with-jQuery-UIs-Autocomplete-Control

jQuery does make things easy. I use a cfc as in the 2nd to last example on above to return dynamic results.

2011-04-27T09:37:00.000-06:00

Find and Fix Scientific Notation values in a field

Many years ago during some importing or upgrading to a bigger better database one of my fields was converting longer numerical values to scientific notation. This quit happening but I still had alot of those values in a text field in my database. Originally that field was numeric, but we converted it to text because there were often times when letters were added to the values we receive.

After not being able to find a isScientificNotation() function I found the values like this:

select myfield, LTRIM(str(cast(my field as real))), * from mytable

This worked great and made it easy to write an update statement like so:

update mytable
set myfield = LTRIM(str(cast(myfield as real)))
where myfield like '%e+%'

No more scientific notation in my field. Cool. Should have fixed this years ago, or not let it happen in the first place.

Dave

2010-07-30T23:30:00.001-06:00

Railo on mac

I have had a great time at CFUNITED this year. One of the things that has been a hot topic, which I haven't really caught wind of until today, is the battle between Adobe and the CFML open source alternatives, mainly Railo and Open BD. I will save that topic for another post. But that, along with the fact that I have been wanting to do it anyway, prompted me to give Railo a run.

I am mac challenged. I spend 95% of my time on a PC. The only time I seriously use my mac is when I travel, and at home in the evening, so maybe I only spend 80% of my time on a PC. So I can't handle any advanced stuff on a mac.

Railo provides a version that you don't have to install. That is good for me. It is called "Railo Express (Jetty)". It worked just as expected. I dropped in my apps folder after unzipping the archive and double clicked on "Start" and there you go. I pointed my browser to http://localhost:8888/ and up came a screen prompting me for a new password. After selecting one I was presented with the admin interface for railo.

I snooped around the admin interface for a minute, but then I wanted to just see a regular page. I opened up the index.cfm file in the railo directory (under applications for me, it had a weird name that represented the relase number and everything) under webroot and noticed there was a cflocation:

<cflocation url="railo-context/admin.cfm" addtoken="no">

I commented that out and then I was able to use that page like any other cfm page and add cfml to it however I want.

Pretty nice that railo makes it so easy to get started with CFML. I have a hard time articulating my thoughts on stuff, like the adobe vs open source battle, but being able to start coding in CFML so easily seems like a good thing for our community.

2010-05-10T14:17:00.000-06:00

Coldfusion 9 orm where in clause

I was trying to do a where in clause using coldfusion 9 orm and it just didn't work. I know pretty fast when something is over my head. A quick search revealed this thread: http://groups.google.com/group/cf-orm-dev/browse_thread/thread/19dc48732d58fca0/f47f3d4ef2e75aab?lnk=raot&fwc=1 in the cf9 orm mailing list. This thread discusses the exact issue I was wondering about. At the end, Barney Boisvert gives an example of how to do this (you have to click on "show Text" in the Bob Sivlerberg Post)

Since I can't figure out how to post code to this STUPID blog, you will have to visit the link.

I also had another issue, I wanted to still use offset and maxrows. That was easy enough even though I tried to make it hard, and you can see that solution in my post to the same group: http://groups.google.com/group/cf-orm-dev/browse_thread/thread/ab1f8badf28dfbb5?hl=en

2010-05-05T14:51:00.000-06:00

No Row with the Given Identifier Exists: [contact#0]

So I was setting up coldfusion 9 orm and dumping an object that had lots of related objects, an they had lots of related objects etc.. I kept getting the above error when outputting a one-to-many related object. After searching the database I noticed that that particular foreign key was being set to a 0, instead of a null value, but both those values where present in the linking table.

The solution was to use the missingrowignored="true" option in my orm definition. The record with id = 0 didn't exist and cf 9 orm tried pulling a record with that value (usually it expects a null value when nothing related exists). This caused it to error but I also got a positive from hasContact(). Anyway the missingrowignored="true" was the fix.

2010-05-04T10:36:00.000-06:00

Specifying Security Credentials in Amazon Web Services AWS EC2

At cfobjective this year Chris Peterson gave a great presentation on running coldfusion in the cloud. In his demo he showed Amazon EC2 and showed how he used it for cloud computing. I was excited about this and I have been checking it out.

Right off the bat I got confused on how to enter my security credentials. I created a key pair and tried to enter that, but it didn't work. So after a couple weeks (I only was able to look at it for a few minutes a couple of different times) I found out what was going on. To get the necessary information, I had to go to the AWS EC2 website and after you login you click "Account" then you click "Security Credentials". Now, after this click, I always have to logon again. NO problem. Then, down below, you will see a section "Access Credentials" with 3 tabs, Choose the "Access Keys" tab, it is probably already selected since it is the first one. You see where it says "Your Access Keys" you can see the Access Key Id, and you simply click on show under the "Secret Access Key" column to see your Secret Key.

Then, using elsaticfox I click on credentials, or it prompts me for them. You can enter anything for the "Account Name" and the AWS Access Key and AWS Secret Access Key where those that we saw above.

Seems simple enough but one of those things that tripped me up.

2010-04-28T21:07:00.000-06:00

How do I install the latest version of JAVA on Linux Ubuntu?

This is not easy. It's no wonder more people don't use Linux. I cannot see any normal person doing this. Until stuff like this is resolved and made easier Linux won't be coming to many desktops any time soon.

I found this article that walked me through it, but I had no idea what I was doing, just followed the instructions.

http://ubuntuforums.org/showthread.php?t=1437100

2010-01-11T12:47:00.005-07:00

Error while executing the Hibernate query.

org.hibernate.hql.ast.QuerySyntaxException: state is not mapped [from state]

This is the error I got when trying to do a simple ORMExecute("from state"). This happened because the from statement is case sensitive. I did change the name of the .cfc but I still am forced to use a uppercase "s" in "State". The tablename is tblState, so I am still confused on this one, but changing the case to match the original cfc did fix it.

2010-01-03T22:51:00.002-07:00

ColdFusion Builder Beta 3 and subclipse (subversion)

The ColdFusion Beta Builder 2 expired on Jan 1, 2010 so I was forced to do something that I wanted to do anyway, install beta 3. I did that on my mac over the weekend. Once I installed it I had a problem getting subversion back on so I could update my repositories.

The first problem was when i selected the subversion components from their site http://subclipse.tigris.org/ It had required dependencies. After unchecking a few, I think mylyn and the graphing one It allowed me to go to the accept licenses screen. However the next and finish buttons stayed greyed out no matter what I chose. I chose the radio button to accept the license agreements and even made sure to scroll through all of them to the end and everything. Nothing worked. Google search gave me this: http://hippiex.instantspot.com/blog/2009/07/13/Easy-Subclipse-and-Coldfusion-Builder. I don't know how it made a difference because I didn't choose any of the components from that site, but just adding it as a site seemed to fix the licensing issue.

After that, I got subclipse to install but upon trying to update to head my repository I got the error "Thread attempted to read nesting count of a lock it did not own". After googling that I found some advice to add all the optional components, which I went back and did, one at a time. I can't remember what order I did them in but I ended up having to add them all except for collabnet merge client before it actuall worked without giving me that error.

2009-11-13T10:49:00.004-07:00

How to call a controller in FW/1

Sean Corfiled wrote a simple MVC framework a few months ago called FW/1 (check it out here). I have been following the discussion list since the beginning. Last night I finally gave it a try. I was very impressed by it's simplicity. There isn't alot of documentation but there doesn't need to be a whole lot because it is so easy and Convention based. I had a view up and running based on the getting started doc in just a few minutes. Very nice. It is not only easy, understanding the conventions will surely help my development in model-glue and other frameworks, even when I don't use a framework this will help with my mental and code organization.

Then I moved to controllers. I just couldn't grasp how they were called. I reread the docs a few times and finally went to bed a defeated man. This morning I reread once more and it clicked, and the docs explain it perfectly, I was just a little thrown by the verbage, which I shouldn't have been. In model glue I call an event like so:

<event-handler name="maint.city">
<broadcasts>
<message name="needCity"/>
</broadcasts>
<results />
<views>
<include name="body" template="maint/city.cfm" />
</views>
</event-handler>

In FW/1 your url would be http://www.whatever.com/myapp/index.cfm?action=maint.city

FW/1 automatically calls the city() function in the controllers/maint.cfc controller. It seems almost silly that I couldn't figure this out, but It did escape me for a minute. I knew to create a controller and where to put it, but I wasn't sure how to call different functions etc.. In model-glue I would broadcast different messages. So I was thinking maybe I needed to call functions from my view or something, like city = rc.controller.getCityById().

Turns out, as mentioned that FW/1 calls the city() function automatically and i can call other stuff from inside that function.

2009-11-11T15:15:00.002-07:00

Posting Code Snippets in blogger

I have always wanted a good way to post code snippets on this blog. My favorite is the way that Ben Nadel does it at his blog: http://www.bennadel.com/. I sent him a message asking him how he does this, but I have not heard back from him. I found a way to post code snippets but it ain't that pretty.

You use blockquote and the returned output from this parser: http://www.blogcrowds.com/resources/parse_html.php

2009-11-11T15:11:00.002-07:00

ColdFusion Report Builder has Report Functions

I stumbled on a discussion at: http://www.justskins.com/forum/archive/index.php?t-5171.html that made me realize that Report Functions are available in ColdFusion Report Builder. I had been struggling with the expression builder using iif to conditional show fields. iif is a bear, you have to use DE(" ") and different things and it can be ugly.

As mentioned in the article, you cant use cfml syntax in the expression builder. But you can using report functions. This is a very nice feature. Since I get mad at adobe for that bad things better get happy for the good things. Nice one Adobe!

2009-11-11T15:04:00.002-07:00

Coldfusion Report Builder Frustration

In my detail band I want to eliminate the blank lines when a field has no value. I my situation I return a lot # and subdivision and often times there isn't any listed so the line is blank. I don't want a blank line to show up. In Crystal Reports they let you add sections and you can choose to not print the whole section if it is blank anyway.

Coldfusion report builder has an option "Remove Line When Blank" but it flat out does not work for me. Nothing is removed. Whatever the secret combination of options is to make this work, I can't figure it out. C'mon Adobe, we really need this tool, please upgrade and fix it.

2009-10-29T09:54:00.005-06:00

Salesforce.com frustration

We are nearing our limit of 1GB storage space in salesforce.com. I emailed my sales rep about increasing storage and his reply was $1500 for an additional 1GB. After some frantic screaming (by me) he said he had made a mistake and new pricing was actually$750. Anyway it sent me on a tyraid because I feel such a sense of vendor lockin with salesforce and such a prisoner to their EXPENSIVE product line that I did some research on alternatives. My post to a blog that sums up my problems very well eplains my thoughts pretty good. We are currently at 95% usage. See image below for our actual usage right now.

Blog Post: http://forcemonkey.blogspot.com/2009/08/salesforcecom-data-storage-space.html

My Comments:

Great post. This is exactly the problem we have and our stats look exactly like yours. 61% used up in tasks, and our usage grows about 5-7 % per month. Problem is that 15 of our users are sales people who call, email and do stuff all day long. So 50 - 80 tasks is nothing when you consider, emails, calls etc..

It is pretty scary the strangle hold salesforce is applying to my company. The quoted price for more data was at first $1500 per year for 500 meg, but after screaming loud enough he told me he made a mistake and the new pricing was $750. We have 30 users and pay approx $36,000 per year for salesforce. In a world where google gives me 17 GB free, salesforce should be a little more liberal with their storage space. They aren't the only kid on the block any more either.

I could save 70% with sugarcrm and 88% with zoho. Admittedly, especially since we are so comfortable with it, salesforce is still top dog (in my opinion) and worth some extra bucks. But at some point you break the camels back. Then you give up a few features (increasingly fewer) to save $25 to $30 K per year.

2009-10-26T14:15:00.002-06:00

Using IIF with ColdFusion Report Builder

I was trying to do some conditional logic in coldfusion report builder and having some problems. Evidently the problem was with my misunderstanding of IIF. I was trying the following:

IIF (len(myvar), myVar, myVar2)

The way IIF works is that it expects strings, indicating variables, which to me is counterintuitive. But the solution that worked was:

IIF (len(myvar), 'myVar', 'MyVar2')

This evaluated to the correct values of those variables and works great.

2009-10-26T10:10:00.003-06:00

Inserting a Line Break in ColdFusion Report Builder

I had a field that I wanted to insert a line break. This field needed to be dynamic in it's sizing and it is very possible that it will have to wrap. So It was not an option to just place another field box or textbox below the current one, because if it wrapped and expanded, then the text would flow over the box below.

So I needed a way to force a line break inside the expression builder.

Turns out I just needed to insert a "Chr(10)". More detail: query.fieldname & Chr(10) & ' more text here if you want'

That worked great and now the size of the text in query.fieldname doesn't matter. If it wraps everything is just pushed down, as I wanted.

2009-10-21T07:43:00.002-06:00

Screen Capture and Screen Recording Free Software

Ray Camden posted to his blog using a demo he recorded using the following software to record his screen: http://www.jingproject.com/.

Recording is capped at 5 minutes in both the free and pro version. The pro version is only $14.95 per year. Since it is capped it won't work for long demos. But for short instruction clips or demos of individual items it looks like a great tool, and such a good price.

2009-10-21T07:33:00.004-06:00

Displaying the Copyright Symbol &copy in Coldfusion Report Builder

I wanted to display the copyright symbol in coldfusion report builder. We put that at the bottom of each page in our report to state our copyright protection of our content. This took me a while to find, but it is simple. I created a query field and added the following to that field:

chr(169) & ' Copyright 2009 Companyname'

The chr(169) was the trick.

2009-09-08T00:26:00.002-06:00

mySql server won't start after upgradge to mac osx 10.6 Snow Leopard

After upgrading to Snow Leopard the mySQL server would not start. I found the solution here:

http://www.macintouch.com/readerreports/snowleopard/topic4883.html. You have to search down the page to find the solution, search for Ralph Martin or mySql.

The upgrade to Snow Leopard seems to have broke the symbolic link.

Ralph Martin
I too found that MySQL wouldn't start after upgrading to Snow Leopard.
The answer seems straightforward. Previously there was a symbolic link from
/usr/local/mysql
to
/usr/local/mysql-5.1.37-osx10.5-x86_64
and this seems to have been deleted by the upgrade process.
I got MySQL working again by doing
cd /usr/local
sudo ln -s mysql-5.1.37-osx10.5-x86_64 mysql
(note that you may have to modify this slightly if your MySQL is a different version).

2009-08-02T23:15:00.003-06:00

Show hidden files in finder

There are many times when I want to see hidden files and folders when using my mac. When making changes to the Apache config is one of those times. So how do I make it so I can easily see those files? I found talk of this on this page:

http://www.macworld.com/article/51830/2006/07/showallfinder.html

Which has a link in one of the comments to this nifty little program:

http://gotoes.org/sales/ShowHiddenFilesMacOSX/

I installed this and it makes it easy toggle on and off the ability to see hidden files and folders.

2009-07-20T21:09:00.002-06:00

Fixing the IE 8 warning - ‘Do you want to view only the webpage content that was delivered securely?’

Ever since upgrading to IE8 this warning has been driving me crazy. It pops up on almost every page I visit. I found a great article on how to disable it and program for it.

http://blog.httpwatch.com/2009/04/23/fixing-the-ie-8-warning-do-you-want-to-view-only-the-webpage-content-that-was-delivered-securely/

2009-04-23T09:19:00.002-06:00

Returning SQL and other query metadata

I wanted to return the sql from a query that I was running to find out why no records were returned. Found information here about query metadata that not only returns the sql run at the server, but tells you about returning the parameters too.

qryTest.getMetaData().getExtendedMetaData().sql

qryTest.getMetaData().getExtendedMetaData().sqlparameters

2009-04-20T12:25:00.001-06:00

_f is undefined

I was getting the above error in my firebug output. It was coming from an included template that I use elsewhere on the website and I couldn't figure it out. Turns out that the page from where the cfwindow is called had a form without a name and id on it. Once I gave the cfform a name and id the problem went away and it works now.

2009-04-13T21:38:00.002-06:00

javascript function not found and cutting corners on code

I got hungup for several hours this afternoon on a couple of stupid issues. The first, I was getting a memory leak error and my browser was freezing up so that sometimes I had to restart. Turns out I did something I do alot in coldfusion, I included the end tag of a javascript tag in the emain tag like this:

I don't know why this is but I am sure there is an easy explanation that should make sense to me, but It didn't.

The other thing that took alot longer to figure out was a cfwindow that wasn't findinng the above attached .js file. I played around with the path and all sorts of stuff and couldn't figure out why it wasn't working. Because that script tag above has to be on the parent page that calls the cfwindow, not on the page that comes up inside the cfwindow.

2009-04-09T00:07:00.002-06:00

ModelGlue, Flash movie not loaded.

I am moving a site over to a MG3 site. I moved a flash movie that we have and it wasn't working. When I clicked on the movie (which I couldn't even tell where it was) I got the message "movie not loaded".

After searching the ModelGlue archives there were a few messages and they did give the answer even though it wasn't directly obvious, to me, at least. I was able to navigate directly to the html page that loaded the file, but via modelglue it didn't work.

Had to use absolute paths for all path statements, including where the file only was listed. All necessary files are in the same directory as the .swf movie, but I had to add the path to each of those, and I wasn't able to use a variable set at the top of the page either.

Example: views/page/map/myfile.swf where before it worked with just myfile.swf.

2009-04-03T08:41:00.001-06:00

SQL Server Date Formats

As part of my last post I needed to spit out the date in the right format because I was using a javascript output that I couldn't use coldfusion to format. So I needed to use coldfusion and found a great reference for formatting dates natively in SqlServer:

http://www.sql-server-helper.com/tips/date-formats.aspx

2009-04-03T08:36:00.002-06:00

SQL query join that returns only a max value in the joined table.

I have a somewhat complicated query. This query includes 4 or 5 tables. In my app, changes to the company table are logged to a company history table. I simply record the time of the update and that it was an update. When the record is created an entry is made recording the date and the type of "create.

Anyway, some records have been updated several times and I am returning search results. The user asked to have those results returned with the last updated date, which means I needed to join to that history table and return only the max(date) from records linked to the corresponding company.

The answer was to use a derived query and I found a great example here: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=102255

2009-03-23T22:51:00.003-06:00

CFDIV CFFORM and Asynchronous submitting

When you submit a form inside a cfdiv it submits without refreshing the whole page, only the cfdiv. This was working great unless I hit submit a second time while but you can use ColdFusion.navigate to fix this.

onclick="ColdFusion.navigate('#event.linkto('admin.countyupdate')#','countydiv','mycallBack','myerrorHandler','POST','countyform')"

Putting this in the onclick event of the cfform button fixed the issue. I had a hard time for a while because I didn't need the mycallback and myerrorhandler arguments, but putting empty quotes worked. I know, I should probably define them.

2009-03-20T15:14:00.003-06:00

coldfusion is not defined

I finally got my development environment setup and navigated to my local site and I got "ColdFusion is not defined" error. This had to do with being able to find the CFIDE directory for the coldfusion scripts. I had a cfmapping, but that,k I guess is not enough, I had to create a virtual directory pointing to the CFIDE directory in my IIS settings.

Got the idea from this blog entry:

http://www.mattwoodward.com/blog/index.cfm?event=showEntry&entryId=607BAA40-E199-27C4-02F5BE29E69C4318

2009-03-20T12:48:00.003-06:00

ColdFusion 8 And SQL Server 2005

I had a problem setting up a datasource for coldfusion using cf8 and sql server 2005. I read several articles:

ColdFusion And SQL Server 2005
ColdFusion + SQL Server Express 2005

It wasn't working until I went to services and started the "SQL Server Browser" service which had been disabled. Don't know why. But once I started that it worked.

Not sure which of the fixes from the article helped also, but there you go.

2009-03-20T10:00:00.004-06:00

Installing coldfusion 8 on vista using IIS

I am trying to install coldfusion 8 on my new dell laptop and it isn't working at all. It installs with no errors, but doesn't work. I can't choose a web server and even using the web server configuration tool says there is no webserver found. But the webserver does work. The fix?

http://dale.fraser.id.au/2008/05/coldfusion-8-vista-sp1-solution.html

I think the part that really fixed it was the comment about modifying the hosts file:

Fix: The c:\windows\system32\drivers\etc\hosts file has a bizarre entry:

::1 localhost

Comment it out using notepad run as administrator like so.

#::1 localhost
127.0.0.1 localhost

I added the 127 part on my own, but this did work. Might have been the combination of changing the iis options and modifying the hosts file, but it worked. I am up and running now.

2009-03-12T13:14:00.003-06:00

DTSWizard.exe and Business Intelligence Development Studio

I have always hated the fact that it was so difficult to do a simple import into sql server with the new version 2005 stuff, like the management express studio. A year or so ago I spent time looking all over for dtswizard.exe and since I just got a new computer from dell I was doing the same thing. It started because I simply wanted to move some data over from excell to a 2005 sql server database.

This use to be a piece of cake in SQL 2000. You just right click on the database and choose import. No idea why microsoft would turn this into such a nightmare.

After spending the last 2 1/2 hours on this I finally find out, I think, that Business Intelligence Development Studio is where this functionality lies. Couldn't figure out how to find that. Normal install doesn't always do it. Found this forum here: http://social.msdn.microsoft.com/Forums/en-US/tfsreporting/thread/eac00857-a7af-4075-aa31-e52335c59304/

The post by a.netAvoider is what worked for me:

Thanks guys,I got away with only uninstalling Workstation components. This way you won't lose your database settings and save yourself a whole lot of installation time.To do this I opened Add/Remove programs from Control Panel, selected SQL Server 2005 Express, clicked on uninstall, and in the uninstall dialogue box which appears next unticked SQL Server 2005 instance and selected Work Station components in the list below.The I installed BIZ DEV using SQL Express Toolkit installation file. I just downloaded it now ( 17/12/2007 ). You'd hope microsoft would have fixed this issue in 5 months.

2009-02-08T10:46:00.004-07:00

Model-Glue 3 (Gesture)

I can't believe I am so late to the party on this, but Model-Glue 3 has been out in Alpha for 8 or 9 months now and it has some really cool features. Features that are simply amazing and will surely save lots of people lots of time. Over the weekend I stumbled across a you tube video demo (Scroll down the page to theMG3 Feature Sneak: Event Generation Video) by Joe Rinehart. Really, the thing that I wanted to try out so bad was the auto-generated code. You have to be in development mode, but you type an event into the url and if it doesn't exist MG3 creates all the best practice code that you need to make that event work. It makes an entry in the modelglue.xml, controller and view files. It even creates the controller if it needs it. Very Cool. I also so a quick touch on SES url's in that video which was interesting. This is something I have needed for quite some time.

Ray Camden has a great blog post on these many features, I think he wrote it while siting in a presentation about this, so it isn't exhaustive but it gives you a great launching pad to find out more. His blog post is here http://www.coldfusionjedi.com/index.cfm/2008/5/2/ModelGlue-3--The-New-Frakin-Awesomeness.

One of the responses on that page shows exactly how to get SES url's working:

2009-02-08T10:36:00.002-07:00

Forbidden You don't have permission to access / on this server

I have been using this mac more and more. In fact, I hooked up to the monitor,keyboard and mouse, that were attached to the docking station for my dell laptop (Which isn't working right now) and used the mac all day on friday. No problems other than the keyboard quirks that still drive me nuts.

Anyway, over the weekend I saw a demo by Joe Rinehart on the new Moldel-Glue 3 (gesture) that has been out for some time in alpha release. I really wanted try a couple of the features, so I continued something I had briefly tried a while ago, and that is setting up virtual hosts on my mac to point different urls to different directories on the computer. I found alot of information on that and made what I thought were the correct changes as indicated in the various articles. (this is a whole other blog post). But whenever I tried to pull the new site up in a browser I got the error: Forbidden You don't have permission to access / on this server. I probably spent 4 or 5 hours changed in my settings and stuff, until finally I just moved my files to /Websites/myweb. The problem all along had to do with accessing directories in the /users directories, which is where the files I originally wanted to access were located. There were some articles on making this work, but I didn't mind just moving them to a lower directory that would be easier to find anyway.

2009-01-22T13:39:00.005-07:00

Blackberry Storm Upgrade

I recently upgraded from a blackberry 8703e to the new storm, I did this around December 10, 2008. First, transferring contacts and calendar was awesome, easy, fantastic. I use google synch to synch my contacts and calendar with my google apps calendar and contacts, so All I did was install google synch on the new STORM, entered my credentials and it did take a try or two (there was alot to synch) all my stuff was there.

I was severely disappointed with the battery life of the storm. But after a few days, the battery life was fine. I attribute that to overusage cause it was new and maybe battery conditioning. At first it was only lasting about 12 hours, and since I unplug it between 5 and 5:30 AM, that means it was shutting off on my way home from work around 5 or 6 pm. It now consistently lasts until midnight which is when I usually plug it in. Sometimes I plug it in for the night earlier and once in a while later, but there is still juice left when I do.

I think it uses alot more juice when you actually use it, but when it is just in your pocket or the holster, it sleeps pretty good, if you are in a digital area.

I like this phone, I don't love it. It is slow and I often have to wait for it. My brother-in-law got one and traded it in for the curve, and to tell you the truth if I had that option now I would go with the curve. The new affect was fun and it is a pretty cool phone, but it lacks in functionality because of the slowness and usability of the interface. It has froze several times, even during a phone call twice.

2009-01-22T13:17:00.003-07:00

Adding All Option CFSELECT

I am creating a web page that makes use of related cfselect's. This is a handy feature of coldfusion that allows the contents of one select box to be dependent on the contents of another. For me that means I have one select that lists areas that our company covers. Another box lists the counties we cover. Using the related selects the counties will only show for the area selected in the first box. Very nice. I also link a jurisdiction select to the counties select.

I wanted to add a default "All" option to these selects. Colfusion has an atribute for CFSELECT - queryposition which you can set to above or below. This works great if you are not using the bind attribute in CFSELECT. I was using bind to connect those cfselects so I had to find another way to add "All". I found a comment on Ben Forta's Blog by Matt Bennett that gave me sample code like the following which I adapted slightly for my own use:

sortArray = ArrayNew(1);
QueryAddColumn(qry, "sort_order", sortArray);
QueryAddRow(qry);
querySetCell(qry, "name", "All");
querySetCell(qry, "id", "0");
QuerySetCell(qry, "sort_order", "1");

SELECT *
FROM qry
ORDER BY sort_order desc, name asc

Works great, I just added that code after the qry I was already returning and boom, success.

2008-12-01T15:05:00.005-07:00

Export to CSV with Coldfusion

I am trying to finally get a good export to CSV working, using coldfusion. There are alot of posts, many of them by Ben Nadel.

Ended up using the example from: Converting A ColdFusion Query To CSV Using QueryToCSV()

This worked great except there were lots of blank rows at the top of the file and at the bottom. The fix was found here: Extra white-space after page proccess

<cfcontent reset="yes"><cfoutput>#Trim (yourvar)#</cfoutput><cfabort>

It was important to put it on one line to, otherwise there was an extra line for each line return.

2008-11-27T01:44:00.002-07:00

CF 8 - "ColdFusion is not defined" JavaScript Error

I am trying to get ajax select dropdowns to work in coldfusion 8. I eventually want them to be related also. That is, the results of the second are based on the choice in the first. Well hit a wall and couldn't get the data to show up. using a test page I was able to return the correct results with a cfinvoke of the .cfc, but no data in the selects.

I didn't have firebug installed on this computer, so I went and got it and looking at the javascript error's I saw the error: CF 8 - "ColdFusion is not defined" JavaScript Error. Google that and I found the following that explained the cause:

CF 8 - "ColdFusion is not defined" JavaScript Error

The solution was to not only have a cf mapping to the cfide directory (which I already had) but also a web server virtual directory (which I didn't have). I added the virtual directory and it works.

2008-11-26T22:19:00.001-07:00

How to restart Apache on the Mac

Made a change in the httpd.conf file and wanted to restart the Apache server to pick up the changes. How did I do that?

Open up the terminal window (/applications/utilities/terminal)
Then Type: sudo apachectl restart

Seems to have worked for me.

2008-11-26T21:50:00.003-07:00

Location of httpd.conf for Apache on the mac

It is hard for me to find things on this mac still. Some of the stuff is hidden and it always takes me a while to get around. The last thing I was looking for was the httpd.conf file for the apache web server configuration. I wanted to see where the webroot was. Then maybe change it.

Anyway, it was at /private/etc/apache2/httpd.conf.

Amazing how many posts I saw asking this same questions.

2008-11-24T08:42:00.002-07:00

Start and Stop ColdFusion and othe services.

One of those little nuggets that I picked up at the adobe conference was leaving services you don't always use stopped until you need them. Like coldfusion for instance. I will get developing and use coldfusion locally for development for days at a time. But, I don't always use it, so there is no need for it to be running if I am not using it.

Quick search and I found this: Batch files for Starting and Stopping ColdFusion.

In Vista I had to use "Run as Administrator" for those to work, but they did work like a charm. Took a long time on the main CF service the first time, but it did eventually work.

2008-11-24T08:33:00.003-07:00

Dreamforce, Adobe MAX, and BIS in Long Beach

I have been out of town 4 days each of the last 3 weeks attending one show and 2 conferences.

First was Dreamforce. Salesforce.com's annual big event. This was fantastic. I am amazed at what salesforce.com has been able to do with their platform. We have been using salesforce.com since April and I can't imagine being without it. They really have a fantastic vision and have been able to grow their business and keep most of their customers happy.

One of the Big announcements was salesforce sites. Public facing web pages that your customers can access without loggin in. Before, any access to salesforce was via controlled login access. Now you will be able to design pages for the public based on your salesforce data. This does have tremendous possibilities, especially if I was to ever move my data entry app into salesforce. We will see. But all the other stuff was cool. I learned alot and they treated us like royalty. Tons of food all the time. Free shirts, books and more. I have never before been treated so good as we were treated at Dreamforce. They seem to really care about their customers.

The second week I was at BIS in Long Beach. This is a builders show where we buy a booth and market our magazine. We also walk around and speak with other booths. This show is a good place for us to get our name out and we had pretty good success with it last year.

The 3rd week (last week) was the Adobe MAX user conference. I went to this one when it was in Salt Lake about 4 or 5 years ago. This conference was great also. They had decent food, although not as good as dreamforce and the content was above average. I learned alot and got to shake hands with and meet some of the top coldfusion guys. I am sure there a great minds in everywhere, but I feel we have some great ones in the coldfusion community.

Both these conferences where held at the Mascone Center in San Francisco. This made it easy for me because I was a little familiar with the area since I went there in late Sept for a salesforce.com administrator test.

2008-11-24T08:26:00.002-07:00

Mac drives me crazy 1/2 the time and I love it 1/2 the time.

I have not posted forever. Probably because this macbook pro drives me absolutely nuts sometimes. After slowly getting use to the different key combinations I can actually get around ok, although I still have alot to learn.

The battery lasts for about 3 hours, maybe slightly more, depending on what I am doing. This is great. It does run fast. But to be fair a new pc laptop with the same config would probably do the same. It wakes up from sleep mode faster than I think a pc with windows ever could. And it is sleek and cool.

But, I can't beleive how hard it is to use some of the dvd/movie features. I have tried to create dvd's from a panasonic mini-dv camera and it has been a frustrating nightmare. Even once you learn how to do it there are quirks that drive me nuts. If you don't catch some of the subtle things, it just fails and you don't know why. Thank goodness for my daughter's basketball coach, she figures it out, even thought it sometimes takes her a while too.

Anyway, my macbook pro isn't going away. But it won't be my main machine anytime soon.

Oh, one huge plus is the touchpad. Dragging 2 fingers scrolls. 2 Finger touch is like a double click (Although Steve Jobs is crazy for not just putting 2 stupid buttons on there in the first place). With the pc I ALWAYS pull out the wireless notebook mouse. With the macbook pro I am more comfortable with the trackpad because it is so responsive and nice. I catch myself trying to 2 finger drag back on the pc and it doesn't work.

2008-08-28T23:26:00.003-06:00

Installing mySql on Mac OSX Leopard

Just got done installing mysql on my macbook pro. Installation went just fine. Followed the same document that also had php installation instructions. Click here to view that document again.

I accepted all the defaults and have not yet gone through the instructions for connecting to php. A couple of places I stumbled only briefly. As mentioned in the article I downloaded the MySQL GUI Tools. This gives a visual interface and will definately work better for me as I still have no clue to all the command line stuff on this mac. After installing the gui and clicking on the MySql Administrator app in the applications folder I was given the option for a server and username and password. Server Hostname can be set to "localhost" and username to "root". Then you can change the password when you get in there.

Very simple. Now I gotta learn the interface.

2008-08-28T21:30:00.004-06:00

Installing Coldfusion 8 on Mac OSX Leopard

I just installed coldfusion 8 on my macbook pro and didn't have any problems. I read through this post first and it had instructions, but all the settings in that article were the defaults so I just clicked through and it installed no problem.

I am, once again, not sure about the directory structure. Not sure if the default /library/documents/webserver is the best place but it does work, at least the CF administrator does.

I installed the 64 bit version. The way I understand it is that with the core 2 duo processors you can get the 64 bit versions of the files

Now on to mySql.

2008-08-28T08:08:00.004-06:00

Viewing Hidden Files

I Figured out how to view hidden files, but it wasn't easy and I am still not 100% comfortable with it. I followed the instructions here: http://guides.macrumors.com/Viewing_hidden_files_on_a_Mac but that did not seem to work. I wanted to just use finder to see the hidden files. When I typed in the suggested commands, I didn't get an error but it is definitely not working. So I resorted to downloading a couple of additional programs. Textwrangler and Coda.

I actually downloaded Textwrangler first and struggled a little so I began to download coda. Before it finished I had figured out Textwrangler so that is what I ended up using. From the textwrangler menu you choose "File/Open Hidden". After that it still isn't easy as I still am learning to understand directory navigation on the mac. I was able to find the private directory by clicking on the "Macintosh HD" in finder. It would be more intuitive at this point if it would have been under Desktop, Home, Applications or Documents which is where most stuff seems to be.

I haven't got back to using this (modifying hidden files) yet, but I will and I think I will be alright now. I still need to install mysql and coldfusion.

I did get php working by just modifying one line as instructed here: http://reverbisnotalie.com/code/php-mysql-apache-mac-osx-leopard

2008-08-24T23:21:00.004-06:00

Apache, ColdFusion 8

I want to install apache and coldfusion 8 on my mac so that I have a complete development environment on this machine. I enabled web sharing which I think is apache and It works. But I can't find the apache directories. It looks like you have to make hidden directories and files viewable and I did that as instructed here:

Viewing hidden files on a Mac

But I still can't figure out where the http.conf apache file is. This is not easy so far, unless I am just missing it.

2008-08-21T14:48:00.004-06:00

Gmail on a Mac

This one is going to drive me nuts. On a pc using gmail you can type an email, press tab and then enter and it sends the email. When you press tab it moves focus to the send button. On this mac that doesn't happen. Tab never performs like I expect, at least on web pages. Driving me nuts. Funny how such a little thing can make such a difference. But I at least need a comparable key combination so I don't have to touch my mouse in gmail.

----------------
Just found the answer to this. System Preferences/Keyboard & Mouse/Keyboard Shortcuts then at the bottom you see "Full Keyboard Access". Make sure you choose the "All Controls" option and it works like a charm. Wahoooo!

2008-08-20T09:05:00.002-06:00

Touchpad greatness

Just reading through the little white booklet that was the only documentation that came with the macbook pro. The info from that booklet that I liked the most was the info on the touchpad. Two fingers sliding will scroll up and down or side to side. Two fingers and click is like a right mouse click. I also enabled touch click in system preferences because I prefer to just tap the touchpad instead of having to use the button, which can be awkward for my thumb. Three fingers does something too, but I can't remember what.

2008-08-20T09:01:00.003-06:00

Mac Spaces

Just started using spaces. This is a cool feature where essentially you have 4 desktops and can easily switch between them. I will probably use this more as I get use to it. I might have email in one, eclipse for coding in another etc...

Even with this 15" screen there is not alot of screen real estate available with the dock and a few desktop icons you don't want to cover up. Spaces will make this easier to deal with.

2008-08-20T09:00:00.002-06:00

Lighted keyboard

The macbook pro's lighted keyboard is sweet. With my dell I always had to angle the monitor down to be able to see the keyboard in the dark. Not with my mac.

2008-08-20T08:54:00.002-06:00

Save pdf to web receipts folder

My Macbook pro has a cool feature. When you print a web page you can click on the pdf button and there are several cool choices. The one I just used "Save pdf to web receipts folder" is a great time saver and very convenient. How many times do you just want to do that. In windows there are a few extra steps and I think you have to have adobe acrobat pro in at least some cases.

2008-08-19T13:04:00.002-06:00

unable to load default svn client

Installed Eclipse no problem. Although I did install the latest version, Ganymede first. But I installed the latest Europa (3.3) once I found out that CFEclipse doesn't yet work with Ganymede (3.4). I then installed the SVN client and it seemed to go well. But I was getting an error "unable to load default svn client" error.

Found a little help here: http://subclipse.tigris.org/servlets/ReadMsg?listName=users&msgNo=12087

But I already had installed JavaHL and still I was getting the error. But after installing SVNKit (there were 2 and I chose both, a client and something else) it worked. Another problem solved.

2008-08-19T07:58:00.002-06:00

No Docking Station

It looks to me like there is not a docking station available for this macbook pro. That is a shame. Apple seems to have it all going on and then they don't have docking stations. I currently use my dell latitude laptop primarily between 2 different offices. At each of these offices I have docking stations with external monitors, power, network and other accessories hooked up. It is VERY simple to just drop the laptop onto the docking station and I am off and running. This is a big minus for the mac.

2008-08-19T07:55:00.003-06:00

Cool Power Adapter Connector

This is one of those little things that don't matter much, but I notice. The way the power cord hooks into my mac is pretty cool. It is magnetic so once you get close it kind of grabs it and inserts right to where it needs to be. Makes it easy to plug it in.

That's lost a little in the enormity of the whole power aparatus itself. I am use to the dell power adapters that have a nice way to wrap both sides of the cord around itself.

2008-08-18T19:57:00.002-06:00

Mac Crash

So, I am a little confused about if I can just shut the lid and this mac will go into sleep mode, or what. I have no idea how to tell what it is doing. So far, this is one big deficiency. I have no insight into the workings of this machine. I even find myself missing the disk actvity light, even though it doesn't mean much, at least I know something is going on.

Anyway, I left my house to go over to the in-laws and chose sleep from the apple menu. When I opened it back up at the in-laws it just froze. Wouldn't do anything for 3-5 minutes. Finally just held the power button down until it restarted.

So I had a mac crash in my first day owning my first mac. I am loving the experience so far, but I think that is mostly the newness of the whole thing.

2008-08-18T19:54:00.003-06:00

Copy a DVD

I had to copy a DVD today, something I rarely do. I had no clue how to do that on the Mac. A quick google search found: http://www.kenstone.net/fcp_homepage/making_dvd_copies.html.

That article gave me enough info to copy the DVD. I actually got it going and forgot it was running. The mac is much better at copying a DVD and allowing my to work unhindered while that is happening.

2008-08-18T15:38:00.003-06:00

VMWare Fusion

Ok, now this is cool. I bought VMWare Fusion at the same time I bought the macbook pro. I just got done installing Windows Vista as a virtual appliance. So essentially now, I can switch over to windows vista at any time. Very cool. I plan to install Windows XP and Ubuntu also. Windows XP just to support my clients, and Ubuntu for fun.

I think I can take a snapshot of my pc and install a virtual machine that is just like my pc, with all programs and everything, but this time I did a fresh vista install for testing. It was slick.

2008-08-18T14:45:00.003-06:00

CTRL-End and CTRL-Home

I didn't realize how much I use these two quick key combinations until they weren't there on the mac. The mac version of these is cmd-LeftArrow and cmd-RightArrow. Cmd stands for the key labeled "command" on my macbook pro. I think this is also referred to as the apple key. cmd-uparrow and cmd-down arrow seem to move you to the top and bottom of a document.

Good to have these committed to memory. They are very useful. Now if I could just figure out the tab key in gmail. That is a big one for me.

2008-08-18T14:34:00.002-06:00

Performance Monitor for Mac

What started this was my desire to make sure they really gave me the 4gig memory that I paid for. I was trying to find out the easiest way to get that information on the Mac. In windows you simply right click "My Computer" and get alot of that information right there. Ctrl-Alt-Del / Task Manager also gives you that stuff.

Google lead me to this: http://www.mac-forums.com/forums/showthread.php?t=120126. Which essentially mentions the activity monitor in Applications/Utilities and also the free download from apple.com called istat: http://www.apple.com/downloads/dashboard/status/istatpro.html.

This little app was free, installed very easily and is accessed by clicking on the dashboard icon 2nd from the left on the dock, or whatever that line of apps is called.

I still struggle getting around on the Mac. I installed VMWare and was confused, although I can tell it will be fine after a couple shots at it.

I got a message from VMWare that there was a newer version, but I clicked away the error and for the life of me I cannot find the mac version of Help/About. I just want to see specific versions so that I can identify upgrades.

2008-08-18T13:15:00.003-06:00

I bought a MAC!

For years I have been considering purchasing a Mac computer. I am a laptop guy, so usually my thoughts have been for a macbook pro. I finally did it. Today, it arrived and I am already using it. I type this blog entry from that new laptop.

I am going to try and document stuff as I learn. I don't plan on completely switching to mac, but I do want to make sure that I have personal experience with both types of computers. But if I love it, who knows!

The first problem was that I wanted to highlight the whole URL in the browser window. In Windows I click the end of the URL and then I could press ctrl-home. I searched for ctrl-home for mac, but came up with cmd-L. This will jump to the URL and highlight the whole thing.

I still need to figure out the equivalent of ctrl-end and ctrl-home. Plus the tab key doesn't seem to work the same, especially in gmail.

2008-06-24T21:41:00.002-06:00

Even My Wife has a blog.

My wife said that her Sister set her up with a blog today. We will see. She even acted like she was going to post. We will see. If she starts posting then I will have to be better about posting to my own blog.

Citi sends unrequested credit cards - USATODAY.com

2007-10-09T06:54:00.000-06:00

Citi sends unrequested credit cards - USATODAY.com

My wife just got a new credit card in the mail. I was stunned. I asked her if she had requested it and she said no. This is just bad business. Very upsetting that a company could get away with this. How will this affect our credit? Is there an opportunity for identity theft? Maddening. This shouldn't be allowed. The name Citi will now take a position on my "bad" list of companies I will not have anything to do with.

2007-09-27T10:29:00.001-06:00

I want to be able to connect to the computers on my network. And I
want to do this even from outside the firewall. SBS 2003 has a great
web interface to launch this at http://yourdomain.com/remote.

But it wasn't working. I was getting the error: "Connectivity to the remote computer could not be established. Ensure that the remote computer is on and connected to the Windows Small Business Server network."

I found the solution here: http://techrepublic.com.com/5208-6230-0.html?forumID=101&threadID=227304&messageID=2263999

"Remote Connections
I've seen this error too many times when I don't enable remote
coneections on workstations. The connection is being made, otherwise you would not get that error. Check and make that "Allow users to connect remotely to this computer" is enabled. This is found on the Remote tab of my computer. As soon as I tenable it, I can remote login to workstation. This has worked for me every time without fail. "

This worked great and now I can connect to the machines that I want to connect to.

--
----------------------------
David Mineer Jr
Construction Monitor
435-586-1205 x101
----------------------------------------------------------
The critical ingredient is getting off your butt and doing
something. It's as simple as that. A lot of people have ideas,
but there are few who decide to do something about them now.
Not tomorrow. Not next week. But today. The true entrepreneur
is a doer.

2007-08-29T16:12:00.000-06:00

iGoldmine and Log On Local Rights.

After getting iGoldmine configured and allowing access through the firewall, I had a problem with regular users loggin in. I could, as an administrator, but my other users could not.

The first article I saw had me pull up the local Security settings Management console. I can't remember how they had me do that. But, when I clicked on "Allow log on Locally", the option to "Add user or group" is grayed out.

I found another article here. Here are the steps to use the Default Domain Controller Security Settings instead. This gave me the choice to add users or groups.

Click Start, point to Programs, point to Administrative Tools, and then click Domain Controller Security Policy.
Double-click the Security Settings folder, double-click Local Policies, and then click User Rights Assignment.
Under the Policy column, click Allow Log on Locally, and then click Add.

I created a group called iGoldmine and added it to this policy. Now any user I add to that group can use iGoldmine.

2007-08-29T15:36:00.001-06:00

ISA 2004 and iGoldmine

A few months ago I moved my sales staff to a new server. This put them on a seperate network with it's own internet connection. I have needed to get iGoldmine up and working but I had not done that. Until today. And it was a pain, which I actually started day before yesterday. The first nightmare was that my machine wouldn't reboot after installing iGoldmine. Turns out they have an incompatibility with one of the microsoft updates.
This is always a problem with goldmine. I am not real pleased with igoldmine but I have no other options owing to the fact that we use goldmine and want remote access. Anyway, the solution was to apply the iGoldmine patch in safe mode. Then I had to remove an icompatible windows patch after that. Pain in the but. This is a patch from back in April, 4 months ago. You would think they would get it fixed.
Anyway, after getting it installed, it worked from inside the firewall, but not outside. Goldmine tech support of course was of no assistance and said they dont' support firewall configurations, which is typical of their support, they are extremely unhelpful even though I am sure they have thousands of customers with the same issues. I didn't find much, other than people asking the same questions, in the forums.
So here is how I finally got iGoldmine working through my ISA 2004 firewall(I know you might think it so much more than a firewall and it may well be, whatever).
I am on Small Business Sever 2003, if that makes any difference to you

Open "Microsoft Internet Security and Acceleration Server" Management Console.
Click on your server
Click on "Firewall Policy"
Right click and chooose New/Access Rule (or click "Create a New Access Rule" int he task menu.
Name it what you want, I chose "iGoldmine". Click Next
Choose "Allow". click next.
For "This rule applies to" choose "Selected Protocols"
Click Add
Now you are at the "Add Protocols" Window.
You will notice at the top of the protocol "type" list there is 3 menus. New, Edit Delete. Edit and Delete may be grayed out if you haven't selected a protocol
Click New, then Choose Protocol
Give it a name, I like to confuse myself so I called it "iGoldmine". Same name, but this is a protocol and not an access rule.
Choose New in the "New Protocol Definition Wizard"
You want the following: Protocol Type:TCP, Direction:Outbound:Port Range from 491 to 491. Probably the only changes you need to make are to the port range values, the rest are probably defaulted correctly.
Click Ok
Click new again
This was the one that got me. You need an inbound filter for port 80.
Protocol Type:TCP, Direction:Inbound, Port Range From 80 to 80. If you don't use port 80 you will need to change this in the iGoldmine cluster manager, but you do have that option
Click ok
Click Next
Choose No on Secondary Connection, Click next.
Click Finish
No to add them you will need to find them in the "Add protocols" window. Probably the easiest is to choose All protocols and find them in alphabetical order. You ned to choose the ones you just added and click add to add them to the protocols section of the New Access Rule Wizard.
Click close once you have done that.
Click next
Access Rule Sources. Choose External. Click next
Access Rule Destinations. Choose "Local Host"
Click next
Leave default "All Users", Click next
Click Finish.

That should do the trick. It should work immediately.
The next problem I had was giving users log on local rights. I was able to logon immediately after the above as an admin on the iGoldmine server, but regular users could not until I made some changes. I will talk abou that in my next post.

2007-08-06T23:22:00.000-06:00

"Error 15023: User or role '%s' already exists in the current database."

Got this error recently when I downloaded a clients database from a shared host to my local machine. Tried to add the same user.

This article resolved it for me: http://www.codeproject.com/database/OrphanedSQLUsers.asp.

Here is the SQl that I ran "sp_change_users_login 'auto_fix', 'user'"

2007-08-03T00:02:00.001-06:00

Tethering my Blackberry to my Laptop

When I first got my blackberry one of the things that interested me was the fact that I could "Tether" myh blackberry to my laptop. Which means that I could use my blackberry to get high speed internet access from anywhere I could use my cell phone(blackberry) Well the software to allow that didn't work with Windows Vista, so I kind of forgot about it for a while. Until today. I figured out that the motel my wife had got from hotwire didn't have high speed internet(I always try to remind her how important that is for me).

Anyway I called verizon and had them add the $15 a month thing that I needed for this to work and got instructions on how to download the software that I needed. The told me to go to http://www.vzam.net/. After driving around for about an hour I finally found an open wireless connection and was able to download the VZAccess Manager that I needed.

Wow. Here I am sitting in the middle of a big parking lot at some factory stores near Park City Utah, checking email and doing other tasks. And it was fast. I had a full bar EVDO connection and it screamed. The connection back at the motel is only 2 bars and it is bearable for email and surfing, although noticeably slower.

Turns out this "Motel" is actually condos and there was a DSL modem sitting on the floor unplugged. I plugged it in and I have DSL so I didn't even really need to set up the Broadband access with verizon, but hey I will be getting stuff done while the family is school shopping so I am going to stick with it for at least this month. Where I live, we don't have the EVDO towers. I wish verizon would get that rolled out to all their towers.

David Mineer

2007-08-02T00:54:00.001-06:00

Ten ColdFusion 8 OneLiners

Ten ColdFusion 8 OneLiners

Blog entry about some of CF8's best new features.

2007-08-01T16:24:00.000-06:00

Importing Outlook Email into Google Apps (Gmail)

Here is an article about different ways to import existing email into your new Google Apps account.

http://www.hanselman.com/blog/MigratingAFamilyToGoogleAppsFromGmailThunderbirdOutlookAndOthersTheDefinitiveGuide.aspx

This is mentioned in that article, but looks like a tool to make some migrations very simple: http://www.limitnone.com/products.php

Maybe not free, but what is your time worth?

2007-07-28T00:13:00.000-06:00

Yslow for Firebug

As mentioned in Sean Coorfield's Blog. Yslow for firebug is a great little utility to use on your own web site.

2007-07-27T23:44:00.001-06:00

The proper way to ask questions in newsgroups and other forums

Sean Corfields blog had a great post about blunt to the point article about posting quesitons to newsgroups, email lists and other forums for technical answers. I am one that is always nervous to ask a question, but this does not offend me, yet instead offers some good insight on the effort we should all take before we expect someone else to spend their valuable time helping us. There are alot of people that offer alot of help and to them I am grateful. The article:

http://www.catb.org/~esr/faqs/smart-questions.html

2007-06-26T13:55:00.000-06:00

Problem Rotating Images

Several Times my users have complained to me that they were unable to rotate images using windows picture and fax viewer. This seems odd to me because they can rotate other pictures, just not some.

Anyway I found an article that provided the fix for this:

http://groups.google.com/group/microsoft.public.windowsxp.photos/browse_thread/thread/bf93b6a7f38c2520/68e7606cddf2dd30%2368e7606cddf2dd30

Just click the ctrl and X button in windows picture and fax viewer and it will reset the warning message, which, if you choose yes to go ahead anyway will rotate the picture.

Yep, as simple as getting the dialog box back. I guess you just have to answer the dialog box each time.

2007-05-29T15:05:00.000-06:00

Next N records, paginated sql server results

I have several places on my web site where I let the user page through search results and recordsets. Usually this is inneficient because your return all resulsts and essentially hide everything but the rows they want to see. This is very inneficient and the only examples of doing this correctly were difficult at best.

Well, with SQL Server 2005 there is a new feature - ROW_NUMBER() that makes this simpoler to implement. Not 100% intuitive but I was able to figure it out. The following link is a good tutorial that helped me:

http://www.davidhayden.com/blog/dave/archive/2005/12/30/2652.aspx

2007-05-24T15:59:00.000-06:00

Dynamic SQL Where statements

I was trying to figure out how to use an if statement in the where clause of a sql statement. I came across this article that explains the use of coalesce. This is a great way to handle this.

http://www.sqlteam.com/item.asp?ItemID=2077

SELECT Cus_Name,
Cus_City,
Cus_Country
FROM Customers
WHERE Cus_Name = COALESCE(@Cus_Name,Cus_Name) AND
Cus_City = COALESCE(@Cus_City,Cus_City) AND
Cus_Country = COALESCE(@Cus_Country,Cus_Country)

Read the article to understand it. Basically if there is a value provided to the stored procedure then the comparison is done. If there is no value it essentially includes all records or (matches itself). I know, that doesn't make sense.

2007-05-17T17:45:00.000-06:00

Setting Parameters in Crystal Reports .NET

Well, I missed the post about setting parameters. That was one of the puzzle pieces too and I got lazy and didn't post about it. Here it is.

Setting Parameters in Crystal Reports .NET

A number of methods out there use the CrystalReportViewer control to set parameters. That's great unless you need to export your report to PDF (or XLS or RTF). This is a code snippet I use, it comes from Business Objects tech support:

rptCount = New ReportDocument
rptCount.Load(Server.MapPath("reportname.rpt"))

''Get the collection of parameters from the report
crParameterFieldDefinitions = rptCount.DataDefinition.ParameterFields
''Access the specified parameter from the collection
crParameter1 = crParameterFieldDefinitions.Item("Param1")
crParameter2 = crParameterFieldDefinitions.Item(“Param2")

''Get the current values from the parameter field. At this point
''there are zero values set.
crParameter1Values = crParameter1.CurrentValues
crParameter2Values = crParameter2.CurrentValues

''Set the current values for the parameter field
crDiscrete1Value = New ParameterDiscreteValue
crDiscrete1Value.Value = Request.Form(“param1value“)

crDiscrete2Value = New ParameterDiscreteValue
crDiscrete2Value.Value = Request.Form(“param2value“)

''Add the first current value for the parameter field
crParameter1Values.Add(crDiscrete1Value)
crParameter2Values.Add(crDiscrete2Value)

''All current parameter values must be applied for the parameter field.
crParameter1.ApplyCurrentValues(crParameter1Values)
crParameter2.ApplyCurrentValues(crParameter2Values)

2007-05-17T17:42:00.000-06:00

Crystal Reports Database Login

The last major piece of my puzzle. This code lets me pass database and login information.

http://diamond.businessobjects.com/node/134

VB.NET
---------

Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.Shared

Dim crtableLogoninfos As New TableLogOnInfos()
Dim crtableLogoninfo As New TableLogOnInfo()
Dim crConnectionInfo As New ConnectionInfo()
Dim CrTables As Tables
Dim CrTable As Table
Dim TableCounter

'If you are using a Strongly Typed report (Imported in
'your project) named CrystalReport1.rpt use the
'following:

Dim crReportDocument As New CrystalReport1()

'If you are using a Non-Typed report, and
'loading a report outside of the project, use the
'following:

Dim crReportDocument As New ReportDocument()

crReportDocument.Load("c:\myReports\myReport.rpt")

'Set the ConnectionInfo properties for logging on to
'the Database

'If you are using ODBC, this should be the
'DSN name NOT the physical server name. If
'you are NOT using ODBC, this should be the
'physical server name

With crConnectionInfo
.ServerName = "DSN or Server Name"

'If you are connecting to Oracle there is no
'DatabaseName. Use an empty string.
'For example, .DatabaseName = ""

.DatabaseName = "DatabaseName"
.UserID = "Your User ID"
.Password = "Your Password"
End With

'This code works for both user tables and stored
'procedures. Set the CrTables to the Tables collection
'of the report

CrTables = crReportDocument.Database.Tables

'Loop through each table in the report and apply the
'LogonInfo information

For Each CrTable in CrTables
CrTableLogonInfo = CrTable.LogonInfo
CrTableLogonInfo.ConnectionInfo =
crConnectionInfo
CrTable.ApplyLogOnInfo(crtableLogoninfo)

'If your DatabaseName is changing at runtime, specify
'the table location.
'For example, when you are reporting off of a
'Northwind database on SQL server you
'should have the following line of code:

crTable.Location = "Northwind.dbo." &
crTable.Location.Substring(crTable.Location.LastIndexOf(
".") + 1)
Next

'Set the viewer to the report object to be previewed.

CrystalReportViewer1.ReportSource = crReportDocument

2007-05-10T15:41:00.001-06:00

Crystal Reports Export to PDF

Well, I finally did it. The code below is what lets me export a crystal report to a pdf file. Previous entries outline some of the steps I have taken to get here. Not sure if all were necessary but it works. No I have to figure out how to pass parameters, datasource and login information. On to figure that out.

Option Strict On
Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.Shared
Partial Class _Default
Inherits System.Web.UI.Page
Private exportPath As String
Private myDiskFileDestinationOptions As DiskFileDestinationOptions
Private myExportOptions As ExportOptions
Private myReport As ReportDocument
Private selectedNoFormat As Boolean = False
Private Sub ConfigureCrystalReports()
myReport = New ReportDocument()
myReport.Load("C:\websites\rpt\report1.rpt")
'myCrystalReportViewer.ReportSource = myReport
End Sub

Protected Sub Page_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Init
ConfigureCrystalReports()
ExportSetup()
myExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat
myDiskFileDestinationOptions.DiskFileName = exportPath & "PortableDoc.pdf"
myExportOptions.DestinationOptions = myDiskFileDestinationOptions
myReport.Export()
End Sub
Public Sub ExportSetup()
exportPath = "C:\Exported\"
If Not System.IO.Directory.Exists(exportPath) Then
System.IO.Directory.CreateDirectory(exportPath)
End If
myDiskFileDestinationOptions = New DiskFileDestinationOptions()
myExportOptions = myReport.ExportOptions
myExportOptions.ExportDestinationType = ExportDestinationType.DiskFile
End Sub
End Class

2007-05-08T06:23:00.001-06:00

Use a javascript confirm box to ask the user if they want to delete.

Found this here: http://psacake.com/web/iw.asp

2007-04-30T15:40:00.000-06:00

Crystal Reports XI on Windows Vista

http://support.businessobjects.com/downloads/service_packs/crystal_reports_en.asp

Talked to tech support about this and this was the link he gave me for the new build that is vista compatible.

2007-04-30T13:15:00.000-06:00

Crystal Report Viewer missing images

I think I mentioned in a previous post that I had done the server install for the .net crystal report viewer appication or whatever you want to call it. Everything worked except for the images on the toolbar weren't showing up. I found this post concerning that which fixed my issue:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=566717&SiteID=1

Look at the post marked as the answer.

2007-04-30T09:47:00.000-06:00

Tutorial: Exporting to Multiple Formats

I have been eager to get back to the office and continue my quest to get Crystal reports exporting to .pdf. Today I worked on a tutorial to export to different format. I am mainly interested in .pdf but the tutorial went through exporting to many different formats. The link to the tutorial is below.

http://msdn2.microsoft.com/en-us/library/ms227606(VS.80).aspx

I didn't hit many roadblocks. This tutorial does not show you the exported file, it only gives you a message of success or failure. You have to browse to the location of export (Default: C:\exported\) to see the file that was created. I am sure a redirect wouldn't be too dificult, but I can do that later.

Now, on to passing parameters to the reports.

Dave

2007-04-27T16:37:00.000-06:00

Crystal Reports and the Web Part 2

Here I am 7 hours later and I have been pretty good today to focus on the issue at hand. Deploying crystal reports to my web server. I had to learn .net from almost scratch cause I have never used it before.

I did it. Got it working. If I had to do it over again, I could do it alot quicker. I hope these notes will benefit somebody.

My Setup:
Dell Lattitude D820 Windows Vista Business
Server: Windows 2003 (Hosted)

Install Visual Studio 2005. I got a free 90 day trial from Microsoft. After today I am almost positive I will buy it. Seriously, The time I saved on this one project will pay for the $700 or so that it costs. Without it I could have spent week(s). In fact I did spend several days without success last year on this.
Installed SP1 for Visual Studio
Installed SP1 Update for Visual Studio for Windows Vista(I first tried to install just this file, but come to find out you need the main Service Pack installed first.
Installed SP2 for MSSQL Server Express
Then I found the tutorial here: http://msdn2.microsoft.com/en-us/library/ms225276(VS.80).aspx
I followed the developer link.
Next I clicked on the link "Persisting the ReportDocument Object Model Using Session" This seems a little strange, I know but it has a good step by step tutorial which I followed.
You will notice all the resources on the left under the Crystal Reports heading. 80% of the information I found was from this MSDN site.
Some search results from the MSDN Site: http://search.msdn.microsoft.com/search/Default.aspx?brand=msdn&locale=en-us&query=crystal+reports
One thing I got sidetracked on was installing IIS on my laptop (Dev Machine) That is unnecessary. Visual Studio has a development web server built in. The way I found to use it was to right click on the "default.aspx" file in the solution explorer and choose "View in Web Browser". This starts the devel0pment web server and lets you view the page.
The tutorial was detailed enough that I didn't really stumble to much in that section.
On the server side I had a few problems. Yesterday I had installed Crystal Reports XI SP 2. This, I think is unnecessary. I didn't uninstall it since I already had it, but the key to making it work on the server was downloading this file: http://support.businessobjects.com/communityCS/FilesAndUpdates/crXIr2_net_server_install.zip.asp
The page with the link to that file is here: http://support.businessobjects.com/downloads/merge_modules.asp#06
I used this download: "Crystal Reports XI Release 2 for Visual Studio .NET Server Install - This file contains the Server Install file for Crystal Reports XI Release 2 for Visual Studio .NET."
That worked great, after I installed that on my server, it was working.
The only problem left was the icons on the toolbar for the crystal report viewer are not showing up. I will troubleshoot that later.
I created a simple test report with no datasources and just a little text to test it and it worked.
Other Helpful links:
http://www.businessobjects.com/products/dev_zone/net/2005.asp
http://www.businessobjects.com/global/pdf/dev_zone/VS2005_Walkthroughs.pdf
http://msdn2.microsoft.com/en-us/library/ms225593(VS.80).aspx
There was alot of talk about building an msi installation package. I played with that in different sorts of ways until I finally found the server install package listed above. I think that if you just install that, you won't need to try and package the crystal report stuff, you get them from that install.

Monday I work on passing parameters and programatically outputting to .pdf. And I have to figure out why the toolbar icons don't show up.

Dave

2007-04-27T09:16:00.000-06:00

Crystal Reports and the Web

For years I have been using crystal reports to output the contents of our database to a nice newsletter format. I use coldfusion for most programming and I started by using a web viewer that came with version 8 or something. Then I found an .asp page that would pass parameters to the report and export it to .pdf. This was perfect, although it felt very "kludgy". Well now I am faced with an upgrade of Crystal reports and a new server. It just seems impossible to find anything that will let me use coldfusion to directly call a report and output it to .pdf.

So, I start my first trip into the .net world. I only know that crystal reports integration with .net is fantastic. Now we see how fast I can get up to speed on .net.

I will try and keep you posted. I just downloaded 90 day trial of visual studio 2005. Service packs are downloading now. We will see if this is as easy as they say.

2007-04-27T09:10:00.000-06:00

New Blackberry

Last friday I ordered a new blackberry phone with Verizon. They messed up that order so yesterday I finally just went downt ot the store casue it is only an hour anyway. Well they set me up in a hurry and now I am the proud owner of a blackberry 8703e. This phone is cool. It just acts the way you would expect it to.

I mostly wanted this phone for the calendar and tasks, along with some email. I once had a dell axim, which was nice but I never used it because it was an "Extra" thing to take with me. This blackberry just combines the axim with a phone so I always have it with me. Maybe now I will use it.

I decided on the blackberry over the Motorola Q or Treo mainly because two different guys at Verizon said the blackberry was better. I haven't regretted the dicision yet.

2007-04-26T14:19:00.000-06:00

Recover Admin password for Google Apps

I set up a google app account for a buddy some time ago and he called because he couldn't log on. I tried with the admin info I used to set up the account, and I couldn't get on either, even though I swear I had the right info. Well If ound a solution to resetting it.

You can follow this link:

https://www.google.com/hosted/replaceDomain/forgetAdminPassword

You need to replace "replaceDomain" with the the domain with the forgotten password and then use the login for the account that you used to set up the google app account in the first place.

This is just for admin password. If it is just a user password, you can login as admin and reset that for them.

2007-04-24T05:34:00.000-06:00

Cannot open/design report in MSAccess

I just had a recent issue come up where all of the sudden I could not open any of my reports in an access database that I use.

Turns out that it had to do with a printer that I just installed. After searching and finding a comment about that, I changed my default printer and that fixed the problem. I had just hooked up an HP Laserjet 1012 to my Dell Lattitude via the docking station.

2007-04-20T08:12:00.000-06:00

Where to put Transfer code

There was a great email sent to the transfer list about design and architecture in your apps using transfer ORM. I put alot of my stuff in my controller. So essentially I follow the first example, when everyone else seemed to agree that the second example was better.

Have a look:

http://groups.google.com/group/transfer-dev/browse_thread/thread/1574d19bfad50946?hl=en

2007-04-19T06:52:00.000-06:00

Mcafee Security Suite Blocks Hotel Internet Access

I have blogged about my new Dell laptop before. I love it. I figured out running programs in windows xp compatibility mode and my only problem (not being able to run some programs) is not as bad anymore.

Anyway, over Easter the family went to Phoenix for the weekend. We left thursday night because the kids were out of school. First stop, Flagstaff. After a ruckus at the hotel we had reservations at, we ended up at the days inn.

Booted up the old laptop at 5:00 A.M. the next morning. NO INTERNET ACCESS! I tried everything. Got dell tech support on the line(North American Based). Nothing. Well I was ticked, but figured it was the motel. Next night, Super 8 in Gilbert AZ. Same thing. Finally, saturday morning I took a shot and uninstalled 3 of 4 components of the Mcafee security suite that came on the computer. Spam(I use gmail anyway), privacy control, and one other I can't remember. I left only virus scanning. BINGO. It worked. I don't know why I didn't try this in the first place. I have never used the "Security Suites" cause I have problems with clients who use them all the time. Something about the security suite and the internet access at the hotels didn't jive. I assume it was something to do with that redirection that happens when you first login. You go to the motel web site and have to click the agreement or whatever.

I should send Mcafee and email. Maybe I will

2007-03-09T08:17:00.000-07:00

How do I use a variable in a TOP clause in SQL Server?

http://sqlserver2000.databases.aspfaq.com/how-do-i-use-a-variable-in-a-top-clause-in-sql-server.html

I have a web page that runs a script which is so slow that it will time out if the number of records is too great. The temporary solution is to split the records into two subsets and then process those sets seperately. Doing that manually was not too big of a deal, but I wanted a better way.

I calculate the number of rows / 2.
Then I needed to use that value to automatically split the set. The only thing I needed to change was the brackets around the variable. So it turned out to be this:

Select top (@myvar) from mytable.

The article goes way more into depth

2007-03-04T22:50:00.000-07:00

Dell Latitude D820

I am just one month shy of the 3rd birthday of my existing laptop, a Dell inspiron 8600. It still runs ok, but takes forever to boot up and is slow enough that I knew I needed to get a new one.

So, I ordered a Dell Latitude D820 that arrived last thursday on Mar 1. I love this computer. Of course it was a huge upgrade from the 3 year old laptop It replaced. It has Windows Vista Business on it, 2 gig of ram, 15.4 in monitor and I added a port replicator to it.

I am testing the waters with this machine to be a desktop replacement. I don't know how it will work but I would love to be able to sit down anywhere and be just as productive as I am sitting at my desk in the office. With our recent subscription to google apps, and buying a dedicated hosted server, we are really trying to go in a direction that supports remote users.

We really don't buy anything but dell and I have always been very pleased with the equipment we have received from them. This laptop is no exception. It is screaming fast and I am loving it. I have installed most of the essential software that I use and it handles it all no problem and still is fast.

David Mineer

2007-03-04T22:38:00.000-07:00

Windows Vista

I purchased a dell latitude D820 that arrived last thursday on March 1(more on the new computer later). It came with Windows Vista Business. I thought I would share some of my first impressions about Microsofts new operating system.

I like it. It is intuitive and just seems to click for me. I haven't had too much trouble finding my way around. This laptop is awesome so of course speed doesn't seem to be a problem. The start menu is probably what has given me the most grief, but after I figured out that I could find what I was looking for simply by searching, that has been ok. I still need to take some time and figure out the start menu without searching.

Searching seems to be greatly improved in vista. Most programs have run ok, but there are a few that won't.

Overall I am impressed. The more I understand it the more It will be ok. I am not sure but I think I am using the upgraded "Halo" version and it is visually appealing and everything seems to flow pretty smoothly.

2007-02-28T20:50:00.001-07:00

java.net: ColdFusion for JSP Developers

java.net: ColdFusion for JSP Developers

A great article that explains why Java developers should consider Coldfusion for some of their development. It has some advantages and since it is written in Java, the skill set of Java Developers is not lost.

I don't know Java at all, but, nice to feel a little like coldfusion is in the family, if only distant.

Remote Synthesis: Mach II or ColdSpring? Understanding the Differences Between ColdFusion Frameworks

2007-02-28T20:40:00.000-07:00

Remote Synthesis: Mach II or ColdSpring? Understanding the Differences Between ColdFusion Frameworks

This is a super article that does what the title says. I wish this would have been written when I was first trying to understand all this.

Installing IIS 7.0 on Windows Vista Business or Vista Ultimate

2007-02-28T20:18:00.000-07:00

Installing IIS 7.0 on Windows Vista Business or Vista Ultimate

I just got a new laptop and I need to install IIS and Coldfusion. Here is a simple, to the point article on installing IIS 7.

2007-02-26T12:55:00.001-07:00

Refreshing web services

Are you trying to create web services with CFMX, but for some reason when you make a change it is not picked up. One of those things that can frustrate you to no end. Coldfusion makes a list of web services you create and you can view them in the administrator. You can also create them in the administrator. But the key here, is you can refresh them in the administrator also.

Open your administrator for the server that publishes the web service, login, and go to Data & Services > Web Services. There you will see the services and you can refresh, delete or add.

A good article with more about it and how to do refresh web services without opening up the administrator can be found here, by Charlie Arehart.