<% '============= Create and Open Database Connection ============= 'OPEN THE DATABASE If blnConnectToDB Then dim blnDBconnectionDown blnDBconnectionDown = false Err.Clear on error resume next set dbConn = Server.CreateObject("ADODB.Connection") 'Open the Connnection 'dbConn.Open Application("dbConn_ConnectionString") dbConn.Open "DSN=PostgreSQL30", "eere_news", "33reNews" ''New Error trapping. KC added 2/23/2012 If Err.Number <> 0 Then ''Response.Write (Err.Description& "

") dbConn.Close Set dbConn = nothing blnDBconnectionDown = true End If On Error GoTo 0 ''error trapping not working here KC removed 2/23/2012 ''tmpDBErrorNativeError = 0 '' For Each dbErr In dbConn.Errors '' strErrMsg = strErrMsg & _ '' "Source: " & dbErr.Source & vbCrLF & _ '' "Description: " & dbErr.Description & vbCrLF & _ '' "SQL State: " & dbErr.SQLState & vbCrLF & _ '' "NativeError: " & dbErr.NativeError & vbCrLF & _ '' "Number: " & dbErr.Number & vbCrLF & vbCrLF '' tmpDBErrorNativeError = dbErr.NativeError '' Next '' If (dbConn.Errors.Count > 0) AND (tmpDBErrorNativeError <> 5703) Then '' dbConn.Close '' Set dbConn = nothing '' blnDBconnectionDown = true '' Response.write(strErrMsg) '' Response.end '' End If dim arrErrors() Redim arrErrors(2,0) End If '============================================================== Public Function GetRS2(myCommand) On Error GoTo 0 'objConn: local connection object 'objRS: local recordset object 'objComm: command object passed in to the function Dim objConn, objRS, blnErrorLogged, objComm 'Create the command object Set objComm = Server.CreateObject("ADODB.Command") Set objComm = myCommand 'Create the connection object Set objConn = Server.CreateObject("ADODB.Connection") 'Open the connection object objConn.Open "DSN=PostgreSQL30", "eere_news", "33reNews" 'Set the active connection objComm.ActiveConnection = objConn 'Create the recordset object Set objRS = Server.CreateObject("ADODB.Recordset") 'Set the cursor location for disconnected recordsets 'objRS.CursorLocation = adUseClient 'Turn on error handling for just a second ' On Error Resume Next 'Open the recordset 'objRS.Open SQL, objConn, adOpenStatic, adLockOptimistic Set objRS = objComm.Execute 'Response.Write "State = " & objRS.State & "
" 'objRS.MoveLast 'objRS.MoveFirst 'Response.Write "Count = " & objRS.RecordCount & "
" 'Response.End 'Check for an error ' If Err.Number <> 0 Then ' Response.Write "Database Error Occured

" ' Response.Write "Error #" & Err.Number & "
" ' Response.Write Err.Description & "

" ' Response.Write "SQL:
" ' Response.Write SQL ' Response.End ' End If 'Turn off error handling ' On Error GoTo 0 'Disconnect the recordset 'Set objComm.ActiveConnection = Nothing 'Close the connection 'objConn.Close 'Set the connection to Nothing 'Set objConn = Nothing 'Set the Command to Nothing 'Set objComm = Nothing 'Return the recordset Set GetRS2 = objRS On Error Resume Next End Function '=============================================================== Function GetRS(sSQL) 'Declarations dim rs 'Create Recordset Object set rs = Server.CreateObject("ADODB.Recordset") If blnConnectToDB Then 'Open Recordset based on SQL rs.Open sSQL, dbConn, 1, 3, 1 End If 'Return Recordset set GetRs = rs End Function '=============================================================== Function ExecSQL(sSQL) 'Open the Command Object dim lRecordsAffected dbConn.Execute sSQL, lRecordsAffected 'Return the Records Affected ExecSQL = lRecordsAffected End Function '======================================================================== Function sendEmail(strFrom,strTo,strSubject,strMessage) Dim sch ' Schema sch = "http://schemas.microsoft.com/cdo/configuration/" Set cdoConfig = CreateObject("CDO.Configuration") With cdoConfig.Fields .Item(sch & "sendusing") = 2 .Item(sch & "smtpserver") = "mxrelay.doe.gov" .update End With Set cdoMessage = CreateObject("CDO.Message") With cdoMessage Set .Configuration = cdoConfig .From = strFrom .To = strTo .Subject = strSubject .TextBody = strMessage .Send End With Set cdoMessage = Nothing Set cdoConfig = Nothing End Function Function removeBadChars(tmpString) tmpString = Replace(tmpString , "<", "") tmpString = Replace(tmpString , ">", "") tmpString = Replace(tmpString , "'", "") tmpString = Replace(tmpString , """", "") tmpString = Replace(tmpString , ";", "") tmpString = Replace(tmpString , "(", "") tmpString = Replace(tmpString , ")", "") removeBadChars = tmpString End Function %> <% 'If there is a mobile version of this site, check the user_agent, and forward to 'the mobile version of the site (unless cookie or querystring var is set) if "true" = "true" then tmpSeeFullPage = Mid(Request.Querystring("m"),1,1) if ((isMobile) and (tmpSeeFullPage <> "1")) then tmpMobileURL = Request.servervariables("HTTP_URL") tmpMobileFileName = mid(tmpMobileURL, InStrRev(tmpMobileURL, "/")+1) tmpMobileURL = Left(tmpMobileURL, InStrRev(tmpMobileURL, "/")) tmpMobileURL = tmpMobileURL & "m/" & tmpMobileFileName Response.Clear Response.Redirect(tmpMobileURL) end if end if %>

<% ''This code is strictly when a user clicks on a left nav and needs to be forwarded to another site/program/office if ("" <> "") then Response.Clear Response.Redirect ("") end if %>

Covered Product Category: Luminaires (Light Fixtures)

Did You Know?
The ENERGY STAR luminaires product category covers a wide range of lighting products, both residential and commercial.

ENERGY STAR Qualified Products

Updated March 2013

FEMP provides acquisition guidance and Federal efficiency requirements across a variety of product categories, including luminaires, or light fixtures. The luminaires product category is very broad and covers a wide variety of lighting products. Both ENERGY STAR® and FEMP provide programmatic guidance for various types of luminaires. See table 2 for more information about which types of light fixtures are covered by which program (FEMP or ENERGY STAR). Federal laws and executive orders mandate that agencies meet these efficiency requirements in all procurement and acquisition actions that are not specifically exempted by law.

For luminaire types covered by ENERGY STAR, manufacturers display the ENERGY STAR label on complying models. Check the qualified products list maintained on the ENERGY STAR website to see if a model is ENERGY STAR–qualified. For luminaire types covered by FEMP, product efficiency requirements are provided in the relevant product overview guidance. See table 2 for more information.

This product category overview covers the following:

Meeting Energy Efficiency Requirements for Luminaires (Light Fixtures)

A list of ENERGY STAR–qualified luminaires and the most up-to-date efficiency levels are available from the ENERGY STAR website. Buy products with the ENERGY STAR label and/or check the ENERGY STAR–qualified products list. Buyers can assume that ENERGY STAR–qualified products are life cycle cost-effective; if a Federal buyer finds this is not the case, or that a qualified product is not reasonably available, then the head of the agency must document in writing this justification for an exception.

Table 1. Efficiency Requirementsa for Federal Purchasesb
Luminaire Type Luminaire Efficacy (Initial)
Portable Desk Task ≥ 29 lumens per watt
Downlight (recessed, surface mount, pendant, SSL retrofit) ≥ 42 lumens per watt
Under-Cabinet ≥ 29 lumens per watt
Accent ≥ 35 lumens per watt

a The ENERGY STAR specification for luminaires includes a number of requirements to ensure lighting quality. This table provides the ENERGY STAR luminous efficacy requirements for directional commercial luminaires. Consult the ENERGY STAR specification for full qualification requirements, including additional product types and additional measures of luminaire quality.
b Requirements as of April 2012. For the latest efficiency requirements, visit the ENERGY STAR Product Specifications website and look up light fixtures in the Lighting & Fans section.

Back to top

Defining the Covered Product Category

The ENERGY STAR product specification for luminaires (light fixtures) applies to both residential and commercial products, but this FEMP product overview provides acquisition guidance for only the most commonly used ENERGY STAR commercial products. See the ENERGY STAR website for more information on how products qualify for the ENERGY STAR label.

Table 2. Comparison of ENERGY STAR and FEMP-Designated Coverage of Commercial Lighting Products
Product Categories Covered by the ENERGY STAR Luminaires Specification Product Categories with FEMP-Designated Efficiency Requirements (Not Covered by ENERGY STAR)
Directional downlights—recessed, surface mount, or pendant Linear fluorescent lamps
Shelf-mounted display and task lights, such as those mounted under overhead storage cabinets Linear fluorescent luminaires (troffers)
Portable desk lamps Industrial (high bay) luminaires
Accent lights, including line-voltage track lighting Exterior lighting

Back to top

Reducing Energy Costs When You Buy ENERGY STAR–Qualified Products

Because of the wide variety of luminaire types that meet the ENERGY STAR specification, it is difficult to estimate how much energy a given product type could save. Buyers should consult with ENERGY STAR to determine cost-effectiveness for the specific product under consideration.

Determining When ENERGY STAR Is Cost-Effective

In general, ENERGY STAR–qualified luminaire products are life cycle cost-effective compared to alternatives using incandescent lamps. An efficient product is cost-effective when the lifetime energy savings (from avoided energy costs over the life of the product, discounted to present value) exceed the additional upfront cost (if any) compared to a less-efficient option. ENERGY STAR considers first cost and lifetime energy savings when setting required efficiency levels.


Products meeting ENERGY STAR performance specifications may not be life cycle cost-effective in certain low-use applications, such as when a device is being purchased for a fixture with low hours of operation. Operating conditions vary from facility to facility. To help determine cost-effectiveness in unusual operating conditions, consult with ENERGY STAR.

Back to top

Complying with Contracting Requirements

These requirements apply to all forms of procurement, including construction guide specifications and project specifications; renovation, repair, maintenance, and energy service contracts; lease agreements; acquisitions made using purchase cards; and solicitations for offers. Energy efficiency requirements should be included in both the evaluation criteria of solicitations and the evaluations of solicitation responses.

Federal Acquisition Regulation (FAR) Part 23.206 requires Federal agencies to insert the clause at FAR section 52.223-15 in solicitations and contracts that deliver, acquire, furnish, or specify energy-consuming products. FEMP recommends that agencies incorporate efficiency requirements into both the technical specification and evaluation sections of solicitations. Agencies may claim an exception to these requirements through a written finding that no ENERGY STAR–qualified or FEMP-designated product is available to meet the functional requirements, or that no such product is life cycle cost-effective for the specific application. Additional information on Federal requirements is available.

Back to top

Buyer Tips: Choosing Efficient Products

Downlight luminaires using incandescent lamps do not meet ENERGY STAR performance requirements. Federal law prohibits Federal buyers from purchasing incandescent downlights unless the head of their agency determines in writing that an exception is warranted. In lighting situations with low lumen output requirements, fluorescent lamps with electronic ballasts are recommended as replacements for incandescent lamps. Ceramic or pulse metal halide lamps, or solid state lighting, may be preferred in downlight applications requiring small dimensions or high color rendering qualities.

Back to top

User Tips: Using Products More Efficiently

Proper lighting design is critical to maximizing lighting efficiency. Commercial downlight luminaires, in particular, are often used in office and retail environments. The Advanced Lighting Guidelines website (registration required, free for Federal employees) provides specific design guidance for both office and retail lighting applications.

Where possible, task lamps and under-cabinet work surface lighting should be used in combination with lower ambient (overhead) light levels. Occupancy sensors can also provide savings for both task and overhead downlight fixtures. Integrated dimming systems with daylight controls are also available for use with downlight fixtures.

Back to top

Finding More Information

For more information about energy-efficient products, including publications, training, related links, and points of contact, visit the Resources for Energy-Efficient Products page.

Lawrence Berkeley National Laboratory provided supporting analysis for this product overview.

Back to top