SELECT * FROM company Where companyID = 1
Select *, newid() as newid from PropSummary Where psActive = '1' And PSPROPERTYTYPE LIKE '%Office%' And PSCITY = 'Greenfield' 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 '%Office%' WHERE (AdjacentCities.CITY = 'Greenfield') 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=71 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=902775 CFTOKEN=44615812
Form Fields: FIELDNAMES=PSCITY,RANDOMORDER,PSPROPERTYTYPE,SEARCHTYPE PSCITY=Greenfield PSPROPERTYTYPE=Office RANDOMORDER=yes SEARCHTYPE=long
Server Variables: coldfusion=Struct (8) os=Struct (5)
Session Variables: cfid=902775 cftoken=44615812 sessionid=MLGCOMMERCIALPORTAL_902775_44615812 urltoken=CFID=902775&CFTOKEN=44615812
URL Parameters: CAT= MLGWORD=Debug Rendering Time: 31 ms
Greenfield is a city in Milwaukee County, Wisconsin, United States. The population was 35,476 at the 2000 census.
Greenfield was the final municipality in Milwaukee County to incorporate, and was the final municipality to leave the Township form of government in 1957. This was done to prevent total annexation by the City of Milwaukee. Before 1957, Milwaukee slowly nibbled away at Greenfield's land.
Greenfield is located at(42.963034, -87.995943). The Root River flows through the western part of the city.
According to the United States Census Bureau, the city has a total area of 11.6 square miles (29.9 km²), of which, 11.6 square miles (29.9 km²) of it is land and 0.09% is water.
As of the census of 2000, there were 35,476 people, 15,697 households, and 9,167 families residing in the city. The population density was 3,072.5 people per square mile (1,185.9/km²). There were 16,203 housing units at an average density of 1,403.3/sq mi (541.6/km²). The racial makeup of the city was 93.72% White, 0.98% African American, 0.44% Native American, 2.26% Asian, 0.02% Pacific Islander, 1.31% from other races, and 1.28% from two or more races. Hispanic or Latino of any race were 3.88% of the population.
There were 15,697 households out of which 22.6% had children under the age of 18 living with them, 47.3% were married couples living together, 8.0% had a female householder with no husband present, and 41.6% were non-families. 34.6% of all households were made up of individuals and 14.4% had someone living alone who was 65 years of age or older. The average household size was 2.20 and the average family size was 2.87.
In the city the population was spread out with 18.9% under the age of 18, 8.1% from 18 to 24, 28.3% from 25 to 44, 24.3% from 45 to 64, and 20.5% who were 65 years of age or older. The median age was 42 years. For every 100 females there were 88.4 males. For every 100 females age 18 and over, there were 84.7 males.
The median income for a household in the city was $44,230, and the median income for a family was $56,272. Males had a median income of $40,056 versus $30,212 for females. The per capita income for the city was $23,755. About 3.4% of families and 4.7% of the population were below the poverty line, including 6.9% of those under age 18 and 5.0% of those age 65 or over.