mgk1969.wordpress.com
SQL ORDER BY with ‘The’ removed | Mark King's Blog
https://mgk1969.wordpress.com/2008/05/26/sql-order-by-with-the-removed
Mark King’s Blog. Musings on all manner of things. SQL ORDER BY with ‘The’ removed. May 26, 2008 in Code. I’ve often had to sort strings into alpha order but had problems with sorting the ones starting with “The”. Here’s how I solved it within the SQL query. SELECT partnerID, partner, partnersort = CASE LEFT(partner,4) WHEN 'the' THEN RIGHT(partner,LEN(partner)-4) ELSE partner END FROM partners ORDER BY partnersort. Pretty happy with that! Mark’s Buddy Finder. Comments feed for this article.
mgk1969.wordpress.com
Cannon Hill Community Links | Mark King's Blog
https://mgk1969.wordpress.com/2007/06/26/cannon-hill-community-links
Mark King’s Blog. Musings on all manner of things. Cannon Hill Community Links. June 26, 2007 in Web Dev. Http:/ www.cannonlinks.com.au. This is just a little guy, only 10 or so pages. It was all done in record time too – I was told it was a reskin and then when it showed up the whole thing had been redesigned! Mark’s Buddy Finder. Comments feed for this article. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Email (Address never made public).
mgk1969.wordpress.com
www.3speed.com.au | Mark King's Blog
https://mgk1969.wordpress.com/2007/05/31/www3speedcomau
Mark King’s Blog. Musings on all manner of things. May 31, 2007 in Web Dev. Http:/ www.3speed.com.au. I made this site live yesterday. It’s nice, took some time to get the navigation working correctly across the top, also the opacity thing when you look at case studies. It’s basically lightbox but of course it had to be customised to suit the design. Mark’s Buddy Finder. Comments feed for this article. Leave a Reply Cancel reply. Enter your comment here. Email (Address never made public).
mgk1969.wordpress.com
Links | Mark King's Blog
https://mgk1969.wordpress.com/about-me
Mark King’s Blog. Musings on all manner of things. I am a professional web developer in Brisbane, Australia. Mark’s Buddy Finder. Mark’s Buddy Finder. Blog at WordPress.com. Ben Eastaugh and Chris Sternal-Johnson. Follow “Mark King's Blog”. Get every new post delivered to your Inbox. Build a website with WordPress.com.
mgk1969.wordpress.com
Discovery Metals | Mark King's Blog
https://mgk1969.wordpress.com/2007/07/01/discovery-metals
Mark King’s Blog. Musings on all manner of things. July 1, 2007 in Web Dev. Http:/ www.discoverymetals.com.au. Another D10 site, nice one too. Not much time to write about it but it was generally smooth to build and get up, hopefully not too many changes in the coming weeks. Mark’s Buddy Finder. Comments feed for this article. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Email (Address never made public). Notify me of new comments via email.
qmusic.com.au
QLD MUSIC AWARDS 2012 - 2012
http://www.qmusic.com.au/qldmusicawards/2012
Terms & Conditions. Schools (Grade 6 - 12). Folk / Singer Songwriter. Courier-Mail People's Choice Award - Most Popular Female. Courier-Mail People's Choice Award - Most Popular Male. Courier-Mail People's Choice Award - Most Popular Group. Album of the Year. Folk / Singer Songwriter. Schools (Grade 6 - 12). Album of the Year. Courier-Mail People's Choice Award - Most Popular Female. Courier-Mail People's Choice Award - Most Popular Male. Courier-Mail People's Choice Award - Most Popular Group. Winning j...
queenslandmusicawards.com.au
QLD MUSIC AWARDS 2017 - Judges Announced For 2017 #QldMusicAwards
https://www.queenslandmusicawards.com.au/index.cfm?contentID=639&articleID=10953
Blues & Roots. Folk / Singer Songwriter. Voting closes March 13! Win tix to #QldMusicAward. You've got 3 days left to vote in the 2017 @BOQ. People's Choice Awards for @QldMusicAwards. Visit: https:/ t.co/uK43DBurJx. We're working w/ @AmrapsAirIt. To get extra airplay for #Qld. ANNOUNCED TODAY: 2017 #QldMusicAward. AOTY nominees : @cubsportmusic. Have your say on the 2017 #BOQ. Voting is now open! Public voting now open for this year's Queensland Music Awards @QldMusicAwards. One To Watch' @tiagostelow.
mgk1969.wordpress.com
Fonts | Mark King's Blog
https://mgk1969.wordpress.com/2007/05/05/fonts
Mark King’s Blog. Musings on all manner of things. May 5, 2007 in Web Dev. I like fonts but (like everyone I guess) I have my favourites. Here’s a list I was just reading, I thought I would post it here so I don’t forget where I found it. Helvetica is not a surprise, but some of the newer ones are! Http:/ www.inspirationbit.com/16-best-loved-font-bits-in-web-design/. Mark’s Buddy Finder. Comments feed for this article. May 5, 2007 at 3:31 pm. Leave a Reply Cancel reply. Enter your comment here.
mgk1969.wordpress.com
Using JavaScript to autostripe a table | Mark King's Blog
https://mgk1969.wordpress.com/2007/12/02/using-javascript-to-autostripe-a-table
Mark King’s Blog. Musings on all manner of things. Using JavaScript to autostripe a table. December 2, 2007 in Code. I was recently working on a project where there were tables edited in a database so I had no control over the colours of the various cells (and didn’t want to have to do the striping manually). I eventually found the following code and altered it to suit my needs:. EvenColor : oddColor; } even =! Even; } } } } }. Tags, then the. Tags, then all the. Tags When we reach the. Released on / th.
mgk1969.wordpress.com
May | 2008 | Mark King's Blog
https://mgk1969.wordpress.com/2008/05
Mark King’s Blog. Musings on all manner of things. You are currently browsing the monthly archive for May 2008. SQL ORDER BY with ‘The’ removed. May 26, 2008 in Code. I’ve often had to sort strings into alpha order but had problems with sorting the ones starting with “The”. Here’s how I solved it within the SQL query. SELECT partnerID, partner, partnersort = CASE LEFT(partner,4) WHEN 'the' THEN RIGHT(partner,LEN(partner)-4) ELSE partner END FROM partners ORDER BY partnersort. Pretty happy with that!
