Kicks Retired at 350 & replaced by Nike Air Zoom HAYWARD

Nike Air Zoom HAYWARDRunning shoes last about 350 to 550 miles.  This mostly depends on the surface(s) you run on, your weight, and your running style.  Since I weigh a little more than the average runner and I run on asphalt and sidewalks my shoes are bald around 350 miles.  Today I retired my Air Pegasus in favor of a sweet new pair of Nike Air Zoom HAYWARD (pictured above). The Hayward’s run a lot like my old Nike Air Zoom Moire’s.

CFGRID DateFormat

For some reason when you have a datetime field in a cfgrid column it displays in a long format like this: Nov 17 2006 01:00:00

Fig 1 (Below) A date displayed in cfgrid

CFGRID DateFormat Before

If we work a little SQL magic (using “CONVERT”) in the cfquery though we can do the formatting we want, which is: 11/17/2006. Refer to the “styles” listed in Figure 3 to see what formatting is available.

Coldfusion Query:

SELECT note_id,note_text,
CONVERT(varchar,note_date,101) as note_date
FROM tbl_notes
ORDER BY note_date

Fig 2 (Below) A date displayed in cfgrid after using CONVERT in cfquery

CFGRID DateFormat After

Fig 3 (Below) A helpful list of “styles” to use with the SQL CONVERT function
Style ID Style Type
0 or 100 mon dd yyyy hh:miAM (or PM)
101 mm/dd/yy
102 yy.mm.dd
103 dd/mm/yy
104 dd.mm.yy
105 dd-mm-yy
106 dd mon yy
107 Mon dd, yy
108 hh:mm:ss
9 or 109 mon dd yyyy hh:mi:ss:mmmAM (or PM)
110 mm-dd-yy
111 yy/mm/dd
112 yymmdd
13 or 113 dd mon yyyy hh:mm:ss:mmm(24h)
114 hh:mi:ss:mmm(24h)
20 or 120 yyyy-mm-dd hh:mi:ss(24h)
21 or 121 yyyy-mm-dd hh:mi:ss.mmm(24h)
126 yyyy-mm-dd Thh:mm:ss.mmm(no spaces)
130 dd mon yyyy hh:mi:ss:mmmAM
131 dd/mm/yy hh:mi:ss:mmmAM

Prepend existing data in SQL

Disclaimer: This tip will probably be really basic for most SQL folks.

The task: The company I work for has a web application that does some basic tracking of grants. The system feeding information to this application just had an across the board change to the numbering scheme of the grants. All grants must have a prefix of “999-”. Therefore, any grant not beginning with “999-” must be updated. Example: a grant with the current number 8789966 needs to be 999-8789966.

The solution: The SQL below does two things. It updates all the grants to prepend the 999- prefix while also skipping any grants that are already correctly prefixed.


UPDATE tbl_grants
SET grant_no = '999-' + grant_no
WHERE grant_no NOT LIKE '999-%'

Nike Amp + gets me amped to run… no seriously

Nike Amp

I’ve had my Nike Amp + for several months so I’ve logged probably 300-400 miles with it. I’d say this qualifies me to finally pass my judgment on it. For anyone who has gigantic, hulking biceps that are too large for standard arm bands would rather just put their iPod in their pocket this thing is the shiz.

In a nutshell, I dig it. But rather than be Nike’s promo boy, here’s my list o’ cons.

CONS

  • You have to cut the band to custom fit your arm (rendering it useless to all your puny wristed friends). Come on Nike. You’re better than that.
  • The watch function is only available at the press of a button.
  • My wife tried controlling her nano with it for fun once and now when we run together it randomly controls both of our devices at times, which pisses her off. You have to keep explicitly unpairing them.
  • The clasp is prone to unbuckling.