Can you tell us your environment just for an FYI? OS, CF and SQL Versions?
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Neal Bailey Sent: Thursday, October 16, 2003 1:09 PM To: [EMAIL PROTECTED] Subject: RE: Strange <cfoutput query=""> issue Hey guys thanks a lot for the help... I found the problem, turns out it was not my code at all it was a server issue. All I did was restart the server and it started to work fine after that. I think that one of my queries or stored procedures got stuck in an alternate reality or something. Oh well, hopefully it's not something that will continue to happen. Thanks, - Neal -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of S.Isaac Dealey Sent: Thursday, October 16, 2003 10:48 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. He did -- it was down at the bottom... Doesn't seem to be anything unusual about the query or the output to me... Run the same query in Query Analyzer and see if you get the same results. You should be able to copy/paste it from the cf server debugging output. If you get different results from Query Analyzer than from cf server, then it will be a driver issue. I'm not "low-level" enough to offer a whole lot of help in fixing driver issues, but that's the direction I'd look. If you get the same result from Query Analyzer then I'm baffled. :) > 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&ite > m=3 > http://mysite.com/D2222//layout.cfm?page=Shelton&pg=5&it > em=4 > http://mysite.com/D22222//layout.cfm?page=Shelton&pg=5&i > tem=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&p > g=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="../D#GetTempl > ateData.Template#/layout.cfm?page=#trim(GetTemplateData. > TMP_Page)#&pg=12&benefit=#rsFinancialBenefitList.Benefit > Code#&ben=5"><font color="##003366">#rsFinancialBenefitL > ist.Name#</font></a></strong><br> > <span class="12ptTextBlack">#rsFinancialBenefitList.Teas > er#</span></td> > </tr> > <tr> > <td height="1"><img src="../images/spacer.gif" width="1" > height="2"></td> > </tr> > </table> > </cfoutput> > --------------Page End------------- > Thanks, > Neal s. isaac dealey 972-490-6624 team macromedia volunteer http://www.macromedia.com/go/team chief architect, tapestry cms http://products.turnkey.to onTap is open source http://www.turnkey.to/ontap ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
