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

  

Union Gas (South) Natural Gas Residential Prices

Deregulated Natural Gas Prices 
Commodity prices in ¢/m³  
Supplier

show suppliers alphabetically
1 Yr.
Fixed


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


show 3 year fixed prices in ascending order first
5 Yr.
Fixed


show 5 year fixed prices in ascending order first
Features

Sort
Signup
arrow
MyRate Energy 10.49 -- 15.8 transportation to Union Gas is 5.8 cents/m3 view offer or sign-up online
Just Energy 16.9 24.9 -- 3 year Price Protection Program with 100% Green 19.9 /m + 5.0/m Green view offer or sign-up online
RiteRate 15.9 15.7 15.5 -- --

By default, the suppliers are sorted by the number of customers signed on this site.

  • No signup fees apply. Prices include utility administrative and compressor fuel charges.
  • Take note of differences in automatic renewal in the Term clauses.
  • Ontario Carbon Taxes:

  • Cap and Trade Customer Related Charge 3.3181 c/m3 (buried in the distribution charge)
  • Cap and Trade Facility Related Charge 0.0337 c/m3 (buried in the distribution charge)
  • Disclaimer: Energyshop provides prices on best efforts basis and is not responsible for errors.

    Notes:

    Companies above are licensed by the Ontario Energy Board.

    Transportation Note: Consider transportation costs in your cost comparison. Some gas marketers may add a transportation rate. We have posted the Transportation rate information for each of the marketers in the Features column above. Transport may be a fixed rate or a variable rate, changing each month. Union Gas on Jan 1, 2017 moved the transportation costs into the commodity rate and they removed the transportation rate that was in the southern Ontario regulated rates. Union Gas say that their Dawn Hub is within the Marcellas and Utica shale gas formations that extends south from Chatham, Ontario down through Pennsylvania and Ohio into West Virgina. Union stopped taking Alberta gas from the TransCanada Pipeline (TCPL) on Jan 1, 2017. The old Union South transport rate was mostly TCPL.

    Union sets their gas prices quarterly, using price information from about 6 weeks before the start of the quarter. If the price they have to pay for the gas used in that quarter is different from their price, they have to recover or give back the difference.

    They do this through a surcharge or credit spread over the following 3 to 12 months. These surcharges/credits apply only to those purchasing their gas from Union.

    in the Features column above.

    Questions? Go to our FAQs or post a question on the Ontario Natural Gas Price discussion forum.

    If you have a business or a group of related business using more than 50,000 m3 per year:  deregulated natural gas for your business.

    If you have been on a contract with a marketer that is coming to an end, make sure that you formally notify the marketer by responding to the renewal notice sent to you, or by sending a letter to the marketer! If you don't, you will likely be renewed automatically. More

    Regulated Union Gas South Rates

     
    Regulated Residential Rates based on 4,000 m³/ year
    Rate type Gas Supply
    ¢
    Adjust.
    ¢
    Delivery Chg
    ¢
    Transportation
    ¢
    Total
    ¢/m³
    Monthly
    Fee
    Estimated
    Bill
    South ON Res. 1st April 2018 - Rate M1 12.32 1.62 4.71 Incl. 18.65 $21.00 $998.03
    Union Gas South rates approved effective: April 1, 2018



    *Note: The Gas Supply Charge is what will change when you contract with a gas marketer. Gas marketers now have the option to control the charge for Transportation instead of allowing the utility to charge this item. Not all marketers have taken over this charge.

    The Storage fee that appears on your Union bill has been added into the Delivery column.

    The Adjust. column represents adjustments to the gas supply charge made by the utility (also known as a rate rider). It is usually due to the utility charging more or less than it cost them to buy the gas. This creates a surplus or deficit that has to be either paid back to customers, or collected as a surcharge.

    Unlike fixed rates from a gas marketer, when you purchase gas from the utility the rate is subject to change at any time by the utility and can change retroactively in an annual balancing calculation. In the tables above the Estimated Bill is the total that a customer would pay over a full year for the volume shown. To see how your bill will change with a fixed rate from a gas marketer, select a rate from the table at top and insert this rate into the light blue box above.

    Comparing and deciding among the various offers

    There are 2 decisions. The first is whether to continue with the utility's variable rate, which changes every 3 months and may have retroactive charges, or a fixed term rate with a marketer of 1-5 years. You can choose to lock in for a long period at a fixed rate, or choose totally variable rates and take your chances that rates won't go up. This decision depends on your budget and what you expect gas prices to do over the next few years. You can see the utility's current rate in the chart above.

    If you decide to go with a fixed price contract, your second decision is between marketers. Use our price chart to compare prices and features, and view the terms and conditions from each supplier.

    Learn more about deregulated gas markets and marketers.

    Regulated rates are not fixed rates, nor can they be

    In Ontario, the Ontario Energy Board (OEB) regulates utility rates. When market prices go up, utilities apply to the OEB to change rates. This is for future rates, but can they can also apply to make a retroactive charge! They can't offer fixed contracts. When you sign up with an energy marketer, you can avoid these unexpected rate changes. As you can see from the previous chart, marketers can offer you an arrangement to fit your situation.

    What's included in retail gas prices

    If you choose to buy from a gas marketer, your gas delivery won't change. You will still get a bill from your distribution utility which will indicate a Delivery charge and a Transportation Charge (usually the responsibility of your utility) - about 1/3 of your bill that goes to the utility, and a Gas Supply Charge - the remaining 2/3 that goes to the competitive gas supplier you chose. If you have rental equipment or a service contract, these will appear as well. The transportation charge is set by the marketer in Union Gas South territory and can also be the responsibility of the marketer in the Enbridge territory, depending on your contract with the marketer.

    Remember this split when comparing costs. Gas marketers offer rates on your Gas Supply charge, which is about 2/3 of your bill. Union Gas bills have four charges, as follows:

    • (1) Gas - Supply (¢/m3)*
    • (2) Transportation to Union Gas (¢/m3) Was removed Jan 1, 2017 but will appear on older bills
    • (3) Delivery to you (¢/m3)
    • (4) Storage Fee (¢/m3)
    • (5) Monthly Customer Charge ($/month)

    •  

    * Gas Supply is the charge that you compare with the rates from gas marketers. Transportation is a pipeline charge managed by all marketers in Union South, by the utility in the Union North and East territory and can be the responsibility of either Enbridge or the marketer (check your contract or directly with the marketer). Delivery to you and the Monthly Customer Charge are regulated rates charged by Union Gas. These latter rates are regulated by the Ontario Energy Board. As a result, when a promotional message claims a 10% saving, it is referring to 10% of the 2/3 controlled by the competitive supplier.

    Example: A typical annual gas bill is $1,200. One third of that, $400, is a regulated transportation and delivery charge (numbered 2, 3, and 4). The remaining $800 is the gas supply charge. A competitive gas supplier is offering a 10% saving is offering a saving of $80, which is 10% of the $800 gas supply charge.




Debugging Information
ColdFusion Server Standard 11,0,14,307976
Template /natural-gas-prices-Union-South-residential.cfm
Time Stamp 24-Jun-18 12:49 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
203 ms 203 ms 1 C:/inetpub/wwwroot/es/prices/on/gason-content.cfm
203 ms 203 ms 1 C:/inetpub/wwwroot/es/prices/on/gason.cfm
203 ms 203 ms 1 top level C:\inetpub\wwwroot\natural-gas-prices-Union-South-residential.cfm
172 ms 172 ms 1 CFC[ C:/inetpub/Scripts/components/PriceTable.cfc | getConsumerPriceTable(argumentCollection = [complex value]) ] from C:/inetpub/Scripts/components/PriceTable.cfc
15 ms 15 ms 1 CFC[ C:/inetpub/Scripts/components/RateRider.cfc | GetAlertMessage(4) ] from C:/inetpub/Scripts/components/RateRider.cfc
0 ms 0 ms 1 C:/inetpub/Scripts/newldcgas.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/Application.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/anti-sql-injection.cfm
0 ms 0 ms 3 C:/inetpub/wwwroot/es/prices/on/openwindow.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/esfw/copyright-notice.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/esfw/fb-script-rec.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/esfw/fb-widget-rec.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-gas-table.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/esfw/page_headers/header-residential.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
203 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\on\gason-content.cfm @ 00:49:25.025
Select province, province_code from province
getLdcName (Datasource=M3Direct, Time=0ms, Records=1) in C:\inetpub\wwwroot\es\prices\on\gason-content.cfm @ 00:49:25.025
SELECT L.ldc_id, L.ldc_name, U.units, L.volume_res
FROM   ldc L INNER JOIN units U on L.units_id = U.units_id
WHERE  ldc_id=4 
qryLDC (Datasource=M3Direct, Time=0ms, Records=1) in C:\inetpub\Scripts\components\RateRider.cfc @ 00:49:25.025
SELECT LTRIM(RTRIM(ldc_name)) AS [Name]
FROM   ldc
WHERE  (ldc_id = 4)
qryPrice (Datasource=M3Direct, Time=15ms, Records=1) in C:\inetpub\Scripts\components\RateRider.cfc @ 00:49:25.025
SELECT     P.gassupply as Price, P.rate_rider as Rider, P.ldcgas_startdate as StartDate, P.ldcgas_enddate as EndDate, P.ldc_id, RTRIM(LTRIM(P.ldcgas_numonic)) as Numonic, RTRIM(LTRIM(ldcGas)) as sRate, 0 as Total, '' as sValue
FROM         ldcgas P 
WHERE     (P.ldcgas_enddate >= GETDATE()) AND (P.ldc_id = 4) AND (P.ldcgasclass = 'residential')
ORDER BY StartDate, Numonic
qryUnits (Datasource=M3Direct, Time=0ms, Records=1) in C:\inetpub\Scripts\components\RateRider.cfc @ 00:49:25.025
SELECT     RTRIM(LTRIM(U.units)) as Units
FROM       ldc L
INNER JOIN units U ON L.units_id = U.units_id
WHERE     (L.ldc_id = 4)
qryLDC (Datasource=M3Direct, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:49:25.025
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) = 4

qryLDCs (Datasource=M3Direct, Time=0ms, Records=6) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:49:25.025
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 = 'ON') AND (enertype = 'gas') 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:49:25.025
SELECT volume_res as Volume
FROM ldc
WHERE (ldc_id=4)
qryExcludedSuppliers (Datasource=M3Direct, Time=0ms, Records=0) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:49:25.025
		SELECT supplier_id as ID
		FROM   supplieroema
		WHERE  (nameofsupplier LIKE 'Direct%Energy%Business%')
		
qryPrice (Datasource=M3Direct, Time=0ms, Records=7) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:49:25.025
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 = 4)
AND (P.lowvolumelimit <= 3400) 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=3) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:49:25.025
SELECT DISTINCT priceclass
FROM   qry
ORDER BY months,priceclass
qrySupplierBase (Datasource=, Time=0ms, Records=3) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:49:25.025
			SELECT DISTINCT nameofsupplier, supplier_ID as ID, energyshop as Online
			FROM   strQueries.qryPrices
			ORDER BY energyshop DESC, nameofsupplier
			
qrySignupOnly (Datasource=, Time=0ms, Records=2) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:49:25.025
			SELECT *
			FROM   qrySupplierBase
			WHERE  (online = 'yes')
			
qryTopSellers (Datasource=M3Direct, Time=125ms, Records=12) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:49:25.025
			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 = 4)
			
			AND (RS.supplier_id IN (382,397))
			ORDER BY R.quote_request_id DESC
			
qryTopSellers (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:49:25.025
			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=2) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:49:25.025
				SELECT DISTINCT ID, Online
				FROM   qrySupplierBase
				WHERE  (ID NOT IN (397))
				ORDER BY Online DESC, nameofsupplier
				
qrySingleSupplier (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:49:25.025
				SELECT *
				FROM   qrySupplierBase
				WHERE  (ID = 397)
				
qrySingleSupplier (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:49:25.025
				SELECT *
				FROM   qrySupplierBase
				WHERE  (ID = 382)
				
qrySingleSupplier (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:49:25.025
				SELECT *
				FROM   qrySupplierBase
				WHERE  (ID = 272)
				
qrySorted (Datasource=, Time=0ms, Records=7) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:49:25.025
			SELECT   *
			FROM     strQueries.qryPrices
			ORDER BY supplier_id
			
qrySupplierNames (Datasource=, Time=16ms, Records=3) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:49:25.025
			SELECT *
			FROM qrySupplierNames
			WHERE (nameOfSupplier <> '') OR (ID <> 0)
			
qrySingleSupplier (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:49:25.025
		SELECT *
		FROM qrySorted
		WHERE (supplier_id = 397) AND (priceclass = '1 Year<br>Fixed Price')
		
qrySingleSupplier (Datasource=, Time=0ms, Records=0) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:49:25.025
		SELECT *
		FROM qrySorted
		WHERE (supplier_id = 397) AND (priceclass = '3 Year<br>Fixed Price')
		
qrySingleSupplier (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:49:25.025
		SELECT *
		FROM qrySorted
		WHERE (supplier_id = 397) AND (priceclass = '5 Year<br>Fixed Price')
		
qryBonus (Datasource=, Time=0ms, Records=2) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:49:25.025
	SELECT DISTINCT bonus
	FROM qrySorted
	WHERE (supplier_id = 397)
	ORDER by bonus DESC
	
qryBonusTxt (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:49:25.025
		SELECT DISTINCT bonusdesc
		FROM qrySorted
		WHERE (supplier_id = 397) AND (bonusdesc <> '')
		
qrySignupStatus (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:49:25.025
	SELECT DISTINCT energyshop
	FROM   qrySorted
	WHERE  (supplier_id = 397)
	
qrySingleSupplier (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:49:25.025
		SELECT *
		FROM qrySorted
		WHERE (supplier_id = 382) AND (priceclass = '1 Year<br>Fixed Price')
		
qrySingleSupplier (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:49:25.025
		SELECT *
		FROM qrySorted
		WHERE (supplier_id = 382) AND (priceclass = '3 Year<br>Fixed Price')
		
qrySingleSupplier (Datasource=, Time=0ms, Records=0) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:49:25.025
		SELECT *
		FROM qrySorted
		WHERE (supplier_id = 382) AND (priceclass = '5 Year<br>Fixed Price')
		
qryBonus (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:49:25.025
	SELECT DISTINCT bonus
	FROM qrySorted
	WHERE (supplier_id = 382)
	ORDER by bonus DESC
	
qryBonusTxt (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:49:25.025
		SELECT DISTINCT bonusdesc
		FROM qrySorted
		WHERE (supplier_id = 382) AND (bonusdesc <> '')
		
qrySignupStatus (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:49:25.025
	SELECT DISTINCT energyshop
	FROM   qrySorted
	WHERE  (supplier_id = 382)
	
qrySingleSupplier (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:49:25.025
		SELECT *
		FROM qrySorted
		WHERE (supplier_id = 272) AND (priceclass = '1 Year<br>Fixed Price')
		
qrySingleSupplier (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:49:25.025
		SELECT *
		FROM qrySorted
		WHERE (supplier_id = 272) AND (priceclass = '3 Year<br>Fixed Price')
		
qrySingleSupplier (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:49:25.025
		SELECT *
		FROM qrySorted
		WHERE (supplier_id = 272) AND (priceclass = '5 Year<br>Fixed Price')
		
qryBonus (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:49:25.025
	SELECT DISTINCT bonus
	FROM qrySorted
	WHERE (supplier_id = 272)
	ORDER by bonus DESC
	
qrySignupStatus (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:49:25.025
	SELECT DISTINCT energyshop
	FROM   qrySorted
	WHERE  (supplier_id = 272)
	
getPriceDate (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:49:25.025
SELECT MAX(oemaprice_dstamp) as LastChange
FROM   strQueries.qryPrices
getldcgas (Datasource=M3Direct, Time=0ms, Records=1) in C:\inetpub\Scripts\newldcgas.cfm @ 00:49:25.025
	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, rate_rider
	from ldcgas where
	ldc_id = ?
	and ldcgas_enddate > GETDATE()
	and ldcgasclass = 'residential'
	order by ldcgas_numonic
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4

qryCheckForRiders (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\newldcgas.cfm @ 00:49:25.025
SELECT rate_rider
FROM  getldcgas 
WHERE  (rate_rider <> 0)


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\natural-gas-prices-Union-South-residential.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=/natural-gas-prices-Union-South-residential.cfm
HTTP_USER_AGENT=CCBot/2.0 (http://commoncrawl.org/faq/)
LOCAL_ADDR=209.250.137.194
PATH_INFO=
PATH_TRANSLATED=C:\inetpub\wwwroot\natural-gas-prices-Union-South-residential.cfm
QUERY_STRING=
REMOTE_ADDR=54.145.103.69
REMOTE_HOST=54.145.103.69
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/natural-gas-prices-Union-South-residential.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=10918708
CFTOKEN=84cd5b6547770e3d-E13CBE3F-CC3F-39D9-3982373E822EA5D2
Session Variables:
bremovebusiness=false
rateclass=res
sessionid=14A64957174538FC864587451643FECC.cfusion
urltoken=CFID=10918708&CFTOKEN=84cd5b6547770e3d-E13CBE3F-CC3F-39D9-3982373E822EA5D2&jsessionid=14A64957174538FC864587451643FECC.cfusion
URL Parameters:
LDC_ID=4
Debug Rendering Time: 15 ms