Web noobs are so cute. "h t t p colon backsplash backsplash..."

PC crashed again during sleep. The only good thing about a PC is you can use it to remote pilot a Mac. Possibly. If it doesn't crash trying.

OmniGraffle makes a pretty decent layman's cad program!

@panic Flattered much? http://ping.fm/7Mg99 =)

Web Products and Services for Business

Web Application Development

I can leverage Server Languages (ColdFusion, PHP, ASP), Client Languages (Javascript, XHTML, DHTML, CSS), Hybrid languages (AJAX, XML, Web 2.0, SOAP), and Database Languages (MySQL, MS SQL Server, MS Access) together to create a powerful web based application to suit your needs - whether it be an e-commerce store, CMS, extranet, etc.

Database Web Development

While building your custom web application, a database will most likely be used. The database will be lean and built for speed and reliability.

Website Design & Redesign

Web design is in contrast with web development, which includes web server configuration, writing web applications and server security.

Search Engine Optimization

As a subset of search engine marketing, SEO seeks to improve the number and quality of visitors to a web site from "natural" search results.

Having built sites with Google PageRank of 5 or better, I know what works, what tricks are safe, and which can get you banned.

Search Yahoo! for Freelance Web Development and I'm #1 (sometimes #2 or #3).
I'm usually in the top 5 at google, too: http://www.google.com/search?q=freelance%20web%20development
My Google PageRank is usually 4 or 5.

HTML Email Design

HTML e-mail is the use of HTML to provide formatting and capabilities in e-mail that are not available with plain text.

Extended Services

Through my network of partners I can offer the following services:

• Banner Ad Design
• User Interface Design
• Logo and Corporate Identity Development

For more information, please see: http://www.webveteran.com/services/offerings.cfm

Website Hosting

Solid, dependable, high performance website hosting.

My hosting service is tailored to the technologies and server languages needed for today's advanced website.

As you can see below I offer everything other hosts do.

Basics Initial Setup: $0 Disk Space: 1000 MB Email Accounts: 100 Disk Space: 300 MB (shared) Email Alias/Forwarding: Unlimited General Sub-Domains: 100 Domain Aliases: 3 FTP Accounts: 100 SQL Server 2000 Databases: 1 Other Free Shared SSL Domain Free Static IP Custom 404 Error Page Audio/Video streaming

Languages CGI ColdFusion MX7 & MX 6.1 - ALL CF Tags except CFExecute and CFRegistry - csImageFile (for high quality images) - CFX_Google FrontPage - 2003, 2002, 2000 & 98 ASP ASP.NET Packages DasBlog community edition DotNetNuke v3

Where's the price?

The price will vary per website. It will depend on the amount of resources the site will demand from the server.

For more information, please visit http://www.webveteran.com/services/Hosting.cfm

Tags: |

Pagination with ColdFusion and MSSQL (faux MySQL’s LIMIT X,Y)

Pagination is something that has always been somewhat difficult for me. Especially optimizing it for large sites. To make it even harder, the customer wants the first page to show three items, and every subsequent page to show ten. Not hard enough? OK, they want page number links instead of simple left/right arrow links, such as:

1 2 3 [4] Next »

Still Easy?

• Only show 4 page links at a time
• When you click ‘next’, show the next block of 4 pages
• When you click ‘prev’, show the previous block of 4 pages
• If you are on the first block of links, do not show the ‘prev’ link
• If you run out of records, only show the correct number of page links in that block
• If you run out of records, do not show the ‘next’ link

Remember, page 1 has 3 items. Page 2 has 10. So the math gets kinda tricky when you don’t want to do ‘what page are we on’ statements all over the place.

Here is my solution. All you have to do is enter your records per page (”allperpage”), number of page links at a time (”blocksof”), and the number of items on the first page (”firstperpage”).


The SQL query has been optimized to get as close to MySQL’s ‘LIMIT’ function as possible. We’re doing an INNER JOIN here, and sorting on columns from both tables. I haven’t seen any examples of this optimization technique with an inner join, or even sorting on more than one column. We pull back the max rows we’d need, then trim the top with a reverse sort, finally un-reverse the sort for the web page. WHEW.

On to the code: Pagination with ColdFusion and MSSQL (faux MySQL’s LIMIT X,Y)