HOME NEWSROOM TRAINING CAMP TEAM GAME DAY TICKETS EDWARD JONES DOME COMMUNITY CHEERLEADERS RAMS LIFE PRO SHOP REGISTRATION				login     |     shop     |     stats     |     schedule     |     depth chart
				T Grant Williams (76) celebrated with New England teammates. RAMS TRADE DRAFT CHOICE FOR NEW ENGLAND TACKLE The St. Louis Rams announced today a trade in which they have acquired Grant Williams, a versatile, veteran offensive tackle from the New England Patriots. The Patriots received an undisclosed draft choice. 8/19/02 - COACHING CAN BE A TOUGH BUSINESS 8/19/02 - Q AND A WITH RAMS QB KURT WARNER 8/19/02 - MARTZ ON THE MIKE: AUGUST 19 8/19/02 - RAMS TRADE DRAFT CHOICE FOR NEW ENGLAND TACKLE 8/17/02 - BULGER CONTINUES TO IMPROVE IN PRESEASON 8/17/02 - MARTZ ON THE MIKE: AUGUST 17 8/16/02 - RAMS 0-2 ON PRESEASON AFTER 19-17 LOSS TO CHICAGO BEARS RAMS RENEW PRESEASON RIVALRY WITH SAN DIEGO THIS WEEK The NFC Champion St. Louis Rams face the San Diego Chargers on Thursday, August 22, in a renewing of long preseason rivalry between the teams. SAN DIEGO CHARGERS SCOUTING REPORT The San Diego Chargers edged out a slim 13-10 overtime victory over the St. Louis Rams during the 2001 NFL preseason. However, the promise of a great season for the Chargers quickly turned from a 3-0 start in the regular season to finishing with a nine-game losing streak. RAMS ACCEPTING NOMINATIONS FOR COMMUNITY QB AWARD The September 1 deadline for accepting nominations for the Rams Community Quarterback Award is fast approaching. The award recognizes outstanding volunteers in the area and will award $25,000 to local agencies. JAZZERCISE RAMS JAM PREPARES FOR HALFTIME SHOW More than 200 Jazzercisers took part in a final practice on Thursday night at the Dome as they prepare to be the halftime entertainment as the St. Louis Rams take on the Chicago Bears.				Who will start the regular season at right tackle? 79% - Grant Williams 14% - John St. Clair 7% - Cameron Spikes 913 Total Votes -- WHAT'S YOUR RAMS IQ? -- GET RAMS TRAINING CAMP GEAR HERE -- SIGN UP FOR RAMS MAIL -- RAMS vs. CHARGERS THUR @ 8PM CST
Contact Us | Privacy Policy | Code of Conduct| FAQ | site by Network Applications
Copyright © 2002 St. Louis Rams - All rights reserved.

qry_Select_FolderAccess (Records=1, Time=15ms)
SQL = 
select
					f.ID,
					f.Name,
					f.Display_Order,
					f.Path,
					f.displayOptions,
					f.menuOptions,
					o.Name as Object,
					c.Name as Class,
					c.Source,
					gfpx.privilegeID
		from
					tbl_DIOS_Class c,
					tbl_DIOS_Object o,
					tbl_DIOS_Folder f,
					tbl_Security_GroupFolderPrivilegeXref gfpx,
					tbl_Security_UserGroupXref ugx
		where
					c.id = o.classID and
					o.id = f.objectID and
					f.id = gfpx.folderID and
					f.Folder_List = '' and
					gfpx.GroupID = ugx.GroupID and
					ugx.UserID = 0

LogSession (Records=0, Time=0ms)
SQL = 
Insert into tbl_DIOS_Visit
	(SessionID, FolderID, ContentID)
	values
	(319856, 1, -1)

Select_DisplayObjects_1 (Records=63, Time=Cached Query)
SQL = 
select
				cfx.objectID,
				cfx.displayTypeID
		from 	tbl_Display_ObjectFolderXref cfx 
		where	folderID = 1 or folderID = 0
		order by displayTypeID

Select_AdPromo_1_5 (Records=2, Time=Cached Query)
SQL = 
select
						a.ID,
						a.objectID,
						a.link,
						a.caption,
						a.rank,
						a.type,
						m.filename as ImageName,
						m.width,
						m.height
			from
						tbl_AdPromo_Ad a,
						tbl_Media_MultiMedia m
			where
						m.objectID = a.imageID and
						a.live = 1 and
						a.objectid in (23466,23466,23533)
			order by
						a.rank

qry_Select_Nav_Top_Level (Records=12, Time=16ms)
SQL = 
select		f.ID as folderID,
				f.Name,
				f.Path,
				f.Display_Order,
				f.Folder_List,
				f.objectID,
				f.linkURL,
				f.popupWidth,
				f.popupHeight,
				f.popupSettings,
				f.linkOptions,
				max(gfpx.privilegeID) as [Access]

	from		tbl_DIOS_Folder f,
				tbl_Security_GroupFolderPrivilegeXref gfpx,
				tbl_Security_UserGroupXref ugx

	where		f.Path in ('.1.') and
				f.Path >= '.1.' and
				f.menuOptions = 1 and
				gfpx.FolderID = f.ID and
				ugx.groupID = gfpx.groupID and
				ugx.UserID = 0 and
				gfpx.privilegeID <=4

	group by	f.ID,
				f.Name,
				f.Path,
				f.Display_Order,
				f.Folder_List,
				f.objectID,
				f.linkURL,
				f.linkOptions,
				f.popupWidth,
				f.popupHeight,
				f.popupSettings

	order by	f.Display_Order

Select_AdPromo_1_6 (Records=4, Time=Cached Query)
SQL = 
select
						a.ID,
						a.objectID,
						a.link,
						a.caption,
						a.rank,
						a.type,
						m.filename as ImageName,
						m.width,
						m.height
			from
						tbl_AdPromo_Ad a,
						tbl_Media_MultiMedia m
			where
						m.objectID = a.imageID and
						a.live = 1 and
						a.objectid in (53,55,58,24061,24061)
			order by
						a.rank

Doc_SelectDocuments_1_header (Records=1, Time=Cached Query)
SQL = 
select	d.Content,
					d.objectID as ID,
					d.title as docTitle,
					m.FileName as Image,
					mm.FileName as Media,
					mm.Description as MediaDescription
			from	tbl_Doc_Document d
					left join tbl_Media_MultiMedia m
						on	d.ImageID = m.objectID
					left join tbl_Media_MultiMedia mm
						on	d.MediaID = mm.objectID
			where	folderid = 1 and
					name = 'header' and
					date_End > getdate()

ArticleListQry_1_4 (Records=1, Time=Cached Query)
SQL = 
Select top 1
			a.id as articleid,
			a.title,
			a.releasedate_Start,
			a.shortdescription,
			a.objectId,
			m.filename,
			m.height,
			m.width,
			m.description,
			at.LayoutType
			
		from
			tbl_Article_Article a left join tbl_Media_MultiMedia m
				on a.LargeImageID = m.objectID
			left join tbl_Article_ArticleLayout at
				on a.layoutTypeId = at.id
		where
			a.objectid in (24187) and
			a.date_end is null
		order by
			a.ReleaseDate_Start desc

ArticleListQry_1_1 (Records=7, Time=Cached Query)
SQL = 
Select top 2000000
			a.id as articleid,
			a.title,
			a.releasedate_Start,
			a.shortdescription,
			a.objectId,
			m.filename,
			m.height,
			m.width,
			m.description,
			at.LayoutType
			
		from
			tbl_Article_Article a left join tbl_Media_MultiMedia m
				on a.LargeImageID = m.objectID
			left join tbl_Article_ArticleLayout at
				on a.layoutTypeId = at.id
		where
			a.objectid in (24142,24142,24144,24144,24149,24154,24183,24185,24187) and
			a.date_end is null
		order by
			a.ReleaseDate_Start desc

ArticleListQry_1_2 (Records=4, Time=Cached Query)
SQL = 
Select top 4
			a.id as articleid,
			a.title,
			a.releasedate_Start,
			a.shortdescription,
			a.objectId,
			m.filename,
			m.height,
			m.width,
			m.description,
			at.LayoutType
			
		from
			tbl_Article_Article a left join tbl_Media_MultiMedia m
				on a.SmallImageID = m.objectID
			left join tbl_Article_ArticleLayout at
				on a.layoutTypeId = at.id
		where
			a.objectid in (3310,21161,21227,21446,21543,21576,21650,21832,22083,22146,22181,22184,22286,22481,22591,22785,22896,23032,23207,23329,23332,23673,23681,23845,24157,24159,24203) and
			a.date_end is null
		order by
			a.ReleaseDate_Start desc

Doc_SelectDocuments_1_Article (Records=0, Time=Cached Query)
SQL = 
select	d.Content,
					d.objectID as ID,
					d.title as docTitle,
					m.FileName as Image,
					mm.FileName as Media,
					mm.Description as MediaDescription
			from	tbl_Doc_Document d
					left join tbl_Media_MultiMedia m
						on	d.ImageID = m.objectID
					left join tbl_Media_MultiMedia mm
						on	d.MediaID = mm.objectID
			where	folderid = 1 and
					name = 'Article' and
					date_End > getdate()

Select_AdPromo_1_7 (Records=4, Time=Cached Query)
SQL = 
select
						a.ID,
						a.objectID,
						a.link,
						a.caption,
						a.rank,
						a.type,
						m.filename as ImageName,
						m.width,
						m.height
			from
						tbl_AdPromo_Ad a,
						tbl_Media_MultiMedia m
			where
						m.objectID = a.imageID and
						a.live = 1 and
						a.objectid in (23541,23847,23851,24059)
			order by
						a.rank

Select_AdPromo_1_19 (Records=4, Time=Cached Query)
SQL = 
select
						a.ID,
						a.objectID,
						a.link,
						a.caption,
						a.rank,
						a.type,
						m.filename as ImageName,
						m.width,
						m.height
			from
						tbl_AdPromo_Ad a,
						tbl_Media_MultiMedia m
			where
						m.objectID = a.imageID and
						a.live = 1 and
						a.objectid in (7097,23319,23343,23661)
			order by
						a.rank

GetPollInfo (Records=1, Time=0ms)
SQL = 
Select
			p.objectID as PollID,
			p.Question
		from
			tbl_poll_Question p
		where
			p.objectid in (24192) and
			date_Start < getdate() and
			date_End > getdate()

GetPoll_Info (Records=3, Time=0ms)
SQL = 
Select
					q.Question,
					a.Answer,
					a.id,
					a.votes
				From
					tbl_Poll_Question q,
					tbl_Poll_Answer a
				Where
					q.objectID = a.pollobjectID and
					q.objectID = 24192
				order by a.votes desc

GetPollInfo (Records=0, Time=0ms)
SQL = 
Select
			p.objectID as PollID,
			p.Question
		from
			tbl_poll_Question p
		where
			p.objectid in (175323,175323,175324,175325) and
			date_Start < getdate() and
			date_End > getdate()

Doc_SelectDocuments_1_Links (Records=1, Time=Cached Query)
SQL = 
select	d.Content,
					d.objectID as ID,
					d.title as docTitle,
					m.FileName as Image,
					mm.FileName as Media,
					mm.Description as MediaDescription
			from	tbl_Doc_Document d
					left join tbl_Media_MultiMedia m
						on	d.ImageID = m.objectID
					left join tbl_Media_MultiMedia mm
						on	d.MediaID = mm.objectID
			where	folderid = 1 and
					name = 'Links' and
					date_End > getdate()

Doc_SelectDocuments_1_bottomLinks (Records=1, Time=Cached Query)
SQL = 
select	d.Content,
					d.objectID as ID,
					d.title as docTitle,
					m.FileName as Image,
					mm.FileName as Media,
					mm.Description as MediaDescription
			from	tbl_Doc_Document d
					left join tbl_Media_MultiMedia m
						on	d.ImageID = m.objectID
					left join tbl_Media_MultiMedia mm
						on	d.MediaID = mm.objectID
			where	folderid = 1 and
					name = 'bottomLinks' and
					date_End > getdate()

Doc_SelectDocuments_1_footer (Records=1, Time=Cached Query)
SQL = 
select	d.Content,
					d.objectID as ID,
					d.title as docTitle,
					m.FileName as Image,
					mm.FileName as Media,
					mm.Description as MediaDescription
			from	tbl_Doc_Document d
					left join tbl_Media_MultiMedia m
						on	d.ImageID = m.objectID
					left join tbl_Media_MultiMedia mm
						on	d.MediaID = mm.objectID
			where	folderid = 1 and
					name = 'footer' and
					date_End > getdate()

Select_AdPromo_1_20 (Records=1, Time=Cached Query)
SQL = 
select
						a.ID,
						a.objectID,
						a.link,
						a.caption,
						a.rank,
						a.type,
						m.filename as ImageName,
						m.width,
						m.height
			from
						tbl_AdPromo_Ad a,
						tbl_Media_MultiMedia m
			where
						m.objectID = a.imageID and
						a.live = 1 and
						a.objectid in (23546,24075)
			order by
						a.rank

422 milliseconds

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=D:\www\IO_Rams\web\index.io
CONTENT_LENGTH=0
CONTENT_TYPE=
GATEWAY_INTERFACE=CGI/1.1
HTTP_ACCEPT=image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-powerpoint, application/vnd.ms-excel, application/msword, */*
HTTP_ACCEPT_ENCODING=gzip, deflate
HTTP_ACCEPT_LANGUAGE=en-us
HTTP_CACHE_CONTROL=no-cache
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=IO_RAMS.PA24062=1; IO_RAMS.PA24192=1; IO_RAMS.SESSION.AUTH=0; IO_RAMS.SESSION.ID=319856
HTTP_HOST=www.stlouisrams.com
HTTP_REFERER=http://www.stlouisrams.com/
HTTP_USER_AGENT=Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
PATH_INFO=/index.io
PATH_TRANSLATED=D:\www\IO_Rams\web\index.io
QUERY_STRING=
REMOTE_ADDR=216.55.142.232
REMOTE_HOST=216.55.142.232
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.io
SERVER_NAME=www.stlouisrams.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/5.0
WEB_SERVER_API=ISAPI