RE: Strange issue

[Neal Bailey]

Uhh… you may want to keep looking down on the page…   - Neal     -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Joe Kelly Sent: Thursday, October 16, 2003 10:19 AM To: [EMAIL PROTECTED] Subject: Re: Strange <cfoutput query=""> issue   It would be helpful to show us some of your code, like the query and your cfoutput statement.  Joe Kelly ----- Original Message ----- From: Neal Bailey To: [EMAIL PROTECTED] Sent: Thursday, October 16, 2003 10:58 AM Subject: Strange <cfoutput query=""> issue   Hello folks…   I have strange issue that I am trying to figure out and was hoping someone may know where I might be missing something. I am running the queries below to pull some template settings for me out of a sql database table and one of the fields I use returns a simple single digit number that I use to specify the directory that the main image files will come from.   When I run the page it runs fine with no errors but for some reason the number that I pull gets appended to itself for every item that is displayed. Let’s see if I can explain this better.   If I have 10 items that are returned from my <cfoutput query="rsFinancialBenefitList">   What I get is ….   http://mysite.com/D2//layout.cfm?page=Shelton&pg=5&item=1 http://mysite.com/D22//layout.cfm?page=Shelton&pg=5&item=2 http://mysite.com/D222//layout.cfm?page=Shelton&pg=5&item=3 http://mysite.com/D2222//layout.cfm?page=Shelton&pg=5&item=4 http://mysite.com/D22222//layout.cfm?page=Shelton&pg=5&item=5 http://mysite.com/D222222//layout.cfm?page=Shelton&pg=5&item=6 http://mysite.com/D2222222//layout.cfm?page=Shelton&pg=5&item=7 http://mysite.com/D22222222//layout.cfm?page=Shelton&pg=5&item=8 http://mysite.com/D222222222//layout.cfm?page=Shelton&pg=5&item=9 http://mysite.com/D2222222222//layout.cfm?page=Shelton&pg=5&item=10   …and so on.   Any ideas on why it’s doing this?  …it seems to works with other sections of my site just fine.   --------------here are my Querys---------------- <cfquery name="GetTemplateData" datasource="agenttemplate"> SELECT * FROM dbo.Templates WHERE EntityID = '#LookUpPin.ENTITYID#' </cfquery>   <cfquery name="rsFinancialBenefitList" datasource="SASBenefits"> SELECT * FROM dbo.Benefits WHERE ((dbo.Benefits.BenefitCategory = 'F') AND (dbo.Benefits.Active = 1)) ORDER BY dbo.Benefits.Name ASC </cfquery>   --------- “Template” variable returns a number a value of 2-------- ---------------Page--------------- <cfoutput query="rsFinancialBenefitList"> <table width="100%"  border="0" cellspacing="0" cellpadding="2"> <tr> <td><strong class="12ptTextBlack"><a href="" color="##003366">#rsFinancialBenefitList.Name#</font></a></strong><br> <span class="12ptTextBlack">#rsFinancialBenefitList.Teaser#</span></td> </tr> <tr> <td height="1"><img src="" width="1" height="2"></td> </tr> </table> </cfoutput> --------------Page End-------------   Thanks,   Neal