Explore Response.ContentType

            Response.ContentType = “application/vnd.ms-excel”
            ‘Additional Test Code for CSV
            ‘Response.ContentType = “text/plain”
            If ReturnXYCoords Then
                Response.AppendHeader(“Content-Disposition”, “inline;filename=results.csv”)
            End If


Check out how changes to this Response.ContentType can effect the type of results returned to the calling browser.

Response.ContentType = “application/vnd.ms-excel”

Need to look into a little further SQL Statement Building

Also check out aliasing parameters and what they are returned as by the ending select *

Check out the WITH statement within SQL Server

WITH BPOrderedStores AS ( SELECT TOP 100 PERCENT ROW_NUMBER() OVER (ORDER BY [Name]) As [RowNumber], Name, LocationNo, Street, Town, State, Postcode, Phone, Unlead, PremiumUnlead, BPUltimate, E10, Diesel, Any_Autogas, Hours_24, Trailers, LPGBottle, Toilets, CarWash, CleanGo, SuperWash, Other, Pay, EFTPOS, BIORewards, ATM, Restaurant, TruckStops, Express FROM BP_AustLocator WHERE State =’NSW’ ORDER BY [Name] ) SELECT * FROM BPOrderedStores WHERE RowNumber BETWEEN 1 AND 500

CSS Snippets

Seems like a great site for code snippets


Cool Web Creation Sites

CSS Rule

When creating a multicolumn page layout add a

to the bottom most part of the wrapper div this will ensure correct presentation in both firefox and IE.

This hasnt been tested within either of SAFARI/NETSCAPE.

General IE Vs FF Vs IE – Browser Quirks

Need to culminate some of these major issues..