: : TVSpy Home 
  : : Log In 
  : : Member Home 
  : : Forget Password? 
  : : Change E-mail 
  : : FAQ & Contact Info 
  : : ShopTalk Subscription 









TVSPY Directories

Audio
Coaches and Consultants
Demo Reel
Hardware
Journalism Schools
News Services
Organizations and Unions
Talent Agents

Recruiting Services

TVSpy Job Bank
Post Job
Search Jobs

Talent & Freelance Directory
Search Resumes
Search Tapes
Submit Resumes
Submit Tapes

Today's Candidate

ShopTalk

Subscribe to ShopTalk
Read Now!
Shoptalk Archives

Exchange Information

Watercoolers
TVSpy Watercooler
The Sandbox
Hollywood Network
Marketing Matters

Employer Surveys
Submit a Survey
Search Surveys








ShopTalk is e-mailed daily from the servers of Vault, Inc. in New York City. If you would like to receive a FREE subscription to ShopTalk, simply follow these directions.

To subscribe to Shoptalk, simply join as a TVSpy member for FREE and choose either the HTML or text version. If you're already a TVSpy member, simply log in and click "Yes" for the ShopTalk subscription question.

Join Now

Log In

To unsubscribe from Shoptalk, log in to your TVSpy member home page and click "No" for the ShopTalk subscription question.

Member Home




AUDIO


COACHES AND CONSULTANTS

More Coaches and Consultants Listings

Poynter Institute

Media Recruiter.com

DEMO REEL SERVICES


HARDWARE

More Hardware Listings

Calrec Audio Ltd.

EVS

JOURNALISM SCHOOLS

More Journalism Schools Listings

USC- Annenberg School of Communication

Columbia Graduate School of Journalism

ORGANIZATIONS AND UNIONS

More Organizations and Unions Listings

RTNDA

National Press Photographers Association

TALENT AGENTS

More Talent Agents Listings

Napoli Management

Ken Lindner & Associates




About TVSpy  |  About Vault  |  FAQ & Contact Info  |  Advertise with TVSpy  |   Subscribe to Shoptalk  |  Subscribe to Next Generation TV

© 2009, Vault, Inc.
Comments or Suggestions? Contact TVSpy

Watercooler Admin  |  HN Admin  |  Sandbox Admin  |  NextGen Admin  |  NextGen Admin


Debugging Information
ColdFusion Server Enterprise 7,0,0,91690
Template /admin.cfm
Time Stamp 09-Feb-10 10:05 AM
Locale English (US)
User Agent CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Remote IP 209.208.132.227
Host Name 209.208.132.227


Execution Time

Total Time Avg Time Count Template
78 ms 78 ms 1 E:\Inetpub\wwwroot\tvspy\admin.cfm
62 ms 62 ms 1 E:\Inetpub\wwwroot\tvspy\_far-right.cfm
62 ms 62 ms 1 E:\Inetpub\wwwroot\tvspy\directories\_directoryinclude.cfm
16 ms 16 ms 1 E:\Inetpub\wwwroot\tvspy\_top.cfm
16 ms 16 ms 1 E:\Inetpub\wwwroot\tvspy\ads\_adincludetop.cfm
0 ms 0 ms 1 E:\Inetpub\wwwroot\tvspy\Application.cfm
0 ms 0 ms 1 E:\Inetpub\wwwroot\tvspy\_bottom.cfm
0 ms 0 ms 1 E:\Inetpub\wwwroot\tvspy\_left.cfm
0 ms 0 ms 1 E:\Inetpub\wwwroot\tvspy\_subscribe.cfm
0 ms 0 ms 1 E:\Inetpub\wwwroot\tvspy\ads\_adinclude-tiles.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
78 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

getcategories (Datasource=vault, Time=0ms, Records=7) in E:\Inetpub\wwwroot\tvspy\directories\_directoryinclude.cfm @ 10:05:00.000
					SELECT categorytitle,storefront_categories.storefrontcategory_id
					from channels,storefront_categories
					WHERE channels.ch_id=storefront_categories.ch_id
					and storefront_categories.ch_id=345
					order by categorytitle
getfeaturedstorefronts (Datasource=vault, Time=0ms, Records=1) in E:\Inetpub\wwwroot\tvspy\directories\_directoryinclude.cfm @ 10:05:00.000
	SELECT distinct categorytitle,company,storefronts.storefront_id,shortcodescript,ORDERS,
	showcase,storefront_categories.storefrontcategory_id
	FROM storefronts,relate_storefront_ind,storefront_categories
	WHERE storefronts.storefront_id=relate_storefront_ind.storefront_id
	AND storefront_categories.storefrontcategory_id=relate_storefront_ind.storefrontcategory_id
	AND ch_id=345
	AND featured=1
	and relate_storefront_ind.storefrontcategory_id=1506
	order by ORDERS         
	
getfeaturedstorefronts (Datasource=vault, Time=15ms, Records=3) in E:\Inetpub\wwwroot\tvspy\directories\_directoryinclude.cfm @ 10:05:00.000
	SELECT distinct categorytitle,company,storefronts.storefront_id,shortcodescript,ORDERS,
	showcase,storefront_categories.storefrontcategory_id
	FROM storefronts,relate_storefront_ind,storefront_categories
	WHERE storefronts.storefront_id=relate_storefront_ind.storefront_id
	AND storefront_categories.storefrontcategory_id=relate_storefront_ind.storefrontcategory_id
	AND ch_id=345
	AND featured=1
	and relate_storefront_ind.storefrontcategory_id=1464
	order by ORDERS         
	
getfeaturedstorefronts (Datasource=vault, Time=0ms, Records=1) in E:\Inetpub\wwwroot\tvspy\directories\_directoryinclude.cfm @ 10:05:00.000
	SELECT distinct categorytitle,company,storefronts.storefront_id,shortcodescript,ORDERS,
	showcase,storefront_categories.storefrontcategory_id
	FROM storefronts,relate_storefront_ind,storefront_categories
	WHERE storefronts.storefront_id=relate_storefront_ind.storefront_id
	AND storefront_categories.storefrontcategory_id=relate_storefront_ind.storefrontcategory_id
	AND ch_id=345
	AND featured=1
	and relate_storefront_ind.storefrontcategory_id=1507
	order by ORDERS         
	
getfeaturedstorefronts (Datasource=vault, Time=0ms, Records=3) in E:\Inetpub\wwwroot\tvspy\directories\_directoryinclude.cfm @ 10:05:00.000
	SELECT distinct categorytitle,company,storefronts.storefront_id,shortcodescript,ORDERS,
	showcase,storefront_categories.storefrontcategory_id
	FROM storefronts,relate_storefront_ind,storefront_categories
	WHERE storefronts.storefront_id=relate_storefront_ind.storefront_id
	AND storefront_categories.storefrontcategory_id=relate_storefront_ind.storefrontcategory_id
	AND ch_id=345
	AND featured=1
	and relate_storefront_ind.storefrontcategory_id=1470
	order by ORDERS         
	
getfeaturedstorefronts (Datasource=vault, Time=0ms, Records=3) in E:\Inetpub\wwwroot\tvspy\directories\_directoryinclude.cfm @ 10:05:00.000
	SELECT distinct categorytitle,company,storefronts.storefront_id,shortcodescript,ORDERS,
	showcase,storefront_categories.storefrontcategory_id
	FROM storefronts,relate_storefront_ind,storefront_categories
	WHERE storefronts.storefront_id=relate_storefront_ind.storefront_id
	AND storefront_categories.storefrontcategory_id=relate_storefront_ind.storefrontcategory_id
	AND ch_id=345
	AND featured=1
	and relate_storefront_ind.storefrontcategory_id=1467
	order by ORDERS         
	
getfeaturedstorefronts (Datasource=vault, Time=0ms, Records=3) in E:\Inetpub\wwwroot\tvspy\directories\_directoryinclude.cfm @ 10:05:00.000
	SELECT distinct categorytitle,company,storefronts.storefront_id,shortcodescript,ORDERS,
	showcase,storefront_categories.storefrontcategory_id
	FROM storefronts,relate_storefront_ind,storefront_categories
	WHERE storefronts.storefront_id=relate_storefront_ind.storefront_id
	AND storefront_categories.storefrontcategory_id=relate_storefront_ind.storefrontcategory_id
	AND ch_id=345
	AND featured=1
	and relate_storefront_ind.storefrontcategory_id=1471
	order by ORDERS         
	
getfeaturedstorefronts (Datasource=vault, Time=31ms, Records=3) in E:\Inetpub\wwwroot\tvspy\directories\_directoryinclude.cfm @ 10:05:00.000
	SELECT distinct categorytitle,company,storefronts.storefront_id,shortcodescript,ORDERS,
	showcase,storefront_categories.storefrontcategory_id
	FROM storefronts,relate_storefront_ind,storefront_categories
	WHERE storefronts.storefront_id=relate_storefront_ind.storefront_id
	AND storefront_categories.storefrontcategory_id=relate_storefront_ind.storefrontcategory_id
	AND ch_id=345
	AND featured=1
	and relate_storefront_ind.storefrontcategory_id=1404
	order by ORDERS         
	


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=E:\Inetpub\wwwroot\tvspy\admin.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-us,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=NSC_uwtqz.dpn=ffffffffd2d89a0f45525d5f4f58455e445a4a423660
HTTP_HOST=www.tvspy.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO=/admin.cfm
PATH_TRANSLATED=E:\Inetpub\wwwroot\tvspy\admin.cfm
QUERY_STRING=type=4
REMOTE_ADDR=209.208.132.227
REMOTE_HOST=209.208.132.227
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/admin.cfm
SERVER_NAME=www.tvspy.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=
Client Variables:
cfid=62127068
cftoken=98697133
hitcount=1
lastvisit={ts '2010-02-09 10:05:00'}
timecreated={ts '2010-02-09 10:05:00'}
urltoken=CFID=62127068&CFTOKEN=98697133
Cookie Variables:
CFID=62127068
CFTOKEN=98697133
NSC_uwtqz.dpn=ffffffffd2d89a0f45525d5f4f58455e445a4a423660
Session Variables:
cfid=62127068
cftoken=98697133
sessionid=TVSPYNEW_62127068_98697133
urltoken=CFID=62127068&CFTOKEN=98697133
URL Parameters:
TYPE=4
Debug Rendering Time: 63 ms