Is there nothing in the logs? I'd check all of them, IIS, CF, Application, etc., and see if anything pops out. Maybe IIS is limiting the number of connections or something... dunno off hand... :D
On 4/26/06, Kay Smoljak <[EMAIL PROTECTED]> wrote: > > Hi guys, > > I'm still fighting with the Report Builder (see my progress to date at > > http://kay.smoljak.com/archives/?coldfusion-report-builder-sanity-saving-tips/ > ), > but this new issue seems to have something to do with the IIS vs the > built-in web server, so I'm hoping someone might some ideas of things > to try. > > Situation is this: three of my reports, which need to go into an > overview reports as subreports, have complex calculations that are > wrapped up in CFC calls each. These reports work flawlessly when > called standalone (with the query created externally and passed in as > a cfreport tag parameter). > > However, as subreports need the query to be created inside the report, > I have moved the CFC calls into the advanced query section of the > report itself (with the required CFC parameters eg dsn hardcoded for > now). If I call the report standalone, it works correctly (on all > servers). On my local machine with CF's built-in web server, when > called as a subreport, it also works correctly. However, on the > staging server - Windows 2003 with IIS, a mirror of the production > server - as a subreport it doesn't work at all - I get a blank page. > I've set "when no query, show headers but no data" (or whatever that > option is called, don't have it in front of me right now) but still > nothing. I tried moving all files into the root directory - the cfcs > in a directory under the root called cfc, so I'm referencing > cfc.compname and like I said, it works when called standalone on all > machines - but no change. > > Any ideas of what to try? An alternate way of referencing the CFCs? > Another way of getting that code into the report without completely > rewriting it? > > Thanks for any troubleshooting tips :) > > -- > Kay Smoljak > http://kay.zombiecoder.com/ > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238996 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
