Example 2: 56,000 place names

Source code for this example 

<!--- 
Note that the database for this example must be set up as a datasource first. The Microsoft Access database is located in the examples folder. Place the datasource name in the request.dsn variable.

Microsoft Access is not recommended for web purposes, and is provided here for demonstration purposes only. Better performance will be achieved with enterprise databases.
--->

<cfimport prefix="esw" taglib="../customtags/eswsoftware/">

<cfif structKeyExists(url, "relatedId")>
	<cfoutput><p>Record selected: #htmlEditFormat(url.relatedId)#</p></cfoutput>
</cfif>

<esw:sortableplus 
	link="example2.cfm?relatedid=##relatedid##"
	table="vPlaces"
	dbms="Microsoft Access"
	datasource="#request.dsn#"
	sortBy="pointname"
	key="relatedid"
	style="width : 600px"
	cachedwithin="#createTimeSpan(0, 0, 10, 0)#"
	skin="glacier_crimson"
>

	<esw:column
		column="relatedid"
		caption="ID"
		type="numeric"
	/>
	
	<esw:column
		column="pointname"
		caption="Name"
	/>
	
	<esw:column
		column="pointdescriptionname"
		caption="Description"
	/>
	
	<esw:column
		column="Latitude"
		type="numeric"
		mask=".00"

	/>
	
	<esw:column
		column="Longitude"
		type="numeric"
		mask=".00"
	/>
		
</esw:sortableplus>