RE: Can we use cfthread to speed up multi-query report processes?
Have been trying to reply via HoF but it won't go through so I'm trying this. - Obviously, the feasibility of either option is dependent on the process and use cases themselves. Of course. We realize that. These are on demand processes. We continuously monitor, tweak, and tune database performance. We're looking for additional improvement elsewhere as well. Thanks Dave and Alan for your input! George ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355828 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can we use cfthread to speed up multi-query report processes?
Have been trying to reply via HoF but it won't go through so I'm trying this. Actually, your previous replies did go through. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355829 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can we use cfthread to speed up multi-query report processes?
- Obviously, the feasibility of either option is dependent on the process and use cases themselves. Of course. We realize that. These are on demand processes. We continuously monitor, tweak, and tune database performance. We're looking for additional improvement elsewhere as well. Thanks Dave and Alan for your input! George ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355825 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can we use cfthread to speed up multi-query report processes?
- Obviously, the feasibility of either option is dependent on the process and use cases themselves. Of course. We realize that. These are on demand processes. We continuously monitor, tweak, and tune database performance. We're looking for additional improvement elsewhere as well. Thanks Dave and Alan for your input! George ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355826 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Can we use cfthread to speed up multi-query report processes?
Hello! We have processes that assemble reports from as many as 6 individual queries. Currently the queries run sequentially so the related report cannot be assembled and displayed until after all queries have completed. Users often have to wait several minutes for their report. They are not happy about that. We are considering trying cfthread to run queries concurrently and then assemble and display the related report after the longest running query completes. Is this a viable use for cfthread or is it meant to be used for unrelated processes? Is anyone using cfthread as described above? Have you seen noticeable improvement in performance? Is the cost in complexity of the code worth the improvement in performance? We're using CF9\10 Enterprise on Unix and Windows. Thanks! George ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355807 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can we use cfthread to speed up multi-query report processes?
We have processes that assemble reports from as many as 6 individual queries. Currently the queries run sequentially so the related report cannot be assembled and displayed until after all queries have completed. Users often have to wait several minutes for their report. They are not happy about that. We are considering trying cfthread to run queries concurrently and then assemble and display the related report after the longest running query completes. Is this a viable use for cfthread or is it meant to be used for unrelated processes? Is anyone using cfthread as described above? Have you seen noticeable improvement in performance? Is the cost in complexity of the code worth the improvement in performance? Yes, that sort of parallel processing is a common use case for CFTHREAD, and it will improve performance for that user's request. Of course, it typically also means you can't process as many user requests simultaneously - it's not magic - but if that's not a problem then you should be all set. Alternatively, you could use a single CFTHREAD that does all the work, and the user could do something else instead of waiting for the report at all - for example, the CFTHREAD could generate an email with a link to the report. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355808 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can we use cfthread to speed up multi-query report processes?
Also, keep in mind - and I'm speculating a bit here on your process - if you have just 6 individual queries that run in a single threaded, linear fashion and they take 6 minutes to execute, running them all concurrently may take just as long as it's sounds like your DB server may be taxed or these are really heavy queries. Again, speculating here - it could be that you might benefit from some other options: 1. Maybe some DB tuning or having a DBA look at the SQL being executed to speed them up. 2. Maybe this isn't meant to be an on-demand process - as Dave rightly suggested, you could either batch them in the back ground - on-demand or you schedule them outright and have them delivered when ready and only run them once a __ - Obviously, the feasibility of either option is dependent on the process and use cases themselves. HTH On Tue, May 21, 2013 at 7:10 AM, Dave Watts dwa...@figleaf.com wrote: We have processes that assemble reports from as many as 6 individual queries. Currently the queries run sequentially so the related report cannot be assembled and displayed until after all queries have completed. Users often have to wait several minutes for their report. They are not happy about that. We are considering trying cfthread to run queries concurrently and then assemble and display the related report after the longest running query completes. Is this a viable use for cfthread or is it meant to be used for unrelated processes? Is anyone using cfthread as described above? Have you seen noticeable improvement in performance? Is the cost in complexity of the code worth the improvement in performance? Yes, that sort of parallel processing is a common use case for CFTHREAD, and it will improve performance for that user's request. Of course, it typically also means you can't process as many user requests simultaneously - it's not magic - but if that's not a problem then you should be all set. Alternatively, you could use a single CFTHREAD that does all the work, and the user could do something else instead of waiting for the report at all - for example, the CFTHREAD could generate an email with a link to the report. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355814 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion Report with multiple queries
Hi Ross That would be the ideal scenario but how can i create a single PDF with multiple queries: the user will enter a list of order numbers and each order number will have a delivery docket but the dockets can be more than one page so my problem is getting them all on one pdf? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353134 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion Report with multiple queries
A pdf can have page breaks, think about all the pdf docs you have read. Regards Russ Michaels On Nov 13, 2012 10:13 AM, Anthony Doherty anthony...@gmail.com wrote: Hi Ross That would be the ideal scenario but how can i create a single PDF with multiple queries: the user will enter a list of order numbers and each order number will have a delivery docket but the dockets can be more than one page so my problem is getting them all on one pdf? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353135 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion Report with multiple queries
Yes Russ thats correct but my issue is running the multiple query and appending the pdfs I have an array of order numbers and I have to loop through each number and to run the report that creates the pdf when the pdf is created append it to the existing one if it exists and if not create it until all the number have been queried. Its the looping and appending that is the cause of my problem - Do you know how i can do this? Cheers ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353137 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion Report with multiple queries
Yes Russ thats correct but my issue is running the multiple query and appending the pdfs I have an array of order numbers and I have to loop through each number and to run the report that creates the pdf when the pdf is created append it to the existing one if it exists and if not create it until all the number have been queried. Its the looping and appending that is the cause of my problem - Do you know how i can do this? This isn't really specific to PDFs. You use CFOUTPUT and/or CFLOOP just like you would if you were going to output HTML. You can use CFDOCUMENTSECTION and CFDOCUMENTITEM to divide the dockets, handle page breaks, etc. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353138 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion Report with multiple queries
Dave, Sorry I dont understand what you mean? I have created a cfr file with the page layout defined to match the delivery docket paper. I can browse directly to the cfr file and query it for one record which displays fine but im not sure how to loop through this for all additional order numbers and add to the one document Thanks Anthony On 13 November 2012 13:50, Dave Watts dwa...@figleaf.com wrote: Yes Russ thats correct but my issue is running the multiple query and appending the pdfs I have an array of order numbers and I have to loop through each number and to run the report that creates the pdf when the pdf is created append it to the existing one if it exists and if not create it until all the number have been queried. Its the looping and appending that is the cause of my problem - Do you know how i can do this? This isn't really specific to PDFs. You use CFOUTPUT and/or CFLOOP just like you would if you were going to output HTML. You can use CFDOCUMENTSECTION and CFDOCUMENTITEM to divide the dockets, handle page breaks, etc. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353139 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion Report with multiple queries
very simply, something like this cfdocument ..your attributes cfloop query=your query the content for your docket cfdocumentitem type = pagebreak/ /cfloop /cfdocument On Tue, Nov 13, 2012 at 3:05 PM, Anthony Doherty anthony...@gmail.comwrote: Dave, Sorry I dont understand what you mean? I have created a cfr file with the page layout defined to match the delivery docket paper. I can browse directly to the cfr file and query it for one record which displays fine but im not sure how to loop through this for all additional order numbers and add to the one document Thanks Anthony On 13 November 2012 13:50, Dave Watts dwa...@figleaf.com wrote: Yes Russ thats correct but my issue is running the multiple query and appending the pdfs I have an array of order numbers and I have to loop through each number and to run the report that creates the pdf when the pdf is created append it to the existing one if it exists and if not create it until all the number have been queried. Its the looping and appending that is the cause of my problem - Do you know how i can do this? This isn't really specific to PDFs. You use CFOUTPUT and/or CFLOOP just like you would if you were going to output HTML. You can use CFDOCUMENTSECTION and CFDOCUMENTITEM to divide the dockets, handle page breaks, etc. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353140 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Coldfusion Report with multiple queries
I am trying to create a delivery report system for a delivery run. The user currently has to run the report for each order number and print out the delivery docket. This system is fine for one or two dockets but when a particular run is required there could be 20/30 dockets. So i was proposing for the user to enter the order numbers store them in an array and then run the report for each order number and print out the docket. The problem im having is running the report and printing the docket for each order number automatically as im not sure how this would work - So any help would be greatly appreciated. Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353128 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion Report with multiple queries
Why not generate a single pdf so they can print all the dockets in one go, or generate a bunch of links to separate dockets for him to print at the end. Regards Russ Michaels On Nov 12, 2012 9:40 AM, Anthony Doherty anthony...@gmail.com wrote: I am trying to create a delivery report system for a delivery run. The user currently has to run the report for each order number and print out the delivery docket. This system is fine for one or two dockets but when a particular run is required there could be 20/30 dockets. So i was proposing for the user to enter the order numbers store them in an array and then run the report for each order number and print out the docket. The problem im having is running the report and printing the docket for each order number automatically as im not sure how this would work - So any help would be greatly appreciated. Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353129 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Load Testing - what to look for and monitor/report
We're doing performance analysis and looking for bottlenecks ... In that case, you want to test a single server only, at least to start. You'll need to define user paths that are most likely to be followed by users within the application, and define timers for each step of the user path (where a step is a single user action that triggers any server-side response). Then, you'll run a typical performance analysis test (no pauses between requests) for a single user, then scale up by some increment (say, 5 users) until the application becomes unresponsive. The data you collect during this process will primarily be response time data (for each timer). You can then drop that data into a spreadsheet and chart the timer steps that increase more than others, and those are your bottlenecks. If those steps are themselves pretty complex, you can add CFTIMER tags within your page to find out which part of the page is the slower part, as well. ... and also memory leaks since we have a lot of application scoped components and large numbers of objects created per request. That's one of my main concerns actually.. Well, that might require a different test, or at least might affect the point at which the application becomes unresponsive as described above. Proper performance analysis testing can really only happen once you've removed functionality and operation bugs from your application, and memory leaks would fall into that category. That said, it's unlikely you'll run into true memory leaks with CF components - you just might run out of memory, though. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349864 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Load Testing - what to look for and monitor/report
Anyhow, what I really want to know from you experts is what should I be watching and recording during these load tests? Generally, you're interested in response time and throughput. Also should I pair down from a load balanced solution to a single server to make it easier to debug log files and track memory etc? And then scale up after a specific duration? Or for the second test interval? I don't have much experience with load testing and just want to make sure that this is money well spend in terms of having some actionable data. It's hard to answer this without more information. What is the goal of the load test? What kind of actionable data are you looking for? You can use load tests to answer a couple of different questions. There are two basic types of load test: performance analysis, and capacity planning. In a performance analysis test, you're looking for bottlenecks in your application with the goal of improving application performance. In a capacity planning test, you're trying to identify how many users your application can support as it's currently written. Which one of these are you doing? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349862 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Load Testing - what to look for and monitor/report
Hi Dave, We're doing performance analysis and looking for bottlenecks and also memory leaks since we have a lot of application scoped components and large numbers of objects created per request. That's one of my main concerns actually.. Brook -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: February-11-12 7:46 AM To: cf-talk Subject: Re: Load Testing - what to look for and monitor/report Anyhow, what I really want to know from you experts is what should I be watching and recording during these load tests? Generally, you're interested in response time and throughput. Also should I pair down from a load balanced solution to a single server to make it easier to debug log files and track memory etc? And then scale up after a specific duration? Or for the second test interval? I don't have much experience with load testing and just want to make sure that this is money well spend in terms of having some actionable data. It's hard to answer this without more information. What is the goal of the load test? What kind of actionable data are you looking for? You can use load tests to answer a couple of different questions. There are two basic types of load test: performance analysis, and capacity planning. In a performance analysis test, you're looking for bottlenecks in your application with the goal of improving application performance. In a capacity planning test, you're trying to identify how many users your application can support as it's currently written. Which one of these are you doing? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349863 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Load Testing - what to look for and monitor/report
Hey Guys, I am hiring a load testing company, Neustar, to run some load tests on a new cf app and server deployment. I have FusionReactor installed and the platform is CF9 Standard on windows 2008 web server, and the backend is a separate MS SQL box. A beefy one at that J. The server environment is virtualized running on vmware on Dell 610s (in case any one cared..).. Anyhow, what I really want to know from you experts is what should I be watching and recording during these load tests? Also should I pair down from a load balanced solution to a single server to make it easier to debug log files and track memory etc? And then scale up after a specific duration? Or for the second test interval? I don't have much experience with load testing and just want to make sure that this is money well spend in terms of having some actionable data. Thank yo! Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349861 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfreport swallowing lines on multiple pages created with report builder
I have a report built with report builder and it appears that if you set the body to stretch with overflow that cfreport will swallow a line or two every time it paginates see attached for a simplified version of the report, I have removed all but the body on this (actual report has a watermark, report header, page header and page footer ...the problem is pretty apparnt with this scaled down version as you can see it's missing text from one page to the next ..any ideas/suggestions/known bug?? You can see a sample of the issue here: http://www.arroyoc.com/onlybody.pdf ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349662 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfreport swallowing lines on multiple pages created with report builder
I have a report built with report builder and it appears that if you set the body to stretch with overflow that cfreport will swallow a line or two every time it paginates see attached for a simplified version of the report, I have removed all but the body on this (actual report has a watermark, report header, page header and page footer ...the problem is pretty apparnt with this scaled down version as you can see it's missing text from one page to the next ..any ideas/suggestions/known bug?? You can see a sample of the issue here: http://www.arroyoc.com/onlybody.pdf ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349663 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Coldfusion report builder problem
I'm doing something that should be simple but is giving me hell. I'm getting this error Invalid ColdFusion expression in report. If the expression is a string, ensure that it is within quotes With this: Error: query.firstname query.lastname Chr(13) Chr(10) query.Address1 IIf(len(query.Address2), query.Address2 Chr(13) Chr(10), DE()) query.city , query.state query.zip is not a valid ColdFusion expression. Yet when I change it to this (or something equally silly for testing): query.firstname query.lastname Chr(13) Chr(10) query.Address1 IIf(len(query.Address2), DE(query.Address2), DE()) query.city , query.state query.zip It does what I'm asking Any ideas thanks in advance (I would use help but that's not working in Windows 7) -Joshua ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345926 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion report builder problem
nm . . . again apparently DE(##query.Address2## Chr(13) Chr(10)) as much as I loathe it. Did the trick Would it be better to put together the CFREport tag by hand? (Though I must admit despite getting hung up on the evaluation it was overall very quick) On Wed, Jun 29, 2011 at 2:16 PM, Joshua O'Connor-Rose joshua.oconnorr...@gmail.com wrote: I'm doing something that should be simple but is giving me hell. I'm getting this error Invalid ColdFusion expression in report. If the expression is a string, ensure that it is within quotes With this: Error: query.firstname query.lastname Chr(13) Chr(10) query.Address1 IIf(len(query.Address2), query.Address2 Chr(13) Chr(10), DE()) query.city , query.state query.zip is not a valid ColdFusion expression. Yet when I change it to this (or something equally silly for testing): query.firstname query.lastname Chr(13) Chr(10) query.Address1 IIf(len(query.Address2), DE(query.Address2), DE()) query.city , query.state query.zip It does what I'm asking Any ideas thanks in advance (I would use help but that's not working in Windows 7) -Joshua ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345936 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Report Builder on CF9 with CSS questions
1. I am unable to get the CSS export link to produce an output file. Has anyone been able to get this function working? 2. Does the CSS style override function actually work? I am trying to override the margins on a text field but this CSS function is not changing anything. 3. The importing of Image files in the report does not work. An image object will not render in the report unless I copy the image and DROP it on the report layout in CF Report builder. The image is therefore embedded in the CFR file. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343442 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Problem with Report Builder - Element bottom
After modifying the query in a label page in CF Report Builder I get this message: Report design not valid : 1. Warning : Element bottom reaches outside band area : y=2 height=72 band-height=72 This label format worked correctly but now all attempts to alter the label report result in this error. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341954 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Report Builder
The users aren't going to be too technically proficient. Just your average group of users. I think Report Builder is going to make their heads explode. I was hoping for something user-friendly that would allow them to customize what data appears in a report and where (allow them to change the layout somewhat). Should I simply be thinking of making my own AJAXy kind of front-end? Thanks, Scott --- On Wed, 11/3/10, Dave Watts dwa...@figleaf.com wrote: It really depends on two things. First, how technically proficient are these users? Do they have experience using banded report generators? Second, do you want to allow them the level of access to the server needed to generate reports with Report Builder? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338832 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Report Builder
Depending on how much you like Report Builder, you can always come up with a main template (header footer, etc) then a series (different data positions) of sub-reports (just the details really) and allow the users to select which 'layout' they want to use, and what data goes where. Then it is just a matter of having the data in the correct spot when calling the CFR. I have worked this into a few sites for 'custom' Reporting. Cheers, Rob On Thu, Nov 4, 2010 at 12:03 PM, Scott Spurlock spurlock.sc...@yahoo.comwrote: The users aren't going to be too technically proficient. Just your average group of users. I think Report Builder is going to make their heads explode. I was hoping for something user-friendly that would allow them to customize what data appears in a report and where (allow them to change the layout somewhat). Should I simply be thinking of making my own AJAXy kind of front-end? Thanks, Scott --- On Wed, 11/3/10, Dave Watts dwa...@figleaf.com wrote: It really depends on two things. First, how technically proficient are these users? Do they have experience using banded report generators? Second, do you want to allow them the level of access to the server needed to generate reports with Report Builder? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338833 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Report Builder
I usually set up views with the data the users are allowed to see, and set either Report Builder or Microsoft Access to use only those views. With the limited subset of data, and the elimination of the need to build lookups most users can figure out how to do reports. On Thu, Nov 4, 2010 at 9:03 AM, Scott Spurlock spurlock.sc...@yahoo.com wrote: The users aren't going to be too technically proficient. Just your average group of users. I think Report Builder is going to make their heads explode. I was hoping for something user-friendly that would allow them to customize what data appears in a report and where (allow them to change the layout somewhat). Should I simply be thinking of making my own AJAXy kind of front-e ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338834 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Report Builder
I want to give the users of my CF 8 site the ability to dynamically generate reports. I've never used Report Builder before. Will non-technical users be able to use this, or will something else be better suited for them? Thanks, Scott ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338800 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Report Builder
Report Builder is something that you, as a developer, would use to create the report. I do not consider it a valid end-user tool. I want to give the users of my CF 8 site the ability to dynamically generate reports. I've never used Report Builder before. Will non-technical users be able to use this, or will something else be better suited for them? Thanks, Scott ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338807 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Report Builder
I want to give the users of my CF 8 site the ability to dynamically generate reports. I've never used Report Builder before. Will non-technical users be able to use this, or will something else be better suited for them? It really depends on two things. First, how technically proficient are these users? Do they have experience using banded report generators? Second, do you want to allow them the level of access to the server needed to generate reports with Report Builder? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsit ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338818 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: report builder similar to ms access
thanks for the replies Hi, we would like to include a feature into our software that allows users to create any report they like to display their data - similar to the reports feature in ms access does anyone have any suggestions on the best way to approach this thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337977 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
report builder similar to ms access
Hi, we would like to include a feature into our software that allows users to create any report they like to display their data - similar to the reports feature in ms access does anyone have any suggestions on the best way to approach this thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337931 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: report builder similar to ms access
Is the cf reporting feature not suitable? -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 7 October 2010 20:25, Richard White rich...@j7is.co.uk wrote: Hi, we would like to include a feature into our software that allows users to create any report they like to display their data - similar to the reports feature in ms access does anyone have any suggestions on the best way to approach this ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337932 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: report builder similar to ms access
thanks for the reply. correct me if im wrong as although i have looked at it i dont know it in depth, i thought it was inflexible as it wouldnt allow users to quickly create their own reports as they would in ms access thanks Is the cf reporting feature not suitable? -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 7 October 2010 20:25, Richard White rich...@j7is.co.uk wrote: Hi, we would like to include a feature into our software that allows users to create any report they like to display their data - similar to the reports feature in ms access does anyone have any suggestions on the best way to approach this ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337935 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: report builder similar to ms access
The most dynamical thing I've found so far is using JasperServer. It doesn't quite let you create free-form reports, but it has a lot of stuff you can use that lets the end user configure a report, and can produce reports in like 15 different formats. It is awesome. Eventually I'll get around to writing an HTML-based WYSIWYG JasperReport editor, for use with the cfjasperreport tag, which *will* be a free-form type of deal. The XML used for JasperReports is pretty easy to write, if you need free-form, you could whip up an editor and use the cfjasperreport custom tag. Another solution is to leverage iReport for the actual report design, with the JasperServer plugin. iReport is awesomeness too. :Den -- Madness is rare in individuals - but in groups, parties, nations, and ages it is the rule. Friedrich Nietzsche On Thu, Oct 7, 2010 at 8:20 AM, Richard White wrote: thanks for the reply. correct me if im wrong as although i have looked at it i dont know it in depth, i thought it was inflexible as it wouldnt allow users to quickly create their own reports as they would in ms access thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337936 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: report builder similar to ms access
Probably not ideal but throwing it out there as an option.. One way to do it is to actually use MS Access. If you can create an ODBC data source pointing to a read only account on the database you can do an import and link the tables to the database. You can set the permissions on the database to let the user only see the tables they need to see and create a sample report for them to use as a template. I actually used this sort of set up using MySQL so a company could get a daily report and running of orders placed in real time for accounting and inventory purposes. G! On Thu, Oct 7, 2010 at 8:25 AM, Richard White rich...@j7is.co.uk wrote: Hi, we would like to include a feature into our software that allows users to create any report they like to display their data - similar to the reports feature in ms access does anyone have any suggestions on the best way to approach this thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337937 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion Report Builder and Cyrillic fonts [spamtrap bayes][spamtrap heur]
On 9/23/2010 6:05 AM, Paul Kukiel wrote: Font is: Helvetica is there arial unicode or something that contains all the glyphs you need? identity-H is selected. ok. Set identity-H and the font as Helvetica And there is nothing in the report where the text should be. ( attached a snip ) no snip was attached but if it's NOT ? then it's the font. try another font. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337351 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion Report Builder and Cyrillic fonts [spamtrap bayes][spamtrap heur]
On 9/22/2010 12:11 PM, Paul Kukiel wrote: I am trying to output, using a coldfusion report builder report, text in Japanese/Russian to a PDF. They always come out with I tried the i just tried this w/cfr 9 on windows PDF output it works as expected. first off, are you sure the data/report(should be identity-H) are properly encoded? what font are you using (do not use the @ ones)? embedded or not (actually didn't matter for me but might if your client doesn't have font with those glyphs)? btw ? indicates garbaged data. empty boxes or blank glyphs indicate font or minor encoding issue. so if you're getting ? in your PDF then i'd go back to the encoding. #LSCurrencyFormat(45345,'local','ja_JP')# also works fine in cfr PDF output (provided formatted w/correct font). ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337303 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion Report Builder and Cyrillic fonts [spamtrap bayes][spamtrap heur]
Thanks Paul. Font is: Helvetica identity-H is selected. I have Windows 7 which comes with all fonts installed I assume. Also I can generate basic HTML and the Japanese fonts will display. Example I used this text int eh report: http://localhost/ee-debug/reports/it/questionreport.cfm Set identity-H and the font as Helvetica And there is nothing in the report where the text should be. ( attached a snip ) Any further ideas? Paul. On Wed, Sep 22, 2010 at 5:35 PM, Paul Hastings p...@sustainablegis.comwrote: On 9/22/2010 12:11 PM, Paul Kukiel wrote: I am trying to output, using a coldfusion report builder report, text in Japanese/Russian to a PDF. They always come out with I tried the i just tried this w/cfr 9 on windows PDF output it works as expected. first off, are you sure the data/report(should be identity-H) are properly encoded? what font are you using (do not use the @ ones)? embedded or not (actually didn't matter for me but might if your client doesn't have font with those glyphs)? btw ? indicates garbaged data. empty boxes or blank glyphs indicate font or minor encoding issue. so if you're getting ? in your PDF then i'd go back to the encoding. #LSCurrencyFormat(45345,'local','ja_JP')# also works fine in cfr PDF output (provided formatted w/correct font). ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337346 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: ColdFusion Report Builder and Cyrillic fonts [spamtrap bayes][spamtrap heur]
I disagree that ? means garbage data, and I say this because I spend a good 2 months trying to solve this problem. And the thing is that the reports that I tried to use them on, as Paul K as mentioned will work in both HTML mode, as well as Flash Paper mode with no issues. But as soon as you need to generate a PDF with the same data it won't work. This is exactly why Adobe has identified this as a bug. Regards, Andrew Scott http://www.andyscott.id.au/ -Original Message- From: Paul Kukiel [mailto:pkuk...@gmail.com] Sent: Thursday, 23 September 2010 9:06 AM To: cf-talk Subject: Re: ColdFusion Report Builder and Cyrillic fonts [spamtrap bayes][spamtrap heur] Thanks Paul. Font is: Helvetica identity-H is selected. I have Windows 7 which comes with all fonts installed I assume. Also I can generate basic HTML and the Japanese fonts will display. Example I used this text int eh report: http://localhost/ee-debug/reports/it/questionreport.cfm Set identity-H and the font as Helvetica And there is nothing in the report where the text should be. ( attached a snip ) Any further ideas? Paul. On Wed, Sep 22, 2010 at 5:35 PM, Paul Hastings p...@sustainablegis.comwrote: On 9/22/2010 12:11 PM, Paul Kukiel wrote: I am trying to output, using a coldfusion report builder report, text in Japanese/Russian to a PDF. They always come out with I tried the i just tried this w/cfr 9 on windows PDF output it works as expected. first off, are you sure the data/report(should be identity-H) are properly encoded? what font are you using (do not use the @ ones)? embedded or not (actually didn't matter for me but might if your client doesn't have font with those glyphs)? btw ? indicates garbaged data. empty boxes or blank glyphs indicate font or minor encoding issue. so if you're getting ? in your PDF then i'd go back to the encoding. #LSCurrencyFormat(45345,'local','ja_JP')# also works fine in cfr PDF output (provided formatted w/correct font). ~~ ~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael- Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf- talk/message.cfm/messageid:337346 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf- talk/unsubscribe.cfm ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337348 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
ColdFusion Report Builder and Cyrillic fonts
I'm really stuck on this issue: I am trying to output, using a coldfusion report builder report, text in Japanese/Russian to a PDF. They always come out with I tried the Press F8 in CFRB and change the PDF encoding to UTF-8 and many other with no lucck All I get is ??? or Blank where there should be text. In Flash paper I see the correct text. http://forums.adobe.com/message/3152665#3152665 Regards, Paul ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337295 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: ColdFusion Report Builder and Cyrillic fonts
This is a known bug with PDF's and the Report Builder, and is identified by Adobe as a bug. Bug #82295 The bug entered on Monday, March 01, 2010 has been marked verified by Adobe ColdFusion Team. This means Adobe ColdFusion Team has verified the behavior you've observed. (If this email is addressed to you directly, you've logged this bug. Otherwise, you've subscribed to this bug through the Adobe beta site and are receiving a BCC.) Targeted for: ColdFusion 10.0, Alpha 1 Note: Any targeting information included above is an estimate. Targeting can change during the course of bug triage. Product Area: Report Designer Severity: 4 - Important (Easy workaround, should be fixed) Description: When creating a report to be displayed in PDF format, we had used the LSCurrencyFormat to display the amount in that currency. Everyone we tried seemed to work except Japanese.While displaying it as a PDF the Yen is displayed as a question mark, however flash paper, HTML and all other format types display the YEN correctly. Regards, Andrew Scott http://www.andyscott.id.au/ -Original Message- From: Paul Kukiel [mailto:pkuk...@gmail.com] Sent: Wednesday, 22 September 2010 3:11 PM To: cf-talk Subject: ColdFusion Report Builder and Cyrillic fonts I'm really stuck on this issue: I am trying to output, using a coldfusion report builder report, text in Japanese/Russian to a PDF. They always come out with I tried the Press F8 in CFRB and change the PDF encoding to UTF-8 and many other with no lucck All I get is ??? or Blank where there should be text. In Flash paper I see the correct text. http://forums.adobe.com/message/3152665#3152665 Regards, Paul ~~ ~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael- Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf- talk/message.cfm/messageid:337295 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf- talk/unsubscribe.cfm ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337296 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion Report Builder and Cyrillic fonts
Seams there is no work around then. I'd encourage people to vote for this issue in the mean time: http://cfbugs.adobe.com/cfbugreport/flexbugui/cfbugtracker/main.html#bugId=82295 Paul. On Wed, Sep 22, 2010 at 3:54 PM, Andrew Scott andr...@andyscott.id.auwrote: This is a known bug with PDF's and the Report Builder, and is identified by Adobe as a bug. Bug #82295 The bug entered on Monday, March 01, 2010 has been marked verified by Adobe ColdFusion Team. This means Adobe ColdFusion Team has verified the behavior you've observed. (If this email is addressed to you directly, you've logged this bug. Otherwise, you've subscribed to this bug through the Adobe beta site and are receiving a BCC.) Targeted for: ColdFusion 10.0, Alpha 1 Note: Any targeting information included above is an estimate. Targeting can change during the course of bug triage. Product Area: Report Designer Severity: 4 - Important (Easy workaround, should be fixed) Description: When creating a report to be displayed in PDF format, we had used the LSCurrencyFormat to display the amount in that currency. Everyone we tried seemed to work except Japanese.While displaying it as a PDF the Yen is displayed as a question mark, however flash paper, HTML and all other format types display the YEN correctly. Regards, Andrew Scott http://www.andyscott.id.au/ -Original Message- From: Paul Kukiel [mailto:pkuk...@gmail.com] Sent: Wednesday, 22 September 2010 3:11 PM To: cf-talk Subject: ColdFusion Report Builder and Cyrillic fonts I'm really stuck on this issue: I am trying to output, using a coldfusion report builder report, text in Japanese/Russian to a PDF. They always come out with I tried the Press F8 in CFRB and change the PDF encoding to UTF-8 and many other with no lucck All I get is ??? or Blank where there should be text. In Flash paper I see the correct text. http://forums.adobe.com/message/3152665#3152665 Regards, Paul ~~ ~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael- Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf- talk/message.cfm/messageid:337295 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf- talk/unsubscribe.cfm ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337297 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFEXECUTE output Access Report
Im stuck here, and after all my years as a programmer, never have I been faced with this and on a shirt deadline. There is a pretty complex MS Access report that takes in an ID and outputs a report, how the heck can I get this to run online??? Im poking through cfexecute but no luck yet. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333433 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF Report Builder
Anyone here any good at report builder? I have a sub-report that needs to run a DISTINCT Query and loop over its output and run another query to get more info from the DISTINCT values from the first. Easy to do on CFM page and in many different ways. But I can't seem to get it to work in Report Builder. Under ReportQuery's Advanced area I have the following. The BillReview ID is passed in the URL String.. cfquery name=QryGet datasource=#App_DataSource# SELECT DISTINCT tblBillItems.ReasonCode FROM tblBillItems WHERE tblBillItems.BillHeaderID = '#BillReviewID#' /cfquery cfset Output = cfloop query=QryGet cfquery name=QryGetDesc datasource=#App_DataSource# SELECT BillItemReasonDescription FROM tblBillItemReasons WHERE BillItemReasonCode = '#ReasonCode#' /cfquery cfset OutPut = #OutPut#br #ReasonCode# #QryGetDesc.BillItemReasonDescription# /cfloop Any ideas? I have looked all through many sites and see know help on advanced abilities of Report Builder. Rick ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332875 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query/Report Builder
We have both Crystal Reports and SQL Server 2008 Reporting Services at work. While they are not super customized, they do serve the purpose of allowing users to run some rudimentary reports. However, neither is ColdFusion-based, and it sounds like that is what you are looking for. On Sun, Jan 3, 2010 at 7:51 PM, b...@bradwood.com wrote: I'm not totally sure what you are after-- I Googled Quick Query and all I could find was a MS Access plug-in. As for allowing your users to write their own queries, I really can't imagine doing this without an interface that enforced your specific business rules and limited them from running something really stupid. This is probably why the query builders I have seen before were specific to an application and its entities/relationships. There may or may not be something built in CF out there, but if you really trust your users to run anything they want on the DB, then install Query Analyzer and give them a log in with only select permissions (The thought of that kind of scares me...), or try to define a handful of reports that funnel them in a specific direction where you can control the SQL statement, but they can filter, group, and sort by themselves. ~Brad Original Message Subject: Query/Report Builder From: Tom Jones tjo...@acworld.com Date: Sun, January 03, 2010 5:12 pm To: cf-talk cf-talk@houseoffusion.com Hello, I have been looking through the archives but really did not find much on this. I'm looking for a web based query builder. I want to let my users create their own queries. It must have been done before, so I really dont want to re-invent the wheel. I came across something called Quick Query but it's a ASP.Net thing and I'm not running on Windows nor do I really want to use ASP. :-) Are there any projects or something that will give me a head start or do I need to write it from scratch? Thanks, tom ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329394 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Query/Report Builder
So, I kind of found something that I'm looking for at http://plugins.jquery.com/project/SQL_QUERY_BUILDER;. The Tables and Columns are static but I'm looking in to changing that so it's a little bit more real time. Tom I'm not totally sure what you are after-- I Googled Quick Query and all I could find was a MS Access plug-in. As for allowing your users to write their own queries, I really can't imagine doing this without an interface that enforced your specific business rules and limited them from running something really stupid. This is probably why the query builders I have seen before were specific to an application and its entities/relationships. There may or may not be something built in CF out there, but if you really trust your users to run anything they want on the DB, then install Query Analyzer and give them a log in with only select permissions (The thought of that kind of scares me...), or try to define a handful of reports that funnel them in a specific direction where you can control the SQL statement, but they can filter, group, and sort by themselves. ~Brad Hello, I have been looking through the archives but really did not find much on this. I'm looking for a web based query builder. I want to let my users create their own queries. It must have been done before, so I really dont want to re-invent the wheel. I came across something called Quick Query but it's a ASP.Net thing and I'm not running on Windows nor do I really want to use ASP. :-) Are there any projects or something that will give me a head start or do I need to write it from scratch? Thanks, tom ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329396 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Query/Report Builder
Hello, I have been looking through the archives but really did not find much on this. I'm looking for a web based query builder. I want to let my users create their own queries. It must have been done before, so I really dont want to re-invent the wheel. I came across something called Quick Query but it's a ASP.Net thing and I'm not running on Windows nor do I really want to use ASP. :-) Are there any projects or something that will give me a head start or do I need to write it from scratch? Thanks, tom ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329391 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Query/Report Builder
I'm not totally sure what you are after-- I Googled Quick Query and all I could find was a MS Access plug-in. As for allowing your users to write their own queries, I really can't imagine doing this without an interface that enforced your specific business rules and limited them from running something really stupid. This is probably why the query builders I have seen before were specific to an application and its entities/relationships. There may or may not be something built in CF out there, but if you really trust your users to run anything they want on the DB, then install Query Analyzer and give them a log in with only select permissions (The thought of that kind of scares me...), or try to define a handful of reports that funnel them in a specific direction where you can control the SQL statement, but they can filter, group, and sort by themselves. ~Brad Original Message Subject: Query/Report Builder From: Tom Jones tjo...@acworld.com Date: Sun, January 03, 2010 5:12 pm To: cf-talk cf-talk@houseoffusion.com Hello, I have been looking through the archives but really did not find much on this. I'm looking for a web based query builder. I want to let my users create their own queries. It must have been done before, so I really dont want to re-invent the wheel. I came across something called Quick Query but it's a ASP.Net thing and I'm not running on Windows nor do I really want to use ASP. :-) Are there any projects or something that will give me a head start or do I need to write it from scratch? Thanks, tom ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329393 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Report Builder
I'm starting to play around with Report Builder. can the .cfr files see application variables, such as data sources or do I have to hard code the data source name into each report -- Scott Stewart IT Consultant/ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (919) 874-6229 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328506 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Passing an object to Report Builder
Anyone know how I can pass an object to coldfusion report builder. myObj.getValue() works on a web page. I use cfreportparam name=myObj value=#myObj# I create an input parameter in report builder param.myObj Then I try and use param.myObj.getValue() and I get an error: Error evaluating expression: Source Text -- David Mineer Jr - The critical ingredient is getting off your butt and doing something. It's as simple as that. A lot of people have ideas, but there are few who decide to do something about them now. Not tomorrow. Not next week. But today. The true entrepreneur is a doer. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327596 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Passing an object to Report Builder
Nevermind. It just worked like I wanted it to. I wanted the object in a subreport but was only passing it to the main report. Setup to pass from main to subreport and now it works great. Luv U CF! On Fri, Oct 23, 2009 at 11:39 AM, David Mineer min...@gmail.com wrote: Anyone know how I can pass an object to coldfusion report builder. myObj.getValue() works on a web page. I use cfreportparam name=myObj value=#myObj# I create an input parameter in report builder param.myObj Then I try and use param.myObj.getValue() and I get an error: Error evaluating expression: Source Text -- David Mineer Jr - The critical ingredient is getting off your butt and doing something. It's as simple as that. A lot of people have ideas, but there are few who decide to do something about them now. Not tomorrow. Not next week. But today. The true entrepreneur is a doer. -- David Mineer Jr - The critical ingredient is getting off your butt and doing something. It's as simple as that. A lot of people have ideas, but there are few who decide to do something about them now. Not tomorrow. Not next week. But today. The true entrepreneur is a doer. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327598 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion Report Builder and Excel Output
Yeah, Report Builder tries to match the positioning exactly, even if it means putting in extra rows/columns in Excel. All the elements in the report would need to be aligned perfectly, and you'll still probably get extra. Alternatives we've used are CSV files, or else the HTML or XML used in excel 2003/2007, then deliver with an Excel extension - David On Wed, Jul 8, 2009 at 12:22 PM, Asaf Pelega...@locusenergy.com wrote: Hello, I've recently been messing around with ColdFusion Report Builder because of it's ability to easily output the report in different formats. To my dismay, reports that look good in PDF HTML get formatted very poorly in excel. Data gets pushed into non-sequential cells and cell formatting is unwieldy. In short, it is not a usable document. I'm wondering if anyone has had any experience, frustration, etc, trying to get the Report Builder to output useful excel documents? Can anyone point me in the right direction to format the reports so they are excel friendly? Thanks, Asaf ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324576 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ColdFusion Report Builder and Excel Output
I have had similar issues with the excel options for ColdFusion Reports. In the end, I wrote code to using CFFILE to create a csv file with a .xls extension instead. Dave Hello, I've recently been messing around with ColdFusion Report Builder because of it's ability to easily output the report in different formats. To my dismay, reports that look good in PDF HTML get formatted very poorly in excel. Data gets pushed into non-sequential cells and cell formatting is unwieldy. In short, it is not a usable document. I'm wondering if anyone has had any experience, frustration, etc, trying to get the Report Builder to output useful excel documents? Can anyone point me in the right direction to format the reports so they are excel friendly? Thanks, Asaf ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324383 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
ColdFusion Report Builder and Excel Output
Hello, I've recently been messing around with ColdFusion Report Builder because of it's ability to easily output the report in different formats. To my dismay, reports that look good in PDF HTML get formatted very poorly in excel. Data gets pushed into non-sequential cells and cell formatting is unwieldy. In short, it is not a usable document. I'm wondering if anyone has had any experience, frustration, etc, trying to get the Report Builder to output useful excel documents? Can anyone point me in the right direction to format the reports so they are excel friendly? Thanks, Asaf ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324340 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Report Builder - Other Language Capability
Kim Hoopingarner wrote: 1) What font type do I need for the asian characters? I seem to be overlooking it. what are asian characters? 2) Does this mean that I have to have different reports for the different font sets? UGH only one font has that kind of coverage, arial unicode ms. it's a whopper but if you're generating PDF embedding fonts i think it's intelligent about it. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323744 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Report Builder - Other Language Capability
Thanks for the reply. I am seeing Acrobat pulling the text as Helvetica instead of the asian-type font. I've gone as far now as to download/install the fonts for the Acrobat that are associated to the Asian characters - to no avail. And I have downloaded the MultiLanguage Support version of Acrobat Reader. UGH Any other thoughts? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323739 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Report Builder - Other Language Capability
Some progress made - I know have the Arabic working. And it does have to do with the font I select in the Report Builder. So here's 2 questions... 1) What font type do I need for the asian characters? I seem to be overlooking it. 2) Does this mean that I have to have different reports for the different font sets? UGH ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323740 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Report Builder - Other Language Capability
I have successfully stored Chinese characters into my database and they are visible on my web site. Now I am trying to print them on a report - and I keep getting the dreaded '?' instead of the characters. Is there something in the report builder I need to do to allow it to work with different languages? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323728 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Report Builder - Other Language Capability
Do you have Acrobat? Highlight the text in Acrobat and get text properties to verify that the font is correct, and check the document properties to see if the font is embedded. Is that font installed on the ColdFusion server? You can see the installed fonts in CF Administrator. If you change the format property in the cfreport tag do any of the formats display the characters? -Mike Chabot On Fri, Jun 19, 2009 at 4:18 PM, Kim Hoopingarnerk.hoopingar...@e-details.com wrote: I have successfully stored Chinese characters into my database and they are visible on my web site. Now I am trying to print them on a report - and I keep getting the dreaded '?' instead of the characters. Is there something in the report builder I need to do to allow it to work with different languages? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323729 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Report Builder Excel
My output is an excel spreadsheet. I have a report header and detail lines. I keep getting a blank row (end of page?), all my headers (except the report header) and footers are set to 0 height. Also, how can I format a character string to print leading zeros? Thanks for any and all help. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322634 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF Report Builder and Excel format
Hi Everyone, I was trying to display a report in excel format in report builder. It shows the data, but I do not find the print button options, whereas I can see it with other formats. Is this the way it is, or do I need to format anything more within my report for showing up the print button option?This is only happening for excel format It would be great if someone can help me with this Thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321753 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Delivery Report
Hi I am trying to create a delivery report for my website, the report is generated from the following tables ca_customers, ca_order_summary and ca_orderitems (please see query below) ca_customer holds the customer information (one record) ca_order_summary holds the order summary information (one record) ca_order_items contains the order items (multiple records) cfquery name=get_orders datasource=#application.dsn# SELECT c.*, os.*, oi.* FROM (ca_customers c INNER JOIN ca_order_summary os ON c.ca_cust_id = os.ca_ordersum_cust_id) INNER JOIN ca_order_items oi ON os.ca_ordersum_id = oi.ca_orderitems_sum_id WHERE 0=0 AND os.ca_ordersum_archived = cfqueryparam cfsqltype=cf_sql_bit value=no AND os.ca_ordersum_invoiced = cfqueryparam cfsqltype=cf_sql_bit value=yes AND os.ca_ordersum_delivered = cfqueryparam cfsqltype=cf_sql_bit value=no cfif Isdefined('form.webID')AND c.ca_cust_web_id = cfqueryparam cfsqltype=cf_sql_integer value=#form.webID#/cfif ORDER BY ca_ordersum_id DESC /cfquery (please note .* used for example) I would like to produce a dynamic form which displays the orders one by one and also list the order items individually and have a check box next to the order items, so the user can decide which items from the order are included in a delivery report. Order #1: Contains 5 items P1,P2,P3,P4,P5 The user would only like P3 to be included within the report. I have handled dynamic forms before and have used the following format for my check boxes, and order summary id input type=hidden name=ca_ordersum_id#currentrow# value=#ca_ordersum_id# input type=hidden name=resCount value=cfoutput#get_orders.recordCount#/cfoutput input name=output#currentrow# type=checkbox class=boxes id=output#currentrow# value=yes / And use this type of code to create a list of id's to pass to a query, however this obviously just gets the ordersum id which will still include items I do not want. I can't be very far from what I need, just need a little help tweaking it. Would I be better to build a 2d array i.e. order ID, product id if so could someone point me in the right direction with creating the array and accessing the array in the subsequent query to be produced. cfset myList = cfloop index=i from=1 to=#val(form.resCount)# cfif StructKeyExists(Form,'ca_ordersum_id#i#') cfset variables.ca_ordersum_id = form['ca_ordersum_id#i#']/ cfif StructKeyExists(Form,'output#i#') cfset Variables.output = form['output#i#']/ cfset myList = listappend(mylist, variables.ca_ordersum_id) /cfif!---//end of variables output--- /cfif!---//end of variables ca_ordersum_id--- I hope this explains what I am trying to do, it does in my head anyway:-) Kind Regards Jason ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320907 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Delivery Report
maybe i am not fully understanding your requirements, but... if you give order item checkboxes names like cb_#this_order_id#_#this_item_id#, then when your form submits it will post only checked boxes, so you will have form fields like cb_1_1, cb_1_2, cb_3_4, ... - you can then loop over form.fieldnames, and if current fieldname starts with cb_, extract the order_id and item_id from the filedname and... do whatever you need with them! (i.e. add them to a list/array you can then use to query your db to get necessary data for your report...) Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Jason Congerton wrote: Hi I am trying to create a delivery report for my website, the report is generated from the following tables ca_customers, ca_order_summary and ca_orderitems (please see query below) ca_customer holds the customer information (one record) ca_order_summary holds the order summary information (one record) ca_order_items contains the order items (multiple records) cfquery name=get_orders datasource=#application.dsn# SELECT c.*, os.*, oi.* FROM (ca_customers c INNER JOIN ca_order_summary os ON c.ca_cust_id = os.ca_ordersum_cust_id) INNER JOIN ca_order_items oi ON os.ca_ordersum_id = oi.ca_orderitems_sum_id WHERE 0=0 AND os.ca_ordersum_archived = cfqueryparam cfsqltype=cf_sql_bit value=no AND os.ca_ordersum_invoiced = cfqueryparam cfsqltype=cf_sql_bit value=yes AND os.ca_ordersum_delivered = cfqueryparam cfsqltype=cf_sql_bit value=no cfif Isdefined('form.webID')AND c.ca_cust_web_id = cfqueryparam cfsqltype=cf_sql_integer value=#form.webID#/cfif ORDER BY ca_ordersum_id DESC /cfquery (please note .* used for example) I would like to produce a dynamic form which displays the orders one by one and also list the order items individually and have a check box next to the order items, so the user can decide which items from the order are included in a delivery report. Order #1: Contains 5 items P1,P2,P3,P4,P5 The user would only like P3 to be included within the report. I have handled dynamic forms before and have used the following format for my check boxes, and order summary id input type=hidden name=ca_ordersum_id#currentrow# value=#ca_ordersum_id# input type=hidden name=resCount value=cfoutput#get_orders.recordCount#/cfoutput input name=output#currentrow# type=checkbox class=boxes id=output#currentrow# value=yes / And use this type of code to create a list of id's to pass to a query, however this obviously just gets the ordersum id which will still include items I do not want. I can't be very far from what I need, just need a little help tweaking it. Would I be better to build a 2d array i.e. order ID, product id if so could someone point me in the right direction with creating the array and accessing the array in the subsequent query to be produced. cfset myList = cfloop index=i from=1 to=#val(form.resCount)# cfif StructKeyExists(Form,'ca_ordersum_id#i#') cfset variables.ca_ordersum_id = form['ca_ordersum_id#i#']/ cfif StructKeyExists(Form,'output#i#') cfset Variables.output = form['output#i#']/ cfset myList = listappend(mylist, variables.ca_ordersum_id) /cfif!---//end of variables output--- /cfif!---//end of variables ca_ordersum_id--- I hope this explains what I am trying to do, it does in my head anyway:-) Kind Regards Jason ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320911 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Delivery Report
have all the check boxes be named the same thing. input type=checkbox name=items value=1 input type=checkbox name=items value=2 input type=checkbox name=items value=3 if all three boxes are check you will get a comma separated list in the form variable. e.g. with all 3 checked you'd get form.items = '1,2,3' then you just alter your query with an in statement ... where item_id in (cfloop from=1 to =#listlen(items)# index=icfqueryparam value=#listgetat(items, i)# cfsqltype=cf_sql_integercfif i neq listlen(items),/cfif/cfloop) ... On Wed, Mar 25, 2009 at 5:11 AM, Azadi Saryev az...@sabai-dee.com wrote: maybe i am not fully understanding your requirements, but... if you give order item checkboxes names like cb_#this_order_id#_#this_item_id#, then when your form submits it will post only checked boxes, so you will have form fields like cb_1_1, cb_1_2, cb_3_4, ... - you can then loop over form.fieldnames, and if current fieldname starts with cb_, extract the order_id and item_id from the filedname and... do whatever you need with them! (i.e. add them to a list/array you can then use to query your db to get necessary data for your report...) Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Jason Congerton wrote: Hi I am trying to create a delivery report for my website, the report is generated from the following tables ca_customers, ca_order_summary and ca_orderitems (please see query below) ca_customer holds the customer information (one record) ca_order_summary holds the order summary information (one record) ca_order_items contains the order items (multiple records) cfquery name=get_orders datasource=#application.dsn# SELECT c.*, os.*, oi.* FROM (ca_customers c INNER JOIN ca_order_summary os ON c.ca_cust_id = os.ca_ordersum_cust_id) INNER JOIN ca_order_items oi ON os.ca_ordersum_id = oi.ca_orderitems_sum_id WHERE 0=0 AND os.ca_ordersum_archived = cfqueryparam cfsqltype=cf_sql_bit value=no AND os.ca_ordersum_invoiced = cfqueryparam cfsqltype=cf_sql_bit value=yes AND os.ca_ordersum_delivered = cfqueryparam cfsqltype=cf_sql_bit value=no cfif Isdefined('form.webID')AND c.ca_cust_web_id = cfqueryparam cfsqltype=cf_sql_integer value=#form.webID#/cfif ORDER BY ca_ordersum_id DESC /cfquery (please note .* used for example) I would like to produce a dynamic form which displays the orders one by one and also list the order items individually and have a check box next to the order items, so the user can decide which items from the order are included in a delivery report. Order #1: Contains 5 items P1,P2,P3,P4,P5 The user would only like P3 to be included within the report. I have handled dynamic forms before and have used the following format for my check boxes, and order summary id input type=hidden name=ca_ordersum_id#currentrow# value=#ca_ordersum_id# input type=hidden name=resCount value=cfoutput#get_orders.recordCount#/cfoutput input name=output#currentrow# type=checkbox class=boxes id=output#currentrow# value=yes / And use this type of code to create a list of id's to pass to a query, however this obviously just gets the ordersum id which will still include items I do not want. I can't be very far from what I need, just need a little help tweaking it. Would I be better to build a 2d array i.e. order ID, product id if so could someone point me in the right direction with creating the array and accessing the array in the subsequent query to be produced. cfset myList = cfloop index=i from=1 to=#val(form.resCount)# cfif StructKeyExists(Form,'ca_ordersum_id#i#') cfset variables.ca_ordersum_id = form['ca_ordersum_id#i#']/ cfif StructKeyExists(Form,'output#i#') cfset Variables.output = form['output#i#']/ cfset myList = listappend(mylist, variables.ca_ordersum_id) /cfif!---//end of variables output--- /cfif!---//end of variables ca_ordersum_id--- I hope this explains what I am trying to do, it does in my head anyway:-) Kind Regards Jason ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320923 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Delivery Report
hmm... the way i read the op, i thought items belongs to different orders... if so, then naming all checkboxes items will make it impossible to distinguish which order a particular items belongs to: is this item 1 in order 1 or in order 1876768788? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Dan Baughman wrote: have all the check boxes be named the same thing. input type=checkbox name=items value=1 input type=checkbox name=items value=2 input type=checkbox name=items value=3 if all three boxes are check you will get a comma separated list in the form variable. e.g. with all 3 checked you'd get form.items = '1,2,3' then you just alter your query with an in statement ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320926 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Delivery Report
Hi Thank you for your replies, you are correct Azadi, I can not just have check boxes with the same name. I have resolved my issue in the following way, I removed the group attribute from my initial form output which returned one row for each order item I added an orderitem_id#currentrow# hidden field, created two lists, one for orderid and one for the orderitems id, and used the IN operator on my query. Which now returns the desired results! I have one slight problem with the initial display, its a little messy. Lets say the customer has ordered three items, now that I have removed the grouping(so I can get at individual items) the customer name is returned 3 times as well, can I use some conditions to stop this, or be able to group color the rows for the particular customer. Jason ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320942 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Delivery Report
use cfoutput with GROUP attribute. details are in the cfml reference - check it out as it is very particular syntax requiring nested cfoutput tags: cfoutput query=myquery group=column-name #columns_you_do_NOT_want_repeated# cfoutput #columns_you_need_repeated_for_each_column-name# /cfoutput #maybe_other_columns_you_do_NOT_want_repeated_below_repeated_output# /cfoutput you can also nest multiple cfoutput tags with different GROUP attributes, too. Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Jason Congerton wrote: Hi Thank you for your replies, you are correct Azadi, I can not just have check boxes with the same name. I have resolved my issue in the following way, I removed the group attribute from my initial form output which returned one row for each order item I added an orderitem_id#currentrow# hidden field, created two lists, one for orderid and one for the orderitems id, and used the IN operator on my query. Which now returns the desired results! I have one slight problem with the initial display, its a little messy. Lets say the customer has ordered three items, now that I have removed the grouping(so I can get at individual items) the customer name is returned 3 times as well, can I use some conditions to stop this, or be able to group color the rows for the particular customer. Jason ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320944 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Delivery Report
The number in the item checkbox would the primary key of the item in the items table, if you always have this of items then that is the simplest solution, your both over complicating, not the arbitrary order they appear on the page. You would join to the items table based on the order number, but your where cause would select based on the item's primary keys, not the order numbers. thus the order number would be contained in the result query as it is now. Your trying to have coldfusion do too much work that SQL could more simply do. Also ANSI style outter joins are deprecated and would be better be avoided. I stand by my original suggestion. On Wed, Mar 25, 2009 at 10:40 AM, Azadi Saryev az...@sabai-dee.com wrote: use cfoutput with GROUP attribute. details are in the cfml reference - check it out as it is very particular syntax requiring nested cfoutput tags: cfoutput query=myquery group=column-name #columns_you_do_NOT_want_repeated# cfoutput #columns_you_need_repeated_for_each_column-name# /cfoutput #maybe_other_columns_you_do_NOT_want_repeated_below_repeated_output# /cfoutput you can also nest multiple cfoutput tags with different GROUP attributes, too. Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Jason Congerton wrote: Hi Thank you for your replies, you are correct Azadi, I can not just have check boxes with the same name. I have resolved my issue in the following way, I removed the group attribute from my initial form output which returned one row for each order item I added an orderitem_id#currentrow# hidden field, created two lists, one for orderid and one for the orderitems id, and used the IN operator on my query. Which now returns the desired results! I have one slight problem with the initial display, its a little messy. Lets say the customer has ordered three items, now that I have removed the grouping(so I can get at individual items) the customer name is returned 3 times as well, can I use some conditions to stop this, or be able to group color the rows for the particular customer. Jason ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320961 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Sales Report and Output
Hi I need to do some reporting on orders from a web site, the table structure is as follows; wp_products {ID: wp_products_id JOINED TO wp_products ON ga_product_templates.wp_product_template_id=wp_products.wp_product_template_id} ga_product_templates{ID:gp_id; JOINED TO wp_products ON wp_products.wp_product_template_id=gp_product_templates.gp_id} ca_order_items{ID:ca_orderitems_id; JOINED TO wp_products ON ca_order_items..ca_orderitems_product_id=wp_products.wp_products_id} cfquery name=get_orders datasource=#application.dsn# SELECT ca_order_items.*, wp_products.*, gp_product_templates.* FROM ca_order_items INNER JOIN (gp_product_templates INNER JOIN wp_products ON gp_product_templates.gp_id = wp_products.wp_product_template_id) ON ca_order_items.ca_orderitems_product_id = wp_products.wp_products_id ORDER by gp_name /cfquery (please note using .* for testing only) I need to display the sales information per product e.g Product One: Sold 5 Total: £500, Product Two: Sold 2 Total £350 I was thinking of using queries of queries but how do I get the individual product totals, apposed to the total of all the rows, etc. Do I need to loop around my first query, set a variable add it together and display to screen? Any ideas on the best way to approach this? Thank you Jason ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320507 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
re: Sales Report and Output
Not sure of your column names, or where your 'price' value is stored, but I think you want something like what's below. Note that this also will show all your products which may have had '0' orders so far (by using the LEFT join). cfquery name=get_orders datasource=#application.dsn# SELECT gp_product_templates.gp_name, wp_products.price, SUM(ca_order_items.quantity) AS qty FROM gp_product_templates INNER JOIN wp_products ON gp_product_templates.gp_id = wp_products.wp_product_template_id LEFT OUTER JOIN ca_order_items ON wp_products.wp_products_id = ca_order_items.ca_orderitems_product_id GROUP BY gp_product_templates.gp_name, wp_products.price ORDER BY gp_product_templates.gp_name /cfquery table tr thProduct/th thQuantity Sold/th thTotal Dollars/th /tr cfoutput query=get_orders tr td#gp_name#/td td#qty#/td td #dollarFormat(qty * price)# /td /tr /cfoutput /table ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320508 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Sales Report and Output
Hi jason Thanks for your reply, a few tweaks to my table names and it worked great! Thank you!!! Jason ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320513 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sales Report and Output
Awesome, glad to help! Aggregate functions are your fun and easy friends (SUM, COUNT, MIN, MAX, GROUP BY) ... good stuff. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320519 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF8 Report Builder chart issue
I'm new to report builder. I created a chart using the chart wizard and the chart display as I intended. The problem is, when I had the cart in the Detail tab the chart was repeated once for each data point. I charted 51 data points so I got that chart 51 times. I moved it to the Column Header tab and now it only repeats 11 times. My first question obviously is why do I get multiple copies of the chart. My second question is can anyone point me to a good tutorial or reference for someone new to Report Builder? Thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319424 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion 8 Report Builder XHTML problem
Does anyone have any idea on this??? Hi im using cf8 report builder to generate a printed mailshot. the report is displayed in PDF so the users can save them. my problem is i have defined my main fields to display XHTML (true) but when i enter a £ / ⬠symbol it will not display in XHTML it will only show the code. also if i have an email hyperlink displayed it refuses to display in XHTML. does anyone have an idea on this??? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318833 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Coldfusion 8 Report Builder XHTML problem
Hi im using cf8 report builder to generate a printed mailshot. the report is displayed in PDF so the users can save them. my problem is i have defined my main fields to display XHTML (true) but when i enter a £ / ⬠symbol it will not display in XHTML it will only show the code. also if i have an email hyperlink displayed it refuses to display in XHTML. does anyone have an idea on this??? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318743 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Report Builder aggravation
I developed a report using CFRB, and designed it on my local host (desktop). It's fine when I look at it locally, and shows up on screen, and when printed in the Portrait orientation. I take that same file, move it over to our production server, and both on screen and printed are coming out landscape. Any solution ideas? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317089 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Chart and CF Report Builder
I have some questions regarding the ColdFusion Report builder that Iâm hoping you can help me. Or maybe you can point me in the direction of someone who might. The report Iâm trying to build has the header area which contains summary and the graph contains the detail. There can be many summaries with their details. We used different approaches to build the report, but the one that got us closer to the results we wanted was to build the report I used 2 queries. Iâm trying to pass my variable (id) to the 2nd query to get the related graph. When the report is for 1 single summary/graph, I pass the id to my 2nd query and it works. But when the report is for multiple summary/graph, only the first row selected from the 1st query will pass to the 2nd query. Therefore I have 1 graph with all the data retrieved for all the summaries. It seams like the cfloop doesnât do anything(??!!) Another approach I tried was to put my graph in a subreport and pass the id as param.id, didnât work either. In case it helps, here is the code on my cfm page: cfloop query=GetRpt cfset request.getGraph = getGraph() cfreport format=pdf template= payment_Detail.cfr permissions=AllowPrinting Query=GetRpt overwrite=yes/ cffunction name=getGraph returntype=query cfset var GraphQuery = '' cfquery name=GraphQuery datasource=#request.dsn# SELECTid , to_char(invoice_dt, 'MM/DD/') as invoice_dt , to_char(invoice_dt, '/MM/DD') as sort_invoice_dt , TO_NUMBER(payment_line_amt,'') as payment_line_amt , INVOICE_LINE_AMT FROM PAYMENT_DETAIL WHEREID =#GetRpt.ID# ORDER BY sort_invoice_dt /cfquery cfreturn GraphQuery /cffunction /cfloop ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316606 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Chart and CF Report Builder
I have some questions regarding the ColdFusion Report builder that Iâm hoping you can help me. Or maybe you can point me in the direction of someone who might. The report Iâm trying to build has the header area which contains summary and the graph contains the detail. There can be many summaries with their details. We used different approaches to build the report, but the one that got us closer to the results we wanted was to build the report I used 2 queries. Iâm trying to pass my variable (id) to the 2nd query to get the related graph. When the report is for 1 single summary/graph, I pass the id to my 2nd query and it works. But when the report is for multiple summary/graph, only the first row selected from the 1st query will pass to the 2nd query. Therefore I have 1 graph with all the data retrieved for all the summaries. It seams like the cfloop doesnât do anything(??!!) Another approach I tried was to put my graph in a subreport and pass the id as param.id, didnât work either. In case it helps, here is the code on my cfm page: cfloop query=GetRpt cfset request.getGraph = getGraph() cfreport format=pdf template= payment_Detail.cfr permissions=AllowPrinting Query=GetRpt overwrite=yes/ cffunction name=getGraph returntype=query cfset var GraphQuery = '' cfquery name=GraphQuery datasource=#request.dsn# SELECTid , to_char(invoice_dt, 'MM/DD/') as invoice_dt , to_char(invoice_dt, '/MM/DD') as sort_invoice_dt , TO_NUMBER(payment_line_amt,'') as payment_line_amt , INVOICE_LINE_AMT FROM PAYMENT_DETAIL WHEREID =#GetRpt.ID# ORDER BY sort_invoice_dt /cfquery cfreturn GraphQuery /cffunction /cfloop ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316607 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Chart and CF Report Builder
I have some questions regarding the ColdFusion Report builder that Iâm hoping you can help me. Or maybe you can point me in the direction of someone who might. The report Iâm trying to build has the header area which contains summary and the graph contains the detail. There can be many summaries with their details. We used different approaches to build the report, but the one that got us closer to the results we wanted was to build the report I used 2 queries. Iâm trying to pass my variable (id) to the 2nd query to get the related graph. When the report is for 1 single summary/graph, I pass the id to my 2nd query and it works. But when the report is for multiple summary/graph, only the first row selected from the 1st query will pass to the 2nd query. Therefore I have 1 graph with all the data retrieved for all the summaries. It seams like the cfloop doesnât do anything(??!!) Another approach I tried was to put my graph in a subreport and pass the id as param.id, didnât work either. In case it helps, here is the code on my cfm page: cfloop query=GetRpt cfset request.getGraph = getGraph() cfreport format=pdf template= payment_Detail.cfr permissions=AllowPrinting Query=GetRpt overwrite=yes/ cffunction name=getGraph returntype=query cfset var GraphQuery = '' cfquery name=GraphQuery datasource=#request.dsn# SELECTid , to_char(invoice_dt, 'MM/DD/') as invoice_dt , to_char(invoice_dt, '/MM/DD') as sort_invoice_dt , TO_NUMBER(payment_line_amt,'') as payment_line_amt , INVOICE_LINE_AMT FROM PAYMENT_DETAIL WHEREID =#GetRpt.ID# ORDER BY sort_invoice_dt /cfquery cfreturn GraphQuery /cffunction /cfloop In the query builder of my chart series I call the request.getGraph so the chart can see the query. As I said when I pass one id then itâs ok but when more than 1 id is passed it shows the graph based on the 1st selected row of data for all other data retrieved by the 1st query. I want to be able to show the first summary followed by itâs detail graph, then the second summary followed by itâs detail graph, etc. Any help or suggestions will be greatly appreciated. Thank you in advance ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316608 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Report Builder Question
Denny, I have started to work in JasperReports, can you shoot me an email at your convenience? I have some questions about the set up for CF and JR to work together nicely. Email is first letter first name and full last name at gmail (stupid spam bots). Cheers, Mike Greider JasperReports is built right into coldfusion. You can create a jasperreport JRXML file using iReport, and use createObject to run the report, etc. I don't do it any more because report generation takes such a toll on the server, and it's just waay better to have report stuff running on a separate server, pulling from a replication database. So now I use JasperServer, and it's KICK ASS! For anyone doing a lot of reporting, I'd recommend it. Simply the best! But if you're stuck with pure CF, and need to do those common reporting things that are just impossible with reportbuilder, then createObject and jasperrepoerts might be the way to go, because you can build the reports with iReport, which is a STELLAR report-builder (cross platform y todo). HIH, :Denny -- If an injury has to be done to a man it should be so severe that his vengeance need not be feared. Niccolo Machiavelli ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314693 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Report builder charset?
bert db wrote: I tried this option, it did remove the '?' character, but unfortunately it does not print anything. got the right font (ie one that supports those chars)? what's the app's intended encoding? Well the oracle database uses the charset ISO 8859-1 which works fine for all the coldfusion pages. I have tried changing the different fonts but no luck with that either. I have incorporated the query directly in the cfr, instead of the cfm, to see if there was a problem in the communication between the two but no luck either. I have also looked at the Cp1252 and it should contain the ⬠sign (Hex80). All of this tells me that there is something quite weird... I already had quite a number of problems with cfr. But this tops it all. B. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313912 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Report builder charset?
bert db wrote: I just found a solution, well sort of a hack. I found out that when I wrote the ⬠directly in a text field in the builder it prints okay (whichever encoding I use (cp1252 or identity-H). I then isolated the value of the character returned by the database for this sign ( 128 for the encoding iso 8859-1, but for whatever reason it is 191 for the cp1252 (hex(80)= 191 ?? ;-)) ) and transform all of these characters to the ⬠sign with a simple replace. there's no euro char in the iso-8859-1 (latin-1) charset, it came out well before the existence of the euro. the euro is found in iso-8859-15 (AKA latin-9, don't ask) where it's at decimal 164 codepoint or in unicode at decimal 8364. hex 80 *is* decimal 128. decimal 191 (hex BF) is an inverted question mark ¿ in windows-1252 (ditto for unicode). i suggest you front-to-back review your data entry process make sure the encodings are all the same for every part of your app. also make sure that the oracle charset is exactly the same the cf ones, especially as oracle likes to name it's own charsets the same as ISO/IEC ones even though they are slightly different. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313919 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Report builder charset?
bert db wrote: Well the oracle database uses the charset ISO 8859-1 which works fine for all the coldfusion pages. unless you've changed the default encoding for cf from utf-8, it shouldn't (for some chars anyway). Well I have these directives in my entry point: cfcontent type=text/html; charset=iso-8859-1 cfset setencoding(FORM, iso-8859-1) cfset setencoding(URL, iso-8859-1) I have also looked at the Cp1252 and it should contain the ⬠sign (Hex80). oops, you're right i was thinking of latin-1, cp1252 is a superset of latin-1 (apparently i forgot even though i keep reminding people of this fact on an almost daily basis ;-). All of this tells me that there is something quite weird... what's the encoding on that page? are you using cfprocessingdirective? is there a public page that shows this problem that i can peek at? can i see the code? (send off-list). I just found a solution, well sort of a hack. I found out that when I wrote the ⬠directly in a text field in the builder it prints okay (whichever encoding I use (cp1252 or identity-H). I then isolated the value of the character returned by the database for this sign ( 128 for the encoding iso 8859-1, but for whatever reason it is 191 for the cp1252 (hex(80)= 191 ?? ;-)) ) and transform all of these characters to the ⬠sign with a simple replace. I would prefer to understand the underlying cause, but since i've started with coldfusion a year ago, I have learned not to ask too many questions and try to find hacks for whatever does not work correctly. Thanks a lot for you patience. B. PS. (If you want to have fun run this code you will be amazed by the result: cfloop from='5.00' to='5.25' step='0.01' index=i cfoutput cfset test=#i# #test# --- #test * 100# --- #(test * 100) MOD 100# --- br /cfoutput /cfloop cfoutput br cfset test=5.01 #test# --- #test * 100# --- #(test * 100) MOD 100# --- br /cfoutput cfoutput cfset test=5.02 #test# --- #test * 100# --- #(test * 100) MOD 100# --- br /cfoutput cfoutput cfset test=5.03 #test# --- #test * 100# --- #(test * 100) MOD 100# --- br /cfoutput cfoutput cfset test=5.10 #test# --- #test * 100# --- #(test * 100) MOD 100# --- br /cfoutput ) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313916 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Report builder charset?
bert db wrote: Well the oracle database uses the charset ISO 8859-1 which works fine for all the coldfusion pages. unless you've changed the default encoding for cf from utf-8, it shouldn't (for some chars anyway). I have also looked at the Cp1252 and it should contain the ⬠sign (Hex80). oops, you're right i was thinking of latin-1, cp1252 is a superset of latin-1 (apparently i forgot even though i keep reminding people of this fact on an almost daily basis ;-). All of this tells me that there is something quite weird... what's the encoding on that page? are you using cfprocessingdirective? is there a public page that shows this problem that i can peek at? can i see the code? (send off-list). ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313913 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Report builder charset?
Hi, I have some report created with the report builder MX7. I am running into some problems with the charset it uses. Some of my users have put some exotic caracters in text fields (principally the 'â¬' sign). I have no problems within my coldfusion pages but in the generated pdf, it prints out as a '?'. I was wondering if anybody knows how to specify the charset that the builder should use, or if anybody knows the charset used by the report builder (there is always a way to change the charset returned by the DB). I have looked in the docs but could not find anything about this. Thanks, B. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313837 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Report builder charset?
bert db wrote: I have some report created with the report builder MX7. I am running into some problems with the charset it uses. Some of my users have put some exotic exotic? not to them i imagine. caracters in text fields (principally the 'â¬' sign). I have no problems within my coldfusion pages but in the generated pdf, it prints out as a '?'. plain cf/html works ok? I was wondering if anybody knows how to specify the charset that the builder should use, or if anybody knows the charset used by the report builder (there is always a way to change the charset returned by the DB). I have looked in the docs but could not find anything about this. press F8 to get the preferences dialog (for some strange reason it's under the edit menu), the PDF character encoding value should be Identity-H not windows codepage 1252 (cp-1252 which i think doesn't contain the euro). ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313838 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Report builder charset?
bert db wrote: I have some report created with the report builder MX7. I am running into some problems with the charset it uses. Some of my users have put some exotic exotic? not to them i imagine. Probably not to them ;-) If only everybody used only ASCII chars our job would be a lot easier ;-) caracters in text fields (principally the 'â¬' sign). I have no problems within my coldfusion pages but in the generated pdf, it prints out as a '?'. plain cf/html works ok? the cfr is called from a simple cf page where I define the query, and when in that page I do a simple cfoutput of the info it prints correctly. I was wondering if anybody knows how to specify the charset that the builder should use, or if anybody knows the charset used by the report builder (there is always a way to change the charset returned by the DB). I have looked in the docs but could not find anything about this. press F8 to get the preferences dialog (for some strange reason it's under the edit menu), the PDF character encoding value should be Identity-H not windows codepage 1252 (cp-1252 which i think doesn't contain the euro). I tried this option, it did remove the '?' character, but unfortunately it does not print anything. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313846 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Report builder charset?
bert db wrote: I tried this option, it did remove the '?' character, but unfortunately it does not print anything. got the right font (ie one that supports those chars)? what's the app's intended encoding? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313869 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF8 Report Builder - Report Format Error
I'm trying out Report Builder for the first time to generate a report. While I can output the file to the screen without any problems (by leaving out the filename attribute), I am getting an error when trying to save it. If I place a document in the location where I've specified with the filename attribute, I can read it just fine from the browser...I'm just missing something here that's eluding me. Any ideas? The error: Report format error. The filename, directory name, or volume label syntax is incorrect The code: cfreport filename=http://dtsc-dev/temp/SBA_Temp.pdf; format = PDF template = c:\\inetpub\wwwroot\Database\Military_Billings\CFR_Templates\SBA.cfr overwrite = yes cfreportparam name=pINVOICE_ID value=#variables.Invoice_ID# /cfreport ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312590 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8 Report Builder - Report Format Error
Hi Jim, the filename attribute requires an absolute system path, you might try expandpath(). bye, marcus Jim Gabler schrieb: cfreport filename=http://dtsc-dev/temp/SBA_Temp.pdf; format = PDF template = c:\\inetpub\wwwroot\Database\Military_Billings\CFR_Templates\SBA.cfr overwrite = yes ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312591 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 Report Builder - Report Format Error
Thanks Marcus. Just using the absolute path did the trick (could have sworn that I had tried that). What threw me off was that Dreamweaver provided only 3 options for the filename attribute and they were ftp:, http:, and https:. So I was really led astray by Dreamweaver (guess this is a case of one division of adobe not communicating with another!). Hi Jim, the filename attribute requires an absolute system path, you might try expandpath(). bye, marcus ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312608 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion report builder
I thought CF report builder was free? I finally get everything up and running and received the big Trail version message on my report. Is this because I am running it on the development version of CF? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310430 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion report builder
Torrent Girl wrote: I thought CF report builder was free? I finally get everything up and running and received the big Trail version message on my report. Is this because I am running it on the development version of CF? Yes the builder is free, but what renders the built file is not. You will get that message when the .rpt file is rendered on a Development server, but not on licensed ones. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310433 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion report builder
On Tuesday 05 Aug 2008, Torrent Girl wrote: I am connecting to a development server. Let's say the url is http://devName/. Do I put devName as the host name? Yup. Though as it sounds like you've not got the server running yet, I'd leave this for now :-) -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310274 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion report builder
Yup. Though as it sounds like you've not got the server running yet, I'd leave this for now :-) WELL, I am trying to do both. I installed CF locally because I could not RDS in the dev server. NEITHER work :) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310293 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion report builder
Tom i am still having no luck. I am connecting to a development server. Let's say the url is http://devName/. Do I put devName as the host name? On Monday 04 Aug 2008, Torrent Girl wrote: 1. hostname The name of the machine (in DNS or WINS). The same thing that goes after 'http://' but before the directory and file names. 2. context root Almost certainly '/' unless you've heard of the expression before. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310227 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Coldfusion report builder
Can anyone help me with cf report builder? I am trying configure the rds server but have no idea of what to put in the following: 1. hostname 2. context root I googled all day friday with no luck. I know it's probably something simple but I know no server-side stuff. thanks tgirl ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310117 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion report builder
On Monday 04 Aug 2008, Torrent Girl wrote: 1. hostname The name of the machine (in DNS or WINS). The same thing that goes after 'http://' but before the directory and file names. 2. context root Almost certainly '/' unless you've heard of the expression before. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310139 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4