TVSpy MemberShip Sign Up

: : TVSpy Home

: : Log In

: : Member Home

: : Forget Password?

: : Change E-mail

: : FAQ & Contact Info

: : ShopTalk Subscription

FREE MEMBERSHIP

GOLD MEMBERSHIP

CORPORATE GOLD MEMBERSHIP

POST JOBS

ADVERTISE

E-mail*

Would you like to receive TVSpy announcement mailings?*
Yes No

Would you like to receive selected offers from our sponsors?*
Yes No

Would you like to subscribe to ShopTalk, TVSpy's daily newsletter?*
Yes No

Would you like to subscribe to TVSpy's job alert?*
Yes No

Confirm E-mail*

Username*

Password*

Confirm Password*

Zip Code*

Country*

Current/
Most recent market*

Are you an employer or hiring manager that would like to post jobs on TVSpy's Job Bank? *

Yes No

Job functions*
(To select multiple, hold down the Ctrl key and click on your selections. Mac users, use the Apple key.)

AUDIO

615 Music

COACHES AND CONSULTANTS

Stevens Media Consulting, Ltd.

More Coaches and Consultants Listings

• Poynter Institute

• Media Recruiter.com

DEMO REEL SERVICES

TVVideoResumes.com

HARDWARE

Devlin Design Group

More Hardware Listings

• Calrec Audio Ltd.

• EVS

JOURNALISM SCHOOLS

Medill School of Journalism at Northwestern University

More Journalism Schools Listings

• USC- Annenberg School of Communication

• Columbia Graduate School of Journalism

ORGANIZATIONS AND UNIONS

National Press Foundation

More Organizations and Unions Listings

• RTNDA

• National Press Photographers Association

TALENT AGENTS

N.S. Bienstock, Inc.

More Talent Agents Listings

• Napoli Management

• Ken Lindner & Associates

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

Debugging Information

ColdFusion Server Enterprise	7,0,0,91690
Template	/membership/signup.cfm
Time Stamp	11-Mar-10 03:27 PM
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
2699 ms	2699 ms	1	E:\Inetpub\wwwroot\tvspy\membership\signup.cfm
2684 ms	2684 ms	1	E:\Inetpub\wwwroot\tvspy\_far-right.cfm
2684 ms	2684 ms	1	E:\Inetpub\wwwroot\tvspy\directories\_directoryinclude.cfm
15 ms	15 ms	1	E:\Inetpub\wwwroot\tvspy\_top.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\ads\_adinclude-tiles.cfm
0 ms	0 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\membership\Application.cfm
0 ms	0 ms	1	E:\Inetpub\wwwroot\tvspy\membership\lists\dma.txt
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
2699 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

SQL Queries

country_list (Datasource=vault, Time=0ms, Records=222, Cached Query) in E:\Inetpub\wwwroot\tvspy\membership\signup.cfm @ 15:27:08.008

select location_id, longname from location where lc_type=40 order by longname

functionjoblist (Datasource=vault, Time=0ms, Records=20, Cached Query) in E:\Inetpub\wwwroot\tvspy\membership\signup.cfm @ 15:27:08.008

	select function_id,function_name
	from T_functions
	order by function_name

getcategories (Datasource=vault, Time=0ms, Records=7) in E:\Inetpub\wwwroot\tvspy\directories\_directoryinclude.cfm @ 15:27:09.009

					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 @ 15:27:09.009

	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=0ms, Records=3) in E:\Inetpub\wwwroot\tvspy\directories\_directoryinclude.cfm @ 15:27:09.009

	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 @ 15:27:09.009

	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 @ 15:27:09.009

	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=16ms, Records=3) in E:\Inetpub\wwwroot\tvspy\directories\_directoryinclude.cfm @ 15:27:09.009

	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 @ 15:27:09.009

	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=2652ms, Records=3) in E:\Inetpub\wwwroot\tvspy\directories\_directoryinclude.cfm @ 15:27:11.011

	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\membership\signup.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=tvspy.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO=/membership/signup.cfm
PATH_TRANSLATED=E:\Inetpub\wwwroot\tvspy\membership\signup.cfm
QUERY_STRING=
REMOTE_ADDR=209.208.132.227
REMOTE_HOST=209.208.132.227
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/membership/signup.cfm
SERVER_NAME=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=62498678
cftoken=11162487
hitcount=1
lastvisit={ts '2010-03-11 15:27:08'}
timecreated={ts '2010-03-11 15:27:08'}
urltoken=CFID=62498678&CFTOKEN=11162487

Cookie Variables:
CFID=62498678
CFTOKEN=11162487
NSC_uwtqz.dpn=ffffffffd2d89a0f45525d5f4f58455e445a4a423660

Session Variables:
cfid=62498678
cftoken=11162487
goldstatus=0
sessionid=TVSPYNEW_62498678_11162487
urltoken=CFID=62498678&CFTOKEN=11162487

Debug Rendering Time: 46 ms

Anchors/Reporters
Broadband
Cable/Satellite
Editor
Entry-Level/Student
Executive Producers & Managing Editors
Graphics
HR/Admin
ITV
Managers/Executive
New Media/Multimedia
Other
Photographers
Producers & Assignment Editors
Programming
Promotion/Publicity
Radio - On Air
Radio - Production
Sales
Technical