Answered
URL Variables repeating
i have a news table (tbNews) with a date field. currently i have a query that pulls in records depending on the news story date. so a user can view all news stories in a particular month. this works fine. however when the user clicks on a story i pass 3 url variables, month, year and newsStoriesID.
when multiple stories appear on the results page, for some reason the month and year variables are being repeated in the url.
for example a user clicks "july" and then selects "test" from the list of stories. the correct link should be ".../news.cfm?month=07&year=2006". but instread its ".../news.cfm?month=070707&year=200620062006"
the page is live on
http://www.pixelwork.com/2006/news3Kev2.cfm?month=01&year=2006
my code on the page is : (rsNews2 is the recordset the dates are being from)
"<cfoutput query="rsNews2">
<td class="NewsTitle"><a href="news3Kev2.cfm?month=<cfoutput>#DatePart("m", rsNews2.date)#</cfoutput>&ID=#rsNews2.ID#&year=#DatePart("yyyy", rsNews2)#</cfoutput>"">#rsNews2.Title#</a></td>
<td class="NewsDate">#DateFormat(rsNews2.Date,'DD-MMM-YY')#</td>
</tr></cfoutput>"
i have created a query which reads in the month and year of all news records.
