My site is made up of JScript ASP pages with the database running on MSSQL 2005. The rest of my site is working just fine, but I'm having trouble on one page and I'm out of ideas as to what is going on.
An example of the page in question is at: http://www.collegehouses.upenn.edu/brochure/indepth/houseinfo.asp?id=4
There are nine different recordsets on this page, and all of them are working fine except for the one called cbogs.indepth.
The table structure for cbogs.indepth is:
id [int, primary key]
text [text]
videourl [varchar(500)]
proflickr [varchar(500)]
studentflickr [varchar(500)]
residents [int]
freshmen [int]
Videourl, proflickr and studentflickr all contain well-formed URLs, as verified by looking at the table in MS SQL Server Management Studio.
The recordset pulls all the columns from cbogs.indepth, using the id passed to it in the URL to determine which record to pull. So far so good.
When I try to use the data from that recordset, though, only some of the data works. text, residents and freshmen all work just fine and appear on the page where they're supposed to -- the population data, for instance, is pulled from cbogs.indepth.residents and cbogs.indepth.freshmen, and the paragraph at the beginning is cbogs.indepth.text.
videourl, proflickr and studentflickr, though, don't link -- the source code of the relevant spot on the rendered page looks like this:
<p><a href="">House Photos</a> (Flickr)<br /></p>
<p><a href="">Student Room Photos</a> (Flickr)</p>
<h3>Videos</h3>
<p><a href="">College House Videos</a></p>
<h3>House Website</h3>
<p><a href="http://harrison.house.upenn.edu">http://harrison.house.upenn.edu</a></p>
The first three links should have the URLs from their respective columns, but are coming up blank. The fourth URL is being pulled from one of the other recordsets (from a column that is also a varchar) and displays correctly. The source code for all four links looks identical:
<p><a href="<%=(rs_getIndepth.Fields.Item("proflickr").Value)%>">House Photos</a> (Flickr)<br /></p>
<p><a href="<%=(rs_getIndepth.Fields.Item("studentflickr").Value)%>">Student Room Photos</a> (Flickr)</p>
<h3>Videos</h3>
<p><a href="<%=(rs_getIndepth.Fields.Item("videourl").Value)%>">College House Videos</a></p>
<h3>House Website</h3>
<p><a href="<%=(rs_getHouseInfo.Fields.Item("url").Value)%>"><%=(rs_getHouseInfo.Fields.Item("url").Value)%></a></p>
When I examine the recordset in Dreamweaver and test it, the URLs appear as I would expect them to -- so it should be pulling the data in. Why is it not rendering on the page? (Incidentally, when I test the recordset, cbogs.indepth.text shows up as "undefined" but it still renders correctly on the page. I don't know what's up with that either but since it's working otherwise I'm not too worried about it.)
Any ideas? I'm baffled.
1
Reply
AdChoices