SELECT * FROM company Where companyID = 1
Select *, newid() as newid from PropSummary Where psActive = '1' And PSPROPERTYTYPE LIKE '%Retail%' And PSCITY = 'Polk' Order by psCity
SELECT srvID, srvName, srvTemplate, srvType as ServiceType, srvOrder From Services Where srvType in ( ?, ?) And srvCompany in (1, 8) And Show = 'Y' AND srvName not IN ('About Us', 'Services') Order By srvType, srvOrder
SELECT srvID, srvName, srvType, srvTemplate From Services Where srvType = ? And srvCompany in (1, 8) And Show <> 'N' And Show <> 'No' Order By srvOrder
SELECT srvID, srvName From Services Where srvType = ? And srvCompany = ? Order By srvOrder
SELECT AdjacentCities.Adjacent, COUNT(PropSummary.psID) AS NumOfListings FROM AdjacentCities LEFT OUTER JOIN PropSummary ON AdjacentCities.Adjacent = PropSummary.psCity AND PropSummary.psActive = '1' And PSPROPERTYTYPE LIKE '%Retail%' WHERE (AdjacentCities.CITY = 'Polk') GROUP BY AdjacentCities.Adjacent, PropSummary.psActive
CGI Variables: AUTH_PASSWORD= AUTH_TYPE= AUTH_USER= CERT_COOKIE= CERT_FLAGS= CERT_ISSUER= CERT_KEYSIZE= CERT_SECRETKEYSIZE= CERT_SERIALNUMBER= CERT_SERVER_ISSUER= CERT_SERVER_SUBJECT= CERT_SUBJECT= CF_TEMPLATE_PATH=E:\RealPlaces\E\INETPUB\mlgcommercial.wwwroot\properties\showList.cfm CONTENT_LENGTH=65 CONTENT_TYPE=application/x-www-form-urlencoded CONTEXT_PATH= GATEWAY_INTERFACE=CGI/1.1 HTTPS=off HTTPS_KEYSIZE= HTTPS_SECRETKEYSIZE= HTTPS_SERVER_ISSUER= HTTPS_SERVER_SUBJECT= HTTP_ACCEPT= HTTP_ACCEPT_ENCODING=deflate, gzip, x-gzip, compress, x-compress HTTP_ACCEPT_LANGUAGE= HTTP_CONNECTION=close, TE HTTP_COOKIE= HTTP_HOST=www.mlgcommercial.com HTTP_REFERER= HTTP_USER_AGENT=ColdFusion PATH_INFO=/properties/ShowList.cfm PATH_TRANSLATED=E:\RealPlaces\E\INETPUB\mlgcommercial.wwwroot\properties\showList.cfm QUERY_STRING= REMOTE_ADDR=192.168.1.40 REMOTE_HOST=192.168.1.40 REMOTE_USER= REQUEST_METHOD=POST SCRIPT_NAME=/properties/ShowList.cfm SERVER_NAME=www.mlgcommercial.com SERVER_PORT=80 SERVER_PORT_SECURE=0 SERVER_PROTOCOL=HTTP/1.1 SERVER_SOFTWARE=Microsoft-IIS/7.5 WEB_SERVER_API=
Cookie Variables: CFID=900970 CFTOKEN=94337410
Form Fields: FIELDNAMES=PSCITY,RANDOMORDER,PSPROPERTYTYPE,SEARCHTYPE PSCITY=Polk PSPROPERTYTYPE=Retail RANDOMORDER=yes SEARCHTYPE=long
Server Variables: coldfusion=Struct (8) os=Struct (5)
Session Variables: cfid=900970 cftoken=94337410 sessionid=MLGCOMMERCIALPORTAL_900970_94337410 urltoken=CFID=900970&CFTOKEN=94337410
URL Parameters: CAT= MLGWORD=Debug Rendering Time: 16 ms
Polk is a town in Washington County, Wisconsin, United States. The population was 3,938 at the 2000 census.
According to the United States Census Bureau, the town has a total area of 32.2 square miles (83.4 km²), of which, 31.9 square miles (82.7 km²) of it is land and 0.3 square miles (0.7 km²) of it (0.87%) is water.
As of the census of 2000, there were 3,938 people, 1,352 households, and 1,139 families residing in the town. The population density was 123.3 people per square mile (47.6/km²). There were 1,430 housing units at an average density of 44.8/sq mi (17.3/km²). The racial makeup of the town was 98.70% White, 0.20% African American, 0.15% Native American, 0.15% Asian, 0.13% Pacific Islander, 0.33% from other races, and 0.33% from two or more races. Hispanic or Latino of any race were 0.91% of the population.
There were 1,352 households out of which 38.3% had children under the age of 18 living with them, 77.2% were married couples living together, 3.6% had a female householder with no husband present, and 15.7% were non-families. 12.6% of all households were made up of individuals and 4.7% had someone living alone who was 65 years of age or older. The average household size was 2.89 and the average family size was 3.16.
In the town the population was spread out with 26.9% under the age of 18, 6.7% from 18 to 24, 28.5% from 25 to 44, 27.5% from 45 to 64, and 10.4% who were 65 years of age or older. The median age was 39 years. For every 100 females there were 105.0 males. For every 100 females age 18 and over, there were 105.6 males.
The median income for a household in the town was $62,933, and the median income for a family was $74,643. Males had a median income of $42,955 versus $33,750 for females. The per capita income for the town was $27,518. About 3.2% of families and 3.5% of the population were below the poverty line, including 2.2% of those under age 18 and 7.9% of those age 65 or over.