Energyshop.com - Energy for your home
Electricity Natural Gas Conservation Contact Us Site Map
Energyshop
Residential Services
 
Natural Gas, Electricity for Business Customers
CDM for LDC Professionals
What made you think about buying a fixed rate contract?
  • a. a friend, neighbor or co-worker;
  • b. someone came to my door;
  • c. a news release about rising energy cost or contracts;
  • d. you saw advertising.
  • a.
  • b.
  • c.
  • d.
Postal/ZIP Code:

Deregulated Electricity Offers for Your Home

Here are the competitive electricity offers for electricity in Alberta.

Deregulated Electricity Supply Rates Commodity prices in ¢/kWh  
Supplier

show suppliers alphabetically
1 Yr.
Fixed


show 1 year fixed prices in ascending order first
6 Yr.
Fixed


show 6 year fixed prices in ascending order first
Features

Sort
Signup
arrow
Camrose Energy 6.19 -- monthly admin fee $5.90 --
Echo Energy 6.49 -- monthly admin fee $5.95 --
Get Energy 6.67 -- monthly admin fee $6.47 --
NewGen Energy 6.6 -- monthly admin fee $6.00 --
Park Power -- 6.99 monthly admin fee $6.90 --
Solarmax Power 6.4 -- monthly admin fee $5.75 --

If you sort the table by any of the columns, and want to see it as it first appeared, you can restore its original appearance.

Prices are kept on a best-efforts basis. Customers should confirm the price on the contract received.

Regulated ENMAX Rates

Regulated Residential Rates based on 12,000 kWh/ year
Rate type Elect Supply ¢ Delivery Chg ¢ Other Charges* ¢ Total ¢/kWh Monthly Fee Estimated Bill
residential - Rate R 5.11 1.67 Incl. 6.78 $6.19 $887.52
Re-calculate using an unregulated electricity rate: ¢/kWh
Re-calculate annual cost using another usage amount:  kWh
ENMAX rates approved effective: Jan 1, 2018



If you've not switched to a deregulated supplier, you're paying these rates. We have included the regulated delivery and service charges in the chart above.

The status of electricity deregulation in Alberta

Most Albertans can choose their supplier for electricity. Small volume customers that use less than 250,000 kWh per year can choose a competitive supplier, or stay with your current utility supplier. The exception is the City of Medicine Hat, where no such choice is available.

What's included in retail electricity prices

If you choose to buy from a electricity marketer, the security of your electricity service won't change and you'll still get just one bill.

  • The bill will be from the marketer.
  • Delivery charges will still be charged at the regulated rate.
  • The Energy Charge will reflect the rate you agreed to in the contract.
  • You'll be charged a Retail Fixed Service Charge (a basic fee by the retailer for providing billing, customer service, call centre, and other administrative services).
  • If you have a Municipal Franchise Fee on your bill now, it will continue.

Comparing if you use less than 250,000 kWh/year

You have two fundamental choices:

  1. Stay with the utility and pay the variable Regulated Rate option (RRO); or,
  2. Go with a deregulated energy marketer at a competitive electricity price.

The RRO is a short term price that is set for a one year term (with possible quarterly adjustments) based on expected market prices.

If the set rate turns out to be lower than the utility has to pay for the electricity provided to you, they can add a surcharge to collect the difference.

Marketers offer a broad range of choices of fixed rates. You'll be asked to choose between retailers from terms between one and five years. There might be other incentives such as Air Miles™ or a free month of electricity.

Your decision depends on your budget, and what you expect electricity prices to do over the next few years.

Regulated rates are not fixed rates, nor can they be

Alberta utility rates are regulated by the Alberta Energy and Utilities Board. Utilities can and do apply for changes to rates. They can't offer fixed contracts except through deregulated affiliates. The reason you would sign up with an energy marketer would be to avoid unexpected rate changes.

Deciding on that deregulated portion

The portion of your bill over which you have choice is about 70% of the total charge per kilowatt hour. The monthly service charge and any other services that you get from your utilitiy, such as rental equipment or a service contract, are in addition to that. That 70% goes to whomever you choose to supply your needs. Remember this split when comparing costs. When a promotional message claims a 10% saving, it is referring to 10% of the 70% over which you have choice.

Get more information from Alberta Utilities Consumer Advocate Office

 


Debugging Information
ColdFusion Server Standard 11,0,14,307976
Template /es/prices/ab/eleab.cfm
Time Stamp 24-Jun-18 12:51 AM
Locale English (Canadian)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 54.145.103.69
Host Name 54.145.103.69


Execution Time

Total Time Avg Time Count Template
265 ms 265 ms 1 top level C:\inetpub\wwwroot\es\prices\ab\eleab.cfm
250 ms 250 ms 1 C:/inetpub/wwwroot/es/prices/ab/eleab-content.cfm
188 ms 188 ms 1 CFC[ C:/inetpub/Scripts/components/PriceTable.cfc | getConsumerPriceTable(argumentCollection = [complex value]) ] from C:/inetpub/Scripts/components/PriceTable.cfc
47 ms 47 ms 1 C:/inetpub/Scripts/newldcele.cfm
0 ms 0 ms 1 C:/inetpub/Scripts/rateengine.cfm
0 ms 0 ms 1 C:/inetpub/Scripts/setServerAreas.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/anti-sql-injection.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/es/Application.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/es/lib/font.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/es/prices/survey-form.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/esfw/navigation/mainmenu.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/esfw/navigation/residential-left-menu.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/esfw/other-links-ele-table.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/esfw/page_headers/header-residential.cfm
0 ms 0 ms 1 CFC[ C:/inetpub/Scripts/components/ContactForm.cfc | setKey() ] from C:/inetpub/Scripts/components/ContactForm.cfc
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
265 ms  TOTAL EXECUTION TIME
red = over 500 ms average execution time


SQL Queries

getprov (Datasource=M3Direct, Time=0ms, Records=78) in C:\inetpub\wwwroot\es\prices\ab\eleab-content.cfm @ 00:51:35.035
Select province, province_code from province
getldcname (Datasource=M3Direct, Time=0ms, Records=1) in C:\inetpub\wwwroot\es\prices\ab\eleab-content.cfm @ 00:51:35.035
SELECT LTRIM(RTRIM(L.ldc_name)) AS ldc_name, L.volume_res, U.units
FROM ldc L
INNER JOIN units U ON L.units_id = U.units_id
WHERE L.ldc_id=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 357

qryLDC (Datasource=M3Direct, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
SELECT RTRIM(ldc_name) AS ldc_name, ldc_id, RTRIM(ldc_units) AS ldc_units, units_id, RTRIM(Province_code) AS Province, RTRIM(enertype) AS enertype, volume_res, volume_scom
FROM   LDC
WHERE (ldc_id = ?)
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 357

qryLDCs (Datasource=M3Direct, Time=0ms, Records=8) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
SELECT RTRIM(ldc_name) AS ldc_name, ldc_id, RTRIM(U.units) AS ldc_units, L.units_id, RTRIM(Province_code) as Province, volume_res, volume_scom
FROM   LDC L INNER JOIN units U ON L.units_id = U.units_id
WHERE (Province_code = 'AB') AND (enertype = 'ele') AND NOT (ldc_id IN (3,6,18,356,359,393,385))  AND ldc_active='y'
ORDER BY ldc_name
getLdc (Datasource=M3Direct, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
SELECT volume_res as Volume
FROM ldc
WHERE (ldc_id=357)
qryPrice (Datasource=M3Direct, Time=0ms, Records=6) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
SELECT DISTINCT 
P.supplier_id, RTRIM(P.nameofsupplier) AS nameofsupplier, P.oemaprice_id, RTRIM(P.pricetype) AS pricetype, P.priceenddate, RTRIM(P.billingtype) AS billingtype, RTRIM(P.priceterm) AS priceterm, RTRIM(P.priceterm) + '<br>' + RTRIM(P.pricetype) AS priceclass, RTRIM(P.bonus) AS bonus, RTRIM(P.feature) AS bonusdesc, P.priceyear1, P.priceyear2, P.priceyear3, P.priceyear4, P.priceyear5, P.oemaprice_dstamp, ISNULL(p.lowvolumelimit,0) as lowvolumelimit, p.highvolumelimit, RTRIM(S.nameofsupplier) as SupplierName, ISNULL(S.energyshop,'no') as energyshop, P.isGreen, P.isCarbonNeutral, P.pricewords
FROM       oemaprice P
INNER JOIN price_ldc PL ON P.oemaprice_id = PL.oemaprice_id
INNER JOIN supplieroema S ON P.supplier_id = S.supplier_id
WHERE
(GETDATE() BETWEEN P.pricestart_dstamp AND P.priceenddate)

AND (P.show_on_eshp = 'y' OR P.show_on_eshp IS NULL)
AND (P.supplier_id <> '') AND (PL.ldc_id = 357)
AND (P.lowvolumelimit <= 15000) AND (P.isCommercialOnly = 0) 
AND (ISNULL(S.residential,'no') = 'yes') AND (P.onChart = 1)
ORDER BY RTRIM(P.nameofsupplier), RTRIM(P.priceterm)
qryUniquePrices (Datasource=, Time=0ms, Records=2) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
SELECT DISTINCT priceclass
FROM   qry
ORDER BY months,priceclass
qrySupplierBase (Datasource=, Time=0ms, Records=6) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
			SELECT DISTINCT nameofsupplier, supplier_ID as ID, energyshop as Online
			FROM   strQueries.qryPrices
			ORDER BY energyshop DESC, nameofsupplier
			
qrySignupOnly (Datasource=, Time=0ms, Records=0) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
			SELECT *
			FROM   qrySupplierBase
			WHERE  (online = 'yes')
			
qryTopSellers (Datasource=M3Direct, Time=140ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
			SELECT     TOP 100 R.quote_request_id, RP.oemaprice_id, RS.supplier_id
			FROM         quote_request R INNER JOIN
                      quote_price RP ON R.quote_request_id = RP.quote_request_id INNER JOIN
                      quote_supplier RS ON R.quote_request_id = RS.quote_request_id INNER JOIN
                      ldc L ON R.quote_ldc = L.ldc_name
			WHERE     (R.quote_proc_dstamp IS NOT NULL) AND (NOT (R.quote_name LIKE '%test%')) AND (RP.oemaprice_id NOT IN
                          (SELECT     p.oemaprice_id
                            FROM          supplieroema s INNER JOIN
                                                   oemaprice p ON s.supplier_id = p.supplier_id
                            WHERE      (s.nameofsupplier LIKE 'energyshop%') OR
                                                   (s.nameofsupplier LIKE 'm3%')))
			AND (L.ldc_id = 357)
			
			ORDER BY R.quote_request_id DESC
			
qryTopSellers (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
			SELECT supplier_id as ID, COUNT(supplier_id) as Total
			FROM   qryTopSellers
			GROUP BY ID
			ORDER BY Total DESC, ID
			
qryWhoWasExcluded (Datasource=, Time=0ms, Records=6) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
				SELECT DISTINCT ID, Online
				FROM   qrySupplierBase
				WHERE  (ID NOT IN (185))
				ORDER BY Online DESC, nameofsupplier
				
qrySingleSupplier (Datasource=, Time=0ms, Records=0) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
				SELECT *
				FROM   qrySupplierBase
				WHERE  (ID = 185)
				
qrySingleSupplier (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
				SELECT *
				FROM   qrySupplierBase
				WHERE  (ID = 506)
				
qrySingleSupplier (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
				SELECT *
				FROM   qrySupplierBase
				WHERE  (ID = 497)
				
qrySingleSupplier (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
				SELECT *
				FROM   qrySupplierBase
				WHERE  (ID = 498)
				
qrySingleSupplier (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
				SELECT *
				FROM   qrySupplierBase
				WHERE  (ID = 500)
				
qrySingleSupplier (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
				SELECT *
				FROM   qrySupplierBase
				WHERE  (ID = 501)
				
qrySingleSupplier (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
				SELECT *
				FROM   qrySupplierBase
				WHERE  (ID = 504)
				
qrySorted (Datasource=, Time=0ms, Records=6) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
			SELECT   *
			FROM     strQueries.qryPrices
			ORDER BY supplier_id
			
qrySupplierNames (Datasource=, Time=0ms, Records=6) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
			SELECT *
			FROM qrySupplierNames
			WHERE (nameOfSupplier <> '') OR (ID <> 0)
			
qrySingleSupplier (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
		SELECT *
		FROM qrySorted
		WHERE (supplier_id = 506) AND (priceclass = '1 Year<br>Fixed Price')
		
qrySingleSupplier (Datasource=, Time=0ms, Records=0) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
		SELECT *
		FROM qrySorted
		WHERE (supplier_id = 506) AND (priceclass = '6 Year<br>Fixed Price')
		
qryBonus (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
	SELECT DISTINCT bonus
	FROM qrySorted
	WHERE (supplier_id = 506)
	ORDER by bonus DESC
	
qryBonusTxt (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
		SELECT DISTINCT bonusdesc
		FROM qrySorted
		WHERE (supplier_id = 506) AND (bonusdesc <> '')
		
qrySignupStatus (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
	SELECT DISTINCT energyshop
	FROM   qrySorted
	WHERE  (supplier_id = 506)
	
qrySingleSupplier (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
		SELECT *
		FROM qrySorted
		WHERE (supplier_id = 497) AND (priceclass = '1 Year<br>Fixed Price')
		
qrySingleSupplier (Datasource=, Time=0ms, Records=0) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
		SELECT *
		FROM qrySorted
		WHERE (supplier_id = 497) AND (priceclass = '6 Year<br>Fixed Price')
		
qryBonus (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
	SELECT DISTINCT bonus
	FROM qrySorted
	WHERE (supplier_id = 497)
	ORDER by bonus DESC
	
qryBonusTxt (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
		SELECT DISTINCT bonusdesc
		FROM qrySorted
		WHERE (supplier_id = 497) AND (bonusdesc <> '')
		
qrySignupStatus (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
	SELECT DISTINCT energyshop
	FROM   qrySorted
	WHERE  (supplier_id = 497)
	
qrySingleSupplier (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
		SELECT *
		FROM qrySorted
		WHERE (supplier_id = 498) AND (priceclass = '1 Year<br>Fixed Price')
		
qrySingleSupplier (Datasource=, Time=0ms, Records=0) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
		SELECT *
		FROM qrySorted
		WHERE (supplier_id = 498) AND (priceclass = '6 Year<br>Fixed Price')
		
qryBonus (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
	SELECT DISTINCT bonus
	FROM qrySorted
	WHERE (supplier_id = 498)
	ORDER by bonus DESC
	
qryBonusTxt (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
		SELECT DISTINCT bonusdesc
		FROM qrySorted
		WHERE (supplier_id = 498) AND (bonusdesc <> '')
		
qrySignupStatus (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
	SELECT DISTINCT energyshop
	FROM   qrySorted
	WHERE  (supplier_id = 498)
	
qrySingleSupplier (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
		SELECT *
		FROM qrySorted
		WHERE (supplier_id = 500) AND (priceclass = '1 Year<br>Fixed Price')
		
qrySingleSupplier (Datasource=, Time=0ms, Records=0) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
		SELECT *
		FROM qrySorted
		WHERE (supplier_id = 500) AND (priceclass = '6 Year<br>Fixed Price')
		
qryBonus (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
	SELECT DISTINCT bonus
	FROM qrySorted
	WHERE (supplier_id = 500)
	ORDER by bonus DESC
	
qryBonusTxt (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
		SELECT DISTINCT bonusdesc
		FROM qrySorted
		WHERE (supplier_id = 500) AND (bonusdesc <> '')
		
qrySignupStatus (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
	SELECT DISTINCT energyshop
	FROM   qrySorted
	WHERE  (supplier_id = 500)
	
qrySingleSupplier (Datasource=, Time=0ms, Records=0) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
		SELECT *
		FROM qrySorted
		WHERE (supplier_id = 501) AND (priceclass = '1 Year<br>Fixed Price')
		
qrySingleSupplier (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
		SELECT *
		FROM qrySorted
		WHERE (supplier_id = 501) AND (priceclass = '6 Year<br>Fixed Price')
		
qryBonus (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
	SELECT DISTINCT bonus
	FROM qrySorted
	WHERE (supplier_id = 501)
	ORDER by bonus DESC
	
qryBonusTxt (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
		SELECT DISTINCT bonusdesc
		FROM qrySorted
		WHERE (supplier_id = 501) AND (bonusdesc <> '')
		
qrySignupStatus (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
	SELECT DISTINCT energyshop
	FROM   qrySorted
	WHERE  (supplier_id = 501)
	
qrySingleSupplier (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
		SELECT *
		FROM qrySorted
		WHERE (supplier_id = 504) AND (priceclass = '1 Year<br>Fixed Price')
		
qrySingleSupplier (Datasource=, Time=0ms, Records=0) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
		SELECT *
		FROM qrySorted
		WHERE (supplier_id = 504) AND (priceclass = '6 Year<br>Fixed Price')
		
qryBonus (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
	SELECT DISTINCT bonus
	FROM qrySorted
	WHERE (supplier_id = 504)
	ORDER by bonus DESC
	
qryBonusTxt (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
		SELECT DISTINCT bonusdesc
		FROM qrySorted
		WHERE (supplier_id = 504) AND (bonusdesc <> '')
		
qrySignupStatus (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
	SELECT DISTINCT energyshop
	FROM   qrySorted
	WHERE  (supplier_id = 504)
	
getPriceDate (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:35.035
SELECT MAX(oemaprice_dstamp) as LastChange
FROM   strQueries.qryPrices
getldcgas (Datasource=M3Direct, Time=32ms, Records=1) in C:\inetpub\Scripts\newldcele.cfm @ 00:51:35.035
SELECT DISTINCT
ldcgasclass, gassupply, ldcgas, ldcgas_startdate, ldcgas_numonic, ldcgasadmin, volume_max, volume_default, ldcgasfuel, monthlycharge, dist_wstep1, dist_wstep2, dist_wstep3, dist_wstep4, dist_wstep5, dist_wstep6, dist_wstep7, dist_sstep1, dist_sstep2, dist_sstep3, dist_sstep4, dist_sstep5, dist_sstep6, dist_sstep7, transp_sstep1, transp_sstep2, transp_sstep3, transp_sstep4, transp_sstep5, transp_wstep1, transp_wstep2, transp_wstep3, transp_wstep4, transp_wstep5, dist_vol1, dist_vol2, dist_vol3, dist_vol4, dist_vol5, dist_vol6, dist_vol7, transp_vol1, transp_vol2, transp_vol3, transp_vol4, transp_vol5
FROM ldcgas
WHERE
ldc_id = 357
AND ldcgas_enddate >= GETDATE()
AND ldcgasclass = 'residential'
ORDER BY ldcgas_numonic


Scope Variables

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=C:\inetpub\wwwroot\es\prices\ab\eleab.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=x-gzip, gzip, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.energyshop.com
HTTP_REFERER=
HTTP_URL=/es/prices/ab/eleab.cfm?ldc_id=357
HTTP_USER_AGENT=CCBot/2.0 (http://commoncrawl.org/faq/)
LOCAL_ADDR=209.250.137.194
PATH_INFO=
PATH_TRANSLATED=C:\inetpub\wwwroot\es\prices\ab\eleab.cfm
QUERY_STRING=ldc_id=357
REMOTE_ADDR=54.145.103.69
REMOTE_HOST=54.145.103.69
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/es/prices/ab/eleab.cfm
SERVER_NAME=www.energyshop.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/8.0
WEB_SERVER_API=
Cookie Variables:
CFID=10918717
CFTOKEN=da829aa097dfc9d0-E1509168-9DD6-4DD0-E7B7E5D59341FBEE
Session Variables:
bremovebusiness=false
rateclass=res
scontactkey=mr&Omr8LjJnaR
sessionid=A51F3CC2C1515BBDF90925FE201037F2.cfusion
urltoken=CFID=10918717&CFTOKEN=da829aa097dfc9d0-E1509168-9DD6-4DD0-E7B7E5D59341FBEE&jsessionid=A51F3CC2C1515BBDF90925FE201037F2.cfusion
URL Parameters:
ldc_id=357
Debug Rendering Time: 16 ms