Month: October 2008

Explore Response.ContentType

Dan HLeave a comment
            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”)
                Response.Write(GetCSV(records))
                Response.End()
            End If

http://www.15seconds.com/issue/970515.htm

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

Dan HLeave a comment

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

Dan HLeave a comment
Seems like a great site for code snippets

http://snipplr.com/view/266/undohtmlcss–tanteks-original-removes-browser-default-style/

Cool Web Creation Sites

CSS Rule

Dan HLeave a comment

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

Dan HLeave a comment
Need to culminate some of these major issues.. 

http://blog.danbartels.com/archive/2005/03/14/416.aspx