Sure no problem...
OS - Windows XP Pro - updated
Coldfusion MX 6.1
Microsoft SQL with all service patches and fixes
IIS 5
- All of this is on my Laptop
Hardware:
Compaq Presario 2100 Laptop
1Gig ram
Wireless network 802.11g
Yeah I know all this should not be running on a laptop... but due to my traveling I have to have it to demonstrate and show progress.
- Neal
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Jacob Cameron
Sent: Thursday, October 16, 2003 12:36 PM
To: [EMAIL PROTECTED]
Subject: RE: Strange <cfoutput query=""> issue
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="">
> 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="" 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:
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To unsubscribe:
Send UNSUBSCRIBE to [EMAIL PROTECTED] To subscribe / unsubscribe:
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To unsubscribe:
Send UNSUBSCRIBE to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
