Qty 
Item #: SFG6
Needlehold Spray (Clear)
2 2.5-Gallon Bottles
In Stock
50 lbs

$148.30

Needlehold Spray (Clear) is a needle retention product which is harmless to the tree, won't wash off or retard growth, while maintaining natural moisture. Needlehold Spray can also be used to extend the beauty of wreaths.

Once the spray is dry, the tree is coated with a durable film which lasts indefinitely. It is safe to use and after the spray is applied, presents no hazard to children or pets.

DIRECTION FOR USE:
Dilute at the rate of 1 pint Needlehold Spray to 2 pints of water & spray trees thoroughly. If temperature is below freezing spray indoors and allow tree to dry thoroughly before placing outdoors. Spray in field anytime before tree is cut or immediately after cutting. It can also be used on transplants or for prevention of winter damage at a dilution of 1 to 5. The spray will dry in 15 minutes on a moderately warm or sunny day; it may take a longer period to dry when it's cool and cloudy.

PRECAUTIONS:
Wear old clothing and shoes when applying; it is best to avoid spraying on windy days. Prevent spray from reaching sidewalks, buildings, etc. In the event the spray inadvertently reaches walk, buildings, or other objects, wash at once with scrub brush and water. Rubbing with dry sand or steel wool will remove Needlehold Spray from masonry after it dries.

Do not spray when is is below freezing or when frost is still on the trees. To ensure drying, it is best to spray when air temperature is about 40 F and when no immediate rain is anticipated. One 5 Gallon Case will do approx. 300 to 500 trees.

METHOD OF APPLICATION:
Various types of sprayers may be used (hand or power). Experimentation with the spray gun in hand is suggested to properly adjust pressure. Excessive pressure will give a very misty spray that may be subject to blowing. A gun delivering a high volume may be wasteful. The spray gun should be adjusted to give a fairly broad spray pattern. Needlehold Spray replaces Item# SFG3 - Clear Spray


Debugging Information
Lucee (Velvet) Os 5.2.9.31 (CFML Version 2016,0,03,300357)
Template /showitem.cfm (/var/www/html/kelcomaine/showitem.cfm)
Time Stamp Sep 15, 2019 7:57 AM
Time Zone UTC
Locale English (us)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 127.0.0.1
Host Name kelcomaine.com
Architecture 64bit


Execution Time

Total Time Avg Time Count Template
35 ms 8.76 ms 4 /var/www/html/kelcomaine/makemenu.cfm
4.48 ms 4.48 ms 1 /var/www/html/kelcomaine/getitemweb.cfm
2.73 ms 2.73 ms 1 /var/www/html/kelcomaine/addtocartform.cfm
1.41 ms 1.41 ms 1 /var/www/html/kelcomaine/getitemwebstylegroup.cfm
1.15 ms 1.15 ms 1 /var/www/html/kelcomaine/Application.cfc$onRequestStart
0.923 ms 0.923 ms 1 /var/www/html/kelcomaine/getwebblock.cfm
0.667 ms 0.667 ms 1 /var/www/html/kelcomaine/showitemdetail.cfm
0.317 ms 0.317 ms 1 /var/www/html/kelcomaine/pagetopandleft.cfm
0.163 ms 0.163 ms 1 /var/www/html/kelcomaine/Application.cfc
0.127 ms 0.127 ms 1 /var/www/html/kelcomaine/pagebottom.cfm
0.113 ms 0.113 ms 1 /var/www/html/kelcomaine/pagetop.cfm
0.113 ms 0.113 ms 1 /var/www/html/kelcomaine/pagetopstatus.cfm
0.09 ms 0.09 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc
0.029 ms 0.029 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc$checkUserAgentPrefix
0.025 ms 0.025 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc$wapDetection
0.021 ms 0.021 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc$checkUserAgentContains
0.015 ms 0.015 ms 1 /var/www/html/kelcomaine/wilsonlib.cfm
0.029 ms 0.014 ms 2 /var/www/html/kelcomaine/WEB-INF/lucee/context/Component.cfc
0.011 ms 0.011 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc$isMobile
0.008 ms 0.008 ms 1 /var/www/html/kelcomaine/cssheader.cfm
0.006 ms 0.006 ms 1 /var/www/html/kelcomaine/mobiledetection.cfc$init
0.004 ms 0.004 ms 1 /var/www/html/kelcomaine/showitemcheckparam.cfm
0.003 ms 0.003 ms 1 /var/www/html/kelcomaine/addtoprocess.cfm
0.001 ms 0.001 ms 1 /var/www/html/kelcomaine/addtocartbutton.cfm
0 ms 0 ms 1 /var/www/html/kelcomaine/showitem.cfm
0 ms 0 ms 1 /var/www/html/kelcomaine/Application.cfc$onRequest
0.492 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
33.7 ms  APPLICATION EXECUTION TIME
13.7 ms  QUERY EXECUTION TIME
48 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Implicit variable Access

Scope Template Line Var Count
variables /addtocartform.cfm 1 noanchor 1
variables /addtocartform.cfm 5 NOANCHOR 1
cgi /addtocartform.cfm 8 QUERY_STRING 1
query /addtocartform.cfm 8 ITEMN 1
query /addtocartform.cfm 12 ONHAND 1
query /addtocartform.cfm 12 RESERVED 1
query /addtocartform.cfm 28 BACKORDERMSG 1
query /addtocartform.cfm 29 ITEMN 1
query /addtocartform.cfm 30 ITEMN 1
variables /Application.cfc 34 MOBILEDETECTION 1
variables /Application.cfc 35 MOBILEDETECTION 1
variables /Application.cfc 88 cflock 1
variables /Application.cfc 108 CLIENT_IP 1
variables /Application.cfc 110 CLIENT_IP 1
variables /Application.cfc 112 RIP 1
variables /Application.cfc 112 CLIENT_IP 1
variables /Application.cfc 136 rip 1
variables /Application.cfc 137 RIP 1
variables /Application.cfc 143 CSEMAIL 1
variables /Application.cfc 145 SAFETAGS 1
variables /Application.cfc 147 ALWAYSINSTOCK 1
variables /getitemweb.cfm 4 WEBORDER 1
variables /getitemweb.cfm 40 WEBORDER 1
variables /getitemweb.cfm 41 ITEMN 1
variables /getitemweb.cfm 41 getitem 1
variables /getitemweb.cfm 41 cfquery 1
variables /getitemwebstylegroup.cfm 4 WEBORDER 1
variables /getitemwebstylegroup.cfm 23 STYLECODE 1
variables /getitemwebstylegroup.cfm 24 getitemwebstylegroup 1
variables /getitemwebstylegroup.cfm 24 cfquery 1
variables /getwebblock.cfm 2 BLOCK 1
variables /getwebblock.cfm 3 getwebblock 1
variables /getwebblock.cfm 3 cfquery 1
variables /makemenu.cfm 3 RETURN_VALUE 36
arguments /makemenu.cfm 3 TEMPLATE 36
arguments /makemenu.cfm 4 TEMPLATE 36
variables /makemenu.cfm 5 TAG_VALUE 3
variables /makemenu.cfm 6 RETURN_VALUE 6
variables /makemenu.cfm 6 TAG_VALUE 3
arguments /makemenu.cfm 8 TEMPLATE 36
variables /makemenu.cfm 9 RETURN_VALUE 6
variables /makemenu.cfm 11 RETURN_VALUE 36
variables /makemenu.cfm 21 MENUTABLE 4
variables /makemenu.cfm 24 getmenu 4
variables /makemenu.cfm 24 cfquery 4
variables /makemenu.cfm 26 menu_type 4
variables /makemenu.cfm 30 MENU_TYPE 4
variables /makemenu.cfm 33 SUBMENU 2
variables /makemenu.cfm 34 PREV_MENU_ORDER 2
variables /makemenu.cfm 35 FIRST 2
variables /makemenu.cfm 36 getmenu 2
variables /makemenu.cfm 37 PREV_MENU_ORDER 36
variables /makemenu.cfm 37 GETMENU 36
variables /makemenu.cfm 38 PREV_MENU_ORDER 8
variables /makemenu.cfm 38 GETMENU 8
variables /makemenu.cfm 39 SUBMENU 8
variables /makemenu.cfm 40 PREV_MENUTEXT 2
variables /makemenu.cfm 40 PREV_URL 2
variables /makemenu.cfm 43 FIRST 6
variables /makemenu.cfm 44 PREV_MENUTEXT 4
variables /makemenu.cfm 44 PREV_URL 4
variables /makemenu.cfm 47 SUBMENU 8
variables /makemenu.cfm 48 FIRST 8
variables /makemenu.cfm 49 GETMENU 8
variables /makemenu.cfm 49 PREV_URL 8
variables /makemenu.cfm 50 PREV_MENUTEXT 8
variables /makemenu.cfm 50 GETMENU 8
variables /makemenu.cfm 52 SUBMENU 28
variables /makemenu.cfm 53 PREV_MENUTEXT 25
variables /makemenu.cfm 53 PREV_URL 25
variables /makemenu.cfm 55 SUBMENU 28
variables /makemenu.cfm 56 PREV_MENUTEXT 3
variables /makemenu.cfm 56 PREV_URL 3
variables /makemenu.cfm 58 SUBMENU 3
variables /makemenu.cfm 60 PREV_URL 28
variables /makemenu.cfm 60 GETMENU 28
variables /makemenu.cfm 61 GETMENU 28
variables /makemenu.cfm 61 PREV_MENUTEXT 28
variables /makemenu.cfm 65 SUBMENU 2
variables /makemenu.cfm 67 PREV_MENUTEXT 1
variables /makemenu.cfm 67 PREV_URL 1
variables /makemenu.cfm 71 PREV_URL 1
variables /makemenu.cfm 71 PREV_MENUTEXT 1
variables /makemenu.cfm 74 SUBMENU 2
variables /makemenu.cfm 82 MENU_TYPE 4
variables /makemenu.cfm 83 FIRST 1
variables /makemenu.cfm 84 getmenu 1
variables /makemenu.cfm 85 FIRST 5
variables /makemenu.cfm 86 GETMENU 10
variables /makemenu.cfm 87 FIRST 5
variables /makemenu.cfm 91 MENU_TYPE 4
variables /makemenu.cfm 92 getmenu 1
variables /makemenu.cfm 93 GETMENU 10
variables /pagebottom.cfm 13 MENU_TYPE 1
variables /pagebottom.cfm 14 MENUTABLE 1
variables /pagetop.cfm 29 MENU_TYPE 1
variables /pagetop.cfm 30 MENUTABLE 1
variables /pagetopandleft.cfm 14 MENU_TYPE 1
variables /pagetopandleft.cfm 15 MENUTABLE 1
variables /pagetopandleft.cfm 17 MENU_TYPE 1
variables /pagetopandleft.cfm 18 MENUTABLE 1
variables /pagetopandleft.cfm 26 BLOCK 1
variables /pagetopandleft.cfm 28 GETWEBBLOCK 1
variables /pagetopstatus.cfm 1 BROWSELINKS 1
variables /pagetopstatus.cfm 3 BROWSEURL 1
variables /showitem.cfm 2 ITEMN 1
variables /showitem.cfm 7 itemn 1
variables /showitem.cfm 8 ITEMN 1
variables /showitem.cfm 8 ITEM4TEXT 1
variables /showitem.cfm 14 STYLECODE 1
variables /showitem.cfm 18 GETITEMWEBSTYLEGROUP 1
variables /showitem.cfm 27 itemn 1
variables /showitem.cfm 28 GETITEM 1
variables /showitem.cfm 69 GETITEM 1
variables /showitem.cfm 69 ST 1
variables /showitem.cfm 70 ST 1
variables /showitem.cfm 100 ITEM4TEXT 1
variables /showitem.cfm 101 cfquery 1
variables /showitem.cfm 101 getitemtext 1
variables /showitem.cfm 104 GETITEM 1
variables /showitem.cfm 111 NOANCHOR 1
variables /showitem.cfm 118 IMAGEITEMN 1
variables /showitem.cfm 119 getitem 1
query /showitem.cfm 120 ITEMN 2
variables /showitem.cfm 120 IMAGESRC 1
variables /showitem.cfm 121 IMAGEITEMN 1
query /showitem.cfm 121 ITEMN 1
query /showitem.cfm 122 PICFILE1 1
query /showitem.cfm 123 PICFILE1 1
variables /showitem.cfm 123 IMAGESRC 1
variables /showitem.cfm 124 IMAGEITEMN 1
variables /showitem.cfm 124 IMAGESRC 1
variables /showitem.cfm 126 GETITEMWEBSTYLEGROUP 1
variables /showitem.cfm 129 LARGEPIC 1
variables /showitem.cfm 130 SAMPLEPIC 1
variables /showitem.cfm 131 IMAGESRC 1
variables /showitem.cfm 132 IMAGESRC 1
variables /showitem.cfm 138 GETITEMWEBSTYLEGROUP 1
query /showitem.cfm 181 ZOOM 1
query /showitem.cfm 182 ITEMN 1
query /showitem.cfm 194 ITEMN 1
variables /showitem.cfm 195 cfquery 1
variables /showitem.cfm 195 image 1
variables /showitem.cfm 196 IMAGE 1
query /showitem.cfm 197 ITEMN 1
variables /showitem.cfm 201 LARGEPIC 1
variables /showitem.cfm 203 IMAGE 1
variables /showitem.cfm 209 GETITEMWEBSTYLEGROUP 1
variables /showitem.cfm 212 GETITEMTEXT 1
variables /showitemdetail.cfm 2 SHOWHEADER 1
variables /showitemdetail.cfm 4 getitem 1
query /showitemdetail.cfm 23 OUTFORSEASON 1
query /showitemdetail.cfm 23 ACTIVE 1
query /showitemdetail.cfm 24 ORDERED 1
query /showitemdetail.cfm 42 ITEMN 1
query /showitemdetail.cfm 45 WEBDESC 1
query /showitemdetail.cfm 48 WEBSIZE 1
query /showitemdetail.cfm 54 ONHAND 1
query /showitemdetail.cfm 54 WEIGHT 1
query /showitemdetail.cfm 54 RESERVED 1
query /showitemdetail.cfm 55 LARGEPACKAGE 1
query /showitemdetail.cfm 55 largepackage 1
query /showitemdetail.cfm 60 PRICE 1
arguments /wilsonlib.cfm 25 STR 1
arguments /wilsonlib.cfm 33 STR 17
arguments /wilsonlib.cfm 34 STR 16
arguments /wilsonlib.cfm 41 STR 1
arguments /wilsonlib.cfm 42 STR 1
arguments /wilsonlib.cfm 43 STR 1
arguments /wilsonlib.cfm 57 STR 2
arguments /wilsonlib.cfm 58 STR 2
arguments /wilsonlib.cfm 62 STR 2
arguments /wilsonlib.cfm 63 STR 1


SQL Queries

getitem (Datasource=kelcodbpsql, Time=4.04 ms, Records=1) in /var/www/html/kelcomaine/getitemweb.cfm
the following colum(s) are never read within the request:line,type,base_price,kit_available
SELECT
     "item_web"."itemn" AS itemn,
     "item_web"."webdesc" AS webdesc,
     "item_web"."websize" AS websize,
     "item_web"."pagetext" AS pagetext,
     "item_web"."picfile1" AS picfile1,
     "item_web"."backordermsg" AS backordermsg,
     COALESCE("item_webimages"."zoom",(SELECT zoom FROM item_webimages AS iwi WHERE iwi.itemn = (SELECT sameasitemn FROM item_webimages AS tiwi WHERE tiwi.itemn = item_web.itemn))) AS zoom,
     "item"."base_price" AS base_price,
     "item"."base_price" AS price,
     "item"."weight" AS weight,
     "item"."onhand" AS onhand,
     "item"."reserved" AS reserved,
     "item"."active" AS active,
     "item"."outforseason" AS outforseason,
     "item"."largepackage" AS largepackage,
     "worderitem"."line" AS line,
     "worderitem"."ordered" AS ordered,
     "item"."type" AS type,
       FLOOR(MIN((item_kit.onhand - item_kit.reserved)/item_kit.compqty)) AS kit_available
      FROM "item" left OUTER JOIN
        ( select parentitemn, compqty, onhand, reserved from item_component join item ON childitemn = item.itemn )
        AS item_kit ( parentitemn, compqty, onhand, reserved )
        ON (item_kit.parentitemn = item.itemn),
          "item_web" left OUTER JOIN "worderitem"
        ON "item_web"."itemn" = "worderitem"."itemn" and "worderitem"."weborder" = 0 LEFT OUTER JOIN "item_webimages" ON "item_webimages"."itemn" = "item_web"."itemn"
      WHERE "item"."itemn" = "item_web"."itemn" and "item_web"."itemn" = 'SFG6' and "item_web"."sitecode" = 'K' and "item"."discontinued" = 'N' and "item"."not_for_website" = 'N' AND "item_web"."web_class" <> 'ZZZ'
      GROUP BY item_web.itemn, webdesc, websize, pagetext, picfile1, zoom, price, weight, item.onhand, type, item.reserved, active, outforseason, largepackage, line, ordered, backordermsg;
getitemwebstylegroup (Datasource=kelcodbpsql, Time=1.07 ms, Records=0) in /var/www/html/kelcomaine/getitemwebstylegroup.cfm
the following colum(s) are never read within the request:stylegroupitem,pagetext,feature1,feature1value,styledesc,defaultitem,stylecode
SELECT
     "web_stylegroup"."stylecode" AS stylecode,
     "web_stylegroup"."styledesc" AS styledesc,
     "web_stylegroup"."pagetext" AS pagetext,
     "web_stylegroup"."feature1" AS feature1,
     "web_stylegroup"."defaultitem" AS defaultitem,
     "item_web"."feature1value" AS feature1value,
     "item_web"."itemn" AS stylegroupitem
   FROM "web_stylegroup","item_web","item" WHERE "web_stylegroup"."stylecode" = '' and "item_web"."stylecode" = "web_stylegroup"."stylecode" and
     item.itemn = item_web.itemn and item.active = 'Y' and item.discontinued = 'N' and "item"."not_for_website" = 'N' AND "item_web"."web_class" <> 'ZZZ'
   ORDER BY feature1value
getmenu (Datasource=kelcodbpsql, Time=0.624 ms, Records=5) in /var/www/html/kelcomaine/makemenu.cfm
the following colum(s) are never read within the request:orderseq,menu_order,pageid
SELECT
	 "pageid",
         REPLACE("menutext",' & ',' & ') as menutext,
         REPLACE("url",' & ',' %26 ') AS url,
         "menu_order",
         "orderseq"
         FROM web_navmenu
         WHERE site='K' 
         ORDER BY menu_order, orderseq
getmenu (Datasource=kelcodbpsql, Time=1.25 ms, Records=31) in /var/www/html/kelcomaine/makemenu.cfm
the following colum(s) are never read within the request:orderseq,pageid
SELECT
	 "pageid",
         REPLACE("menutext",' & ',' & ') as menutext,
         REPLACE("url",' & ',' %26 ') AS url,
         "menu_order",
         "orderseq"
         FROM web_menuview
         WHERE site='K' 
         ORDER BY menu_order, orderseq
getmenu (Datasource=kelcodbpsql, Time=0.856 ms, Records=5) in /var/www/html/kelcomaine/makemenu.cfm
the following colum(s) are never read within the request:orderseq,pageid
SELECT
	 "pageid",
         REPLACE("menutext",' & ',' & ') as menutext,
         REPLACE("url",' & ',' %26 ') AS url,
         "menu_order",
         "orderseq"
         FROM web_navmenu
         WHERE site='K' 
         ORDER BY menu_order, orderseq
getwebblock (Datasource=kelcodbpsql, Time=0.63 ms, Records=1) in /var/www/html/kelcomaine/getwebblock.cfm
select block_text from web_block where block_key='Kelco Store'
getitemtext (Datasource=kelcodbpsql, Time=0.659 ms, Records=1) in /var/www/html/kelcomaine/showitem.cfm
SELECT
	"item_web"."pagetext" AS pagetext
FROM   "item_web"
WHERE "item_web"."itemn" = 'SFG6'  and "item_web"."sitecode" = 'K'
image (Datasource=kelcodbpsql, Time=3.64 ms, Records=1) in /var/www/html/kelcomaine/showitem.cfm
SELECT COALESCE("item_webimages"."image",(SELECT image FROM item_webimages AS iwi WHERE iwi.itemn = item_webimages.sameasitemn)) AS image, COALESCE("item_webimages"."zoom",(SELECT zoom FROM item_webimages AS iwi WHERE iwi.itemn = item_webimages.sameasitemn)) AS zoom FROM item_webimages WHERE itemn = 'SFG6'
getmenu (Datasource=kelcodbpsql, Time=1 ms, Records=5) in /var/www/html/kelcomaine/makemenu.cfm
the following colum(s) are never read within the request:orderseq,menu_order,pageid
SELECT
	 "pageid",
         REPLACE("menutext",' & ',' & ') as menutext,
         REPLACE("url",' & ',' %26 ') AS url,
         "menu_order",
         "orderseq"
         FROM web_navmenu
         WHERE site='K' 
         ORDER BY menu_order, orderseq


Scope Variables

Application Variables:
applicationname=
INITIALIZED=1
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=/var/www/html/kelcomaine/showitem.cfm
content_length=
content_type=
context_path=
gateway_interface=
http_accept=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
http_accept_encoding=gzip
http_accept_language=en-US,en;q=0.5
http_connection=close
http_cookie=
http_host=kelcomaine.com
http_referer=
http_user_agent=CCBot/2.0 (https://commoncrawl.org/faq/)
https=off
https_keysize=
https_secretkeysize=
https_server_issuer=
https_server_subject=
local_addr=127.0.0.1
local_host=ec2trixie.kelcomaine.com
path_info=
path_translated=/var/www/html/kelcomaine/showitem.cfm
query_string=item=SFG6&type=P
remote_addr=127.0.0.1
remote_host=127.0.0.1
remote_user=
request_method=GET
request_url=http://kelcomaine.com/showitem.cfm?item=SFG6&type=P
script_name=/showitem.cfm
server_name=kelcomaine.com
server_port=80
server_port_secure=0
server_protocol=HTTP/1.1
server_software=
web_server_api=
Cookie Variables:
cfid=cb457385-7a0c-42a3-b3e6-d4f7c60080a1
cftoken=0
HTTPREFERER=
initialized=1
REMOTEIP=35.173.57.202
Request Variables:
cart_items=0
Server Variables:
coldfusion=Struct (9)
java=Struct (8)
lucee=Struct (8)
os=Struct (8)
separator=Struct (3)
servlet=Struct (1)
system=Struct (2)
Session Variables:
cfid=cb457385-7a0c-42a3-b3e6-d4f7c60080a1
cftoken=0
INITIALZOOM=1
lastvisit={ts '2019-09-15 07:57:39'}
MOBILEMODE=false
SCREENHEIGHT=768
SCREENWIDTH=1024
sessionid=_cb457385-7a0c-42a3-b3e6-d4f7c60080a1_0
timecreated={ts '2019-09-15 07:57:39'}
urltoken=CFID=cb457385-7a0c-42a3-b3e6-d4f7c60080a1&CFTOKEN=0
URL Variables:
item=SFG6
type=P
Debug Rendering Time: 0 ms