Skip to main content
Inspiring
Aug 21, 2006 12:05 PM UTC
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.
    This topic is closed to new replies. Start a new post to keep the conversation going.
    Correct answer
    Aug 21, 2006 12:30 PM UTC
    You can not nest CFOUTPUTs. Get rid of the starting <cfoutput> and the two ending </cfoutputs> withing the <cfoutput query="rsNews2">.

    1 reply

    Correct answer
    Aug 21, 2006 12:30 PM UTC
    You can not nest CFOUTPUTs. Get rid of the starting <cfoutput> and the two ending </cfoutputs> withing the <cfoutput query="rsNews2">.
    Translate