Things you need for SSL (EV) Extended Validation Certificates - godaddy

First, make sure you have the FINAL host name that you are securing. www.somehost.com and somehost.com are equivalent, but www2.somehost.com and somehost.com are NOT. For an EV cert you will need to do this once for every host you wish to get a cert for. For this reason you cannot get a wildcard EV cert.

If your business entity has a data trail (think info-usa type stuff) then you are probably golden. Otherwise you need:

A Requestor (probably you)
A Request Approver (someone at the company that can be verified)
An Approver (someone at the compnay that can be verified)

They can all be the same person and many times will be.

The CA will need your business registration #, city, and state. (your HQ address might be different than this, they need the info where you registered)

If the CA cannot find enough information in public records to validate your contacts, you will need to have their accountant (CPA) send a letter stating they represent the company and its contact info (mailing and telephone) along with contact info for the person who will be your Request Approver/Approver. Make sure all the addresses match up. This letter could also come from legal counsel who is registered with the state Bar association of the state your company is incorporated in.

In general if you make a typo in anything but the certificate request info, the CA can correct it after you initially request.

Coldfusion 9 not sending connection string to MySQL 4/5 datasource. (zeroDateTimeBehavior)

I was unable to get Coldfusion 9 server to take the usual fix for the following:

java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 20
to TIMESTAMP.

which is to put:

zeroDateTimeBehavior=convertToNull

in the data source connection options. This method fixed the problem in all previous versions of ColdFusion.

My workaround was to add a 'Custom' data source and add all the normal JDBC variables and add the zertoDateTimeBehavior option to the actual URL instead of letting ColdFusion 9 try to do it.

Is your pharmacy taking you (and your insurance) for a ride?

Well, I decided to try auto-fills on my prescriptions from Walgreens and it works great, perhaps a little too great. It's so nice not to have to remember to order, and then pick-up scripts (or order, then forget, then need at 12am and have to drive to a 24hour location). However you should be aware of your insurance policies on filling prescriptions.

If your coverage company is like mine, they allow refills at around 21-days. This is fine when you aren't on auto-fill because everybody needs a little wiggle room on the timing. On auto-fill however, every single time your prescription CAN be ordered, it WILL be ordered. So instead of 12 months in the year, you now have 17 eligible refills available. With travel time maybe 1 less. By the time you are 1/2 way through the year, you will always have next months supply on the shelf before you start taking this month's supply. This may be great as far as being able to forget going to the pharmacy, but not sure about your pocketbook with the co-pays, and I'm sure your insurance will love it as well.

A Walgreens rep told me they fill entirely on the insurance providers policy, but I don't think the insurers have. I would have written them a note, but you can only send them 256 characters at a time through their online contact form. Basically she said "I'ts not our fault, there's nothing we can do". I did add that maybe she could suggest the customer being able to alter the interval to 30 days.

So, does your pharmacy do the same thing? It should be that after the second auto-fill (you need 1 or 2 early if you are right on the nose when you set it up to allow for holidays, sundays, and soon to be non-delivery saturdays), the interval that they are ordered reverts to 30 days, since once you are on track you shouldn't need that extra wiggle room anyway.