Re: imageScaleToFit() on CF8.0.1 takes forever or times out
thought i would post a little follow-up to this issue: there is definitely some bug in the cfimage hotfix that makes imagescaletofit() function run forever... the only way i managed to work around this issue is to uninstall the CF8.0.1 cumulative hotfix 1 and cfimage hotfix and use the ImageWriteReplacement() function mentioned in a previous post instead of imagewrite() to overcome the file locking issue (which was solved in the updated cfimage hotfix). This works fantastic on a 1.6 JVM, but does not on 1.5 JVM - i guess the java methods used in the imagewritereplacement() function are specific to 1.6 (?). at least it kept crashing on me until i upgraded my server jvm back to ver 1.6... so... does anyone want to try to reproduce this issue? let me know and i shall post the code... Azadi Saryev Sabai-dee.com http://www.sabai-dee.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:31 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: mac address and additional protection
On Monday 08 Sep 2008, Richard White wrote: however there is nothing stopping them from creating a login and providing that same login to various people If you can't trust your end users not to violate the license terms, you can't trust them not to alter your code. You could, for instance, use public key encryption to 'sign' the config file that says 'number of users = 100' so it can't be changed, but the end user could just comment out your signature check shrug. We're getting into 'DRM is a pointless arms race' land here :-) -- 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:312223 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFC and MG2 where does validation fit in?
thanks jaime. wow i didnt even know about cfcdev but looks amazing :) thanks again richard Richard, There was a ton of discussion on this just recently - maybe on CFCDEV - so there might be a bit of validation fatigue out there. On the upside, you should find rich pickings in the list archives. Basically both of your proposed solutions sound fine. If there was a consensus (not sure if there was), I think it would go something like: 1. Your instinct to remove the reusable validation logic from the controller is sound. 2. Putting it in the service is OK 3. Breaking it out into a separate validation object is also OK, and maybe slightly preferable. Jaime ~| 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:312224 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
xml include not working
hi, i am trying to include one xml file into another can anyone tell me what i am doing wrong please: event-handlers include template=/re_base_mg/config/event_handlers/MainControllerEventHandlers.xml / /event-handlers i am getting no errors but when i run the page it cannot find the error handlers inside the MainControllerEventHandlers.xml file that i am trying to include - indicating that it is not including the xml file properly thanks richard ~| 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:312225 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How to speed up Hard Refresh
Sorry about the delay in my response. Something came up at work that distracted me from this project. On Wed, Sep 3, 2008 at 1:09 PM, Brian Kotek [EMAIL PROTECTED] wrote: Because of the nature of dependencies in a large OO application, reloading one component can be difficult or impossible. As I have discovered. Thanks for letting me not feel like a moron for not being able to come up with a way. You can try updating your JVM to Java 1.6.10, which is in release candidate and which fixes the bugs in the previous versions regarding the class loader. This speeds up CFC creation greatly. Thanks for this helpful suggestion. Is this something I could easily undo if it created unexpected problems? ~| 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:312226 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: xml include not working
Hey Richard, You might want to ask this question over on the model-glue google group. This is fairly specific to model-glue and while you may get a response here, there's liable to be more help available on the google group. I know a lot of folks I've spoken to over the years have mentioned not being on the cf-talk list because there's more traffic here than they want to deal with. But the same folks often do participate in these more specific lists. http://groups.google.com/group/model-glue hth -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 781.769.0723 http://onTap.riaforge.org/blog ~| 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:312227 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
JVM memory and query cache
The maximum JVM heap size is used for the query cache too? I have in cache (using query cache) some large result set and the server sometimes respond very slowly. The server has a lot of free memory, but I receive the JVM Memory Alert from ColdFusion. I'm wondering if increasing the jvm heap size can improve the performance. Any advice? ~| 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:312228 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) How do you preload a SWF file?
Hey, i know I'm a week late in responding (I was on vacation, forgive me!), but I do have one more question about this: Are there any concerns around the additional load on the web server from having to load the swf file for every user, even those that may never actually launch the application? On the main page just have an object/embed call with the SWF loaded in at 1 pixels by one pixel. Hey folks - this is OT but I know someone on this list will know the answer: I need to 'pre-load' a SWF file prior to it ever being launched with a click. I have done some googling and it appears it can be done, but I'm just wondering if someone here has done it below. Here is the scenario: ~| 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:312229 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: (ot) How do you preload a SWF file?
Hey, i know I'm a week late in responding (I was on vacation, forgive me!), but I do have one more question about this: Are there any concerns around the additional load on the web server from having to load the swf file for every user, even those that may never actually launch the application? The load from this will be much less significant than the work needed to process a single CF file in most cases, so I wouldn't worry about it too much. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:312230 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
NullPointers error problem
Hi all, I've upgraded my server from CF7 to CF8 without make any changes to the website code. Sometimes.. I've got an error like the server lose values of some variables. It's random. If i try to reload the same page, it works fine... and after twice time i've got the same error. No data entry.. only click on the navigation bar and sometimes I've got the error page. Following.. the error is: The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code. Null Pointers are another name for undefined values. The error occurred in */index.cfm: line 243* 241 : /cfif 242 : *243 : cfquery name=centri datasource=thdintranet* 244 : select * from centri 245 : /cfquery I'm sure the datasource exist and works! any suggestion will be appreciated. Thanks in advance Stefano ~| 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:312231 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: NullPointers error problem
That looks to me like an issue with the drivers for your database. If you've been using the ODBC drivers with CF7 I would try switching to Java drivers if they're available. I don't know whose database you're using (Access, MySQL, SQL Server, etc.) so I can't say if there are Java drivers for it. -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 781.769.0723 http://onTap.riaforge.org/blog ~| 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:312232 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: NullPointers error problem
right! I'm using MySQL 5.0.22 dbase on the same server. It's always return me correct data.. at least when the error does not occour. s. isaac dealey ha scritto: That looks to me like an issue with the drivers for your database. If you've been using the ODBC drivers with CF7 I would try switching to Java drivers if they're available. I don't know whose database you're using (Access, MySQL, SQL Server, etc.) so I can't say if there are Java drivers for it. ~| 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:312233 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: JVM memory and query cache
On Tuesday 09 Sep 2008, Fabio Serra wrote: The server has a lot of free memory, but I receive the JVM Memory Alert from ColdFusion. But how much of that is CF allocated to use ? -- 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:312234 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: JVM memory and query cache
Tom Chiverton wrote: On Tuesday 09 Sep 2008, Fabio Serra wrote: The server has a lot of free memory, but I receive the JVM Memory Alert from ColdFusion. But how much of that is CF allocated to use ? Do you mean the JVM heap size? The maximum is 640 Mb and I have an average of 800 Mb free on the server. I know that I can increase it, but the query cache is included in the Maximum heap size? Thanks ~| 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:312235 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF8 Bug? CFReport / Flashpaper
Hi List, I posted the message CF7 ENT = CF8, CFReport Font size issues a few days ago, I'm pretty sure now that this is a bug in CF8, more details on this: The source report is a pretty complex (as far as the layout is concerned) one-page report with some calculated fields that are fed by a cfquery. It was originally created using the CF7 Report Builder. To be able to reproduce CF8's behaviour, I set up a really small cfm page that calls the report like this: cfreport template = source.cfr file=result.pdf format=pdf overwrite=true cfreportparam name=von value=11:00:00 cfreportparam name=bis value=13:00:00 cfreportparam name=datum value=08.09.2008 /cfreport cfreport template = source.cfr file=result.swf format=flashpaper overwrite=true cfreportparam name=von value=11:00:00 cfreportparam name=bis value=13:00:00 cfreportparam name=datum value=08.09.2008 /cfreport a href=result.pdf target=_blankPDF result/a a href=result.swf target=_blankFlash result/a When I start this template, the following happens: * The PDF file takes about 3s to render (about 5 pages containing a bunch of calculated fields, query results etc.) and is instantly written to disk. The layout is *mostly* correct - I'd say 98% - and personally, I could live with that. * The SWF file is created, has 0 bytes at first and takes about 10mins (!) if the report contains the font Arial Unicode MS. During these 10mins, the cf process does not even eat cpu - it seems as if it waits for something. If at least the result was correct - no, it isn't. Almost all labels are way too big and the layout is messed up. I tried the following: * Symlinking ARIALUNI.TTF to other non-unicode fonts SWF is created as fast as the PDF, but layout is still broken. * Opening and re-saving the report in CF8's Report Builder No change When I run the same template in CF7 on the same machine using all the same settings, same browser, same fonts, same weather, same coffee... both the PDF and SWF reports are rendered as expected. CF7 even swallows the report saved with the CF8 report builder and has no problems working with Arial Unicode MS... *sigh* The problem is: the customer is running a Flex2 app that displays the SWF report inline, and as they are using rather small thin clients, switching to PDFs is not really an option. Additionally, there's not only THIS report, but about 100, all of them show the same behaviour. To sum it up: CF7, PDF: works CF7, SWF: works CF8, PDF: works, small layout issues CF8, SWF: fails Has anyone of you run into similar issues yet? System: SLES10, 32bit, Apache2, CF7 / CF8 -- Mit freundlichen Grüßen, Marcus Raphelt at.net websolutions Mühlenbeck Raphelt GbR Klever Str. 60 47839 Krefeld Tel.: 02151 / 3699732 Fax : 02151 / 3699734 Mob.: 0151 / 58113803 mailto: [EMAIL PROTECTED] http://www.atnet-websolutions.de ~| 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:312236 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: JVM memory and query cache
When you say the Maximum is 640 MB, do you mean the Maximum JVM Heap Size (MB) setting on the Java and JVM page of CF Administrator is set to 640? Also, run this code: cfset runtime = CreateObject(java, java.lang.Runtime).getRuntime() cfset freeMemory = runtime.freeMemory() / 1024 / 1024 cfset totalMemory = runtime.totalMemory() / 1024 / 1024 cfset maxMemory = runtime.maxMemory() / 1024 / 1024 Max Memory Available to JVM: #Round(maxMemory)#MBbr Total Memory Allocated: #Round(totalMemory)#MBbr Free Allocated Memory: #Round(freeMemory)#MB You can also install a product like SeeFusion to help you monitor how much memory is actually used. Also, can you give us the exact wording of this JVM Memory Alert? In some cases your Heap will have free memory, but your Permanent Generation memory will be full. Your permgen only gets 128 to 192 MBs by default depending on your version of CF. (-XX:MaxPermSize) ~Brad From: Fabio Serra [EMAIL PROTECTED] But how much of that is CF allocated to use ? Do you mean the JVM heap size? The maximum is 640 Mb and I have an average of 800 Mb free on the server. I know that I can increase it, but the query cache is included in the Maximum heap size? Thanks ~| 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:312237 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 Bug? CFReport / Flashpaper
It looks like you need to find out what your server is doing during those 10 minutes. I would recommend installing SeeFusion or Fusion-Reactor and start looking at the stack trace while it is processing. If there is no CPU usage, it might be getting hung on an image, query, or basically any code that requires blocking for an external resource. Also, if you post this over to the Adobe forums you *might* catch the attention of someone from Adobe to help you or at least confirm if it is a bug. ~Brad - Original Message - From: Marcus Raphelt [EMAIL PROTECTED] * The SWF file is created, has 0 bytes at first and takes about 10mins (!) CF7, PDF: works CF7, SWF: works CF8, PDF: works, small layout issues CF8, SWF: fails ~| 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:312238 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: JVM memory and query cache
Brad Wood wrote: When you say the Maximum is 640 MB, do you mean the Maximum JVM Heap Size (MB) setting on the Java and JVM page of CF Administrator is set to 640? My Maximum JVM Heap Size (MB) in CF Administrator is set to 640 MB and -XX:MaxPermSize=192m The result of the cfml script (wow thanks!) is: Max Memory Available to JVM: 616MB Total Memory Allocated: 522MB Free Allocated Memory: 148MB With memory alert :-) I mean the email alert from the ColdFusion monitor where I setted the threshold to 600 Mb. When I receive the alert usually the server is going slowly. Currently I have some new query cached and I suspect that this is the problem, because until that I've never received a memory alert. So my question is: if I increasing the jvm heap size from the cf admin can I improve the server performance? ~| 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:312239 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: NullPointers error problem
There is a known bug with the MySQL drivers. In your CF Administrator, click to edit your datasource and do the following: 1) uncheck the maintain connection, and 2) add the number zero in the validation query box That should fix your issue. On Tue, Sep 9, 2008 at 9:36 AM, Stefano Borali wrote: right! I'm using MySQL 5.0.22 dbase on the same server. It's always return me correct data.. at least when the error does not occour. ~| 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:312240 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: mac address and additional protection
Or you could try to do what microsoft did with windows... allow the licensing terms to easily be bypassed - and let a huge installed base of loyal users get hooked on it.. then when it comes times for upgrades - crack down. Have the upgrade count how many users are in the database and refuse to install if more than the licensed # of users are using it.. and if it turned into a critical software - they would have no choice but to upgrade to the correct liscense. If you can't trust your end users not to violate the license terms, you can't trust them not to alter your code. You could, for instance, use public key encryption to 'sign' the config file that says 'number of users = 100' so it can't be changed, but the end user could just comment out your signature check shrug. We're getting into 'DRM is a pointless arms race' land here :-) ~| 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:312241 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: JVM memory and query cache
Quite possibly. What scope are you caching the query in? How many columns and records is the query? How many times is the query being cached? i.e. once for each user... If your operating system has enough RAM (remember to save some for Windows, SQL, etc) it is possible to increase the upper limit on a 32 bit machine up to 1.8 Gigs. Also, there are some garbage collection JVM args that may help. When your server is running slowly, run garbage collection and see how far the memory usage comes down. This like of code along with what I gave you before will manually force garbage collection: cfset runtime.gc() ~Brad - Original Message - From: Fabio Serra [EMAIL PROTECTED] if I increasing the jvm heap size from the cf admin can I improve the server performance? ~| 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:312242 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfdocument playing silly buggers on production.
Guys, Quick buzz for some advice. I've just rolled a copy of my application onto the production server and cfdocument seems to not load any external resources such as images or css. The code works perfectly in development. The only thing that comes to mind for the moment is that the site is under SSL which I know can cause the kind of problems with cfdocument however I'm linking to the document using a non secure URL, such as: http://www.mydomain.com/myfile.cfm?format=pdf All the resources such as images and css within the document are sourced using relative paths like img src=/images/pullyourthumbout.png /. I've also tried making these paths a more absolute version, using src=http://mydomain.com and get the same result, and again, using the new cf8 localurl=true approach doesn't seem to change anything. Does anyone know a work around for this? I'm sure it's something some of you have come across in the past. Thanks for your advice, Robert ~| 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:312243 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfdocument playing silly buggers on production.
Hi, as far as I can remember, we solved this in a CF7 project by pointing to images using file:///-Links. Not very elegant, but it worked. bye, marcus Robert Rawlins schrieb: Does anyone know a work around for this? I'm sure it's something some of you have come across in the past. ~| 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:312244 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How to speed up Hard Refresh
If you need to, point it back at the older JVM. Or just back up the JVM config file and if things go wrong, copy it back. :-) On Tue, Sep 9, 2008 at 9:36 AM, Bryan S [EMAIL PROTECTED] wrote: Sorry about the delay in my response. Something came up at work that distracted me from this project. On Wed, Sep 3, 2008 at 1:09 PM, Brian Kotek [EMAIL PROTECTED] wrote: Because of the nature of dependencies in a large OO application, reloading one component can be difficult or impossible. As I have discovered. Thanks for letting me not feel like a moron for not being able to come up with a way. You can try updating your JVM to Java 1.6.10, which is in release candidate and which fixes the bugs in the previous versions regarding the class loader. This speeds up CFC creation greatly. Thanks for this helpful suggestion. Is this something I could easily undo if it created unexpected problems? ~| 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:312245 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
dynamic js field verification
Hi, I am working on a page where an admin would enter an id number for one or more of a list of people. as it is important that the numbers match, I am making a verification field to check the numbers match. All fine and dandy, however I would like to have js check this before the form is submitted. The code I have is not working, I am guessing it has to do with naming the function, but I am pretty much a complete newbie to java. how can I make this work? cfoutput query=rscards !---Convert int to string for java--- cfset chk=chktostring(rscards.dealerid) cfset javaint=tostring(rscards.dealerid) cfset java=javatostring(rscards.dealerid) cfinput type=text name=#javaint# id=#javaint# value= onvalidate=#java# / cfinput type=text name=#chk# value= id=#chk# message=oops onvalidate=#java# /#rscards.first_name# #rscards.last_name# #rscards.dealerid#br / script type=text/javascript function #java#(form) { if(form.#javaint#.value == form.#chk#.value) { return true; } else { alert(Error: #rscards.first_name# #rscards.last_name#'s info does not match.); form.#chk#.focus(); return false; } } /script /cfoutput cfinput type=submit value=Submit name=submit / /cfform ~| 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:312246 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfdocument playing silly buggers on production.
Hi Marcus, Thanks for that suggestion. That certainly works for the most part, css and images anyway. The problem I have now is that some of the documents have a cfcart on them, these present the same problems as the css and images but I'm not able to specify the path like that. Any ideas? Cheers mate, Rob -Original Message- From: Marcus Raphelt [mailto:[EMAIL PROTECTED] Sent: 09 September 2008 17:48 To: CF-Talk Subject: Re: cfdocument playing silly buggers on production. Hi, as far as I can remember, we solved this in a CF7 project by pointing to images using file:///-Links. Not very elegant, but it worked. bye, marcus Robert Rawlins schrieb: Does anyone know a work around for this? I'm sure it's something some of you have come across in the past. ~| 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:312247 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Railo 3 Released
Railo has just announced the release of their new major version Railo 3 You can check out the lastest features over on the Railo website http://www.railo.ch/blog/index.cfm/2008/9/9/Railo-30-released--Features-part-1 Some really cool stuff those guys in Switzerland are doing! Gary Gilbert http://www.garyrgilbert.com/blog ~| 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:312248 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: xml include not working
Richard, It is not an event handler so should not go in that section - try it right under your opening modelglue Dan On Tue, Sep 9, 2008 at 8:58 AM, Richard White [EMAIL PROTECTED] wrote: hi, i am trying to include one xml file into another can anyone tell me what i am doing wrong please: event-handlers include template=/re_base_mg/config/event_handlers/MainControllerEventHandlers.xml / /event-handlers i am getting no errors but when i run the page it cannot find the error handlers inside the MainControllerEventHandlers.xml file that i am trying to include - indicating that it is not including the xml file properly thanks richard ~| 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:312249 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ColdFusion navigation help
Hi guys I want to design a dynamic menu. For this purpose I written some cfc. cfcomponent hint=get main menu displayname=navigation cffunction name=mainMenu hint=Get the main menu returntype=query cfquery name=mainmenu datasource=cfelsunrise dbtype=ODBC select a.label,b.menuID from menu a inner join menufoundon b on a.menuId=b.menUId where b.foundON=0 /cfquery cfreturn mainmenu / /cffunction cffunction name=getChild hint=get the child menu output=false returntype=query cfargument name=menukey type=any required=yes cfquery name=child datasource=cfelsunrise dbtype=ODBC select a.label,b.menuID from menu a inner join menufoundon b on a.menuId=b.menUId where b.foundON=cfqueryparam cfsqltype=cf_sql_integer value=#menukey# /cfquery cfreturn child /cffunction /cfcomponent First Function get root menu , from there it passes rthe param to the second one which gets the child menu (each child can be a parant itself) Calling page !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd; html xmlns=http://www.w3.org/1999/xhtml; head meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 / titleUntitled Document/title /head body cfinvoke component=cfc.navigation method=mainMenu returnvariable=GetMenuHead /cfinvoke cfoutput cfloop query=GetMenuHead a href=?childID=#menuID##label#/abr / cfinvoke component=cfc.navigation method=getChild returnvariable=GetMenuItemRet cfinvokeargument name=menukey value=#menuID#/ /cfinvoke cfif GetMenuItemRet.recordcount gt 0 cfloop query=GetMenuItemRet a href=?childID=#menuID##label#/a /cfloop /cfif /cfloop /cfoutput /body /html On this page I only want to the root menu. After i click on the link it should take me to the child menu where i CAN CLICK ON THE iTEM AND IT SHOULD TAKE ME TO THE NEXT MENU. aND SO ON AND SO FORTH INstead I get All menu items listed on 1 screen Please help Thank you ~| 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:312250 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 navigation help
erik tom wrote: On this page I only want to the root menu. After i click on the link it should take me to the child menu where i CAN CLICK ON THE iTEM AND IT SHOULD TAKE ME TO THE NEXT MENU. aND SO ON AND SO FORTH Then don't loop over all the children and output them. Just output a single specified level. Of course you will need to pass something to the next request that tells your component what the new specified level is going to be so it can return the desired results for that value. ~| 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:312251 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 navigation help
erik tom wrote: On this page I only want to the root menu. After i click on the link it should take me to the child menu where i CAN CLICK ON THE iTEM AND IT SHOULD TAKE ME TO THE NEXT MENU. aND SO ON AND SO FORTH Then don't loop over all the children and output them. Just output a single specified level. Of course you will need to pass something to the next request that tells your component what the new specified level is going to be so it can return the desired results for that value. How can I do that . Shouid I use 1 more argument something like page. ~| 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:312252 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: xml include not working
hi, i have just joined the model glue group, thanks for the link also i tried your suggestion dan but also didnt work unfortunately :( thanks for your responses richard Richard, It is not an event handler so should not go in that section - try it right under your opening modelglue Dan ~| 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:312253 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfhttp and Google Search Appliance
Kevin I was trying this exact same thing last week and got the exact same error. I just tried your code and am still unable to login. Can you explain what it is you did to make it work? Steve Nelson Dave, thanks for your help but I finally got it to work. Just in case you are interested: !- !--- Expects URL.command --- !--- Export_Config --- !--- Import_Config Filename --- !--- Add_Collection CollectionID CollectionName? --- !--- Delete_Collection CollectionID --- !--- Function to check HTTP response for errors and print debug --- cffunction name=checkHttpStruct returnType=boolean cfargument name=httpStruct type=Struct required=yes cfargument name=stage type=String required=yes cfif LEN(httpStruct.errorDetail) GT 0 cfdump var=#httpStruct.errorDetail# label=#stage# ErrorBR cfreturn true /cfif cfdump var=#httpStruct# label=#stage# ResponseBR cfreturn false /cffunction !--- Initialize --- cfset Variables.error = False cfset Variables.googleWelcome = Google Mini gt; Home cfset Variables.adminUser = admin cfset Variables.adminPwd = blahblah !--- TBD HARDCODE get from db --- cfset Variables.googleIP = 192.168.0.20 !--- TBD HARDCODE Application.cfm --- !--- Set the URL for the google admin console --- cfset Variables.url = http://#Variables. googleIP#:8000/EnterpriseController !--- Send initial request to google. This is just to get a response --- cfhttp method=GET url=#Variables.url# useragent=#CGI. HTTP_USER_AGENT#/cfhttp cfset Variables.error = checkHttpStruct(CFHTTP, Initial Request) cfif NOT Variables.error !--- Get the cookie from the response object. This is the cookie that --- !--- we are going to echo back in subsequent CFHttp requests. --- !--- The google cookie will look like: S=enterprise=; --- !--- where is a unique key --- cfset Variables.googleCookie = ListGetAt(CFHTTP.Response.ResponseHeader[Set-Cookie],1,;) !--- Try to login --- cfhttp method=POST url=#Variables.url# useragent=#CGI. HTTP_USER_AGENT# cfhttpparam name=#Variables.googleCookie# type=COOKIE value=#Variables.googleCookie# cfhttpparam name=actionType type=URL value=authenticateUser cfhttpparam name=userName type=URLvalue=#Variables. adminUser# cfhttpparam name=password type=URLvalue=#Variables. adminPwd# /cfhttp cfset Variables.error = checkHttpStruct(CFHTTP, Login Request) /cfif cfif NOT Variables.error !--- Check if we have a successful login by looking for the google welcome on the admin main page --- cfif FindNoCase(#Variables.googleWelcome#, CFHTTP.Filecontent) EQ 0 cfoutputLogin Failed/cfoutputBR cfset Variables.error = True /cfif /cfif cfif NOT Variables.error cfoutputLogin Success/cfoutputBR cfif URL.command EQ Export_Config !--- Export Config --- cfhttp method=POST url=#Variables.url# useragent=#CGI. HTTP_USER_AGENT# cfhttpparam name=#Variables.googleCookie# type=COOKIE value=#Variables.googleCookie# cfhttpparam name=actionType type=URLvalue=importExport cfhttpparam name=export type=URLvalue=Export Configuration cfhttpparam name=password1 type=URLvalue=#Variables. adminPwd# cfhttpparam name=password2 type=URLvalue=#Variables. adminPwd# /cfhttp !--- TBD cfelseif URL.command EQ Import_Config cfelseif URL.command EQ Add_Collection cfelseif URL.command EQ Delete_Collection cfelse TBD --- /cfif cfset Variables.error = checkHttpStruct(CFHTTP, #URL.command#) !--- Log out --- cfhttp method=POST url=#Variables.url# useragent=#CGI. HTTP_USER_AGENT# cfhttpparam name=#Variables.googleCookie# type=COOKIE value=#Variables.googleCookie# cfhttpparam name=actionType type=URL value=logout /cfhttp cfset Variables.error = checkHttpStruct(CFHTTP, Logout Request) /cfif ~| 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:312254 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfhttp and Google Search Appliance
Oh my bad, your example was searching for the word Google Mini which isn't on the full appliance. Thanks Kevin you've cured my ulcer. Steve ~| 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:312255 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Two queries and an array
Hi all, I am trying to do the following and was wondering if any one could offer a solution. Currently I am returning to Flex a query from cf. I now want to extend this by running two queries, the first gets user details the second gets user results. Example Table One :: user_id, user_name Table Two :: result_id, user_id, user_score UserVO :: user_id:int, user_name:String, user_results:Array I then want to loop through the first query - create a new UserVO - create a new Array - loop the second query - get all user_score where queryOne.user_id EQ queryTwo.user_id - push the user_score into the array - push array to UserVO - return results as ?Query ?Array to Flex... Can I add each new UserVO to the first query and return that? or would it be best to simply add each UserVO to a new Array and return that? Any help would be great, Kind Regards, Simon ~| 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:312256 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
using dynamic variable in cfset statement
Why does this fail inside a cfoutput loop over a query: cfset application.#appconfig.code_name# = '#appconfig.code_value#' It generates this message: A CFML variable name cannot end with a . character. The variable application. ends with a . character. You must supply an additional structure key or delete the . character. ~| 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:312257 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: using dynamic variable in cfset statement
try cfset application[appconfig.code_name] = appconfig.code_value / On Tue, Sep 9, 2008 at 1:53 PM, Wally Randall [EMAIL PROTECTED]wrote: Why does this fail inside a cfoutput loop over a query: cfset application.#appconfig.code_name# = '#appconfig.code_value#' It generates this message: A CFML variable name cannot end with a . character. The variable application. ends with a . character. You must supply an additional structure key or delete the . character. ~| 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:312258 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: using dynamic variable in cfset statement
The variable application. ends with a . character. This looks to me like appconfig.code_name is an empty string. ~| 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:312259 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: using dynamic variable in cfset statement
Why does this fail inside a cfoutput loop over a query: cfset application.#appconfig.code_name# = '#appconfig.code_value#' It sounds like one of your code_name values is blank or null, resulting in an invalid variable name. -- Justin Scott, http://www.tlson.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:312260 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: using dynamic variable in cfset statement
Charlie has the idea. It's because you are referring to a variable contained within an structure and doing dynamic dot notation has it's issues and will not work in this case. -Pat On Tue, Sep 9, 2008 at 1:57 PM, Charlie Griefer [EMAIL PROTECTED]wrote: try cfset application[appconfig.code_name] = appconfig.code_value / On Tue, Sep 9, 2008 at 1:53 PM, Wally Randall [EMAIL PROTECTED] wrote: Why does this fail inside a cfoutput loop over a query: cfset application.#appconfig.code_name# = '#appconfig.code_value#' It generates this message: A CFML variable name cannot end with a . character. The variable application. ends with a . character. You must supply an additional structure key or delete the . character. ~| 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:312261 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: using dynamic variable in cfset statement
The variable application. ends with a . character. This looks to me like appconfig.code_name is an empty string. It is not an empty string. Also, the [] is an invalid constrict in coldfusion. ~| 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:312262 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: using dynamic variable in cfset statement
Why does this fail inside a cfoutput loop over a query: cfset application.#appconfig.code_name# = '#appconfig.code_value#' It has nothing to do with the query. To set a variable whose name isn't known until runtime, you have three options: 1. The syntax in Charlie's email - my preference out of the three 2. cfset application.#whatever# = whateverVal 3. cfset SetVariable(application.#whatever#, whateverVal) Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:312263 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: using dynamic variable in cfset statement
On Tue, Sep 9, 2008 at 2:01 PM, Wally Randall [EMAIL PROTECTED]wrote: Also, the [] is an invalid constrict in coldfusion. could you elaborate on that please? -- I have failed as much as I have succeeded. But I love my life. I love my wife. And I wish you my kind of success. ~| 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:312264 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: using dynamic variable in cfset statement
Also, the [] is an invalid constrict in coldfusion. That hasn't been true since CF 4. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:312265 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: using dynamic variable in cfset statement
So are you saying: cfset application[appconfig.code_name] = '#appconfig.code_value#' or even cfset application.#appconfig.code_name# = '#appconfig.code_value#' does not work? The second example with quotes around the set variable should also work I believe. -Pat On Tue, Sep 9, 2008 at 2:01 PM, Wally Randall [EMAIL PROTECTED]wrote: The variable application. ends with a . character. This looks to me like appconfig.code_name is an empty string. It is not an empty string. Also, the [] is an invalid constrict in coldfusion. ~| 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:312266 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: using dynamic variable in cfset statement
Not in this case. The []'s will work. On 9/9/08, Wally Randall [EMAIL PROTECTED] wrote: The variable application. ends with a . character. This looks to me like appconfig.code_name is an empty string. It is not an empty string. Also, the [] is an invalid constrict in coldfusion. ~| 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:312268 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: using dynamic variable in cfset statement
Wally Randall wrote: Why does this fail inside a cfoutput loop over a query: application. is an illegal variable name. To do this type of thing you need to use array notation. cfset application[appconfig.code_name] = appconfig.code_value ~| 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:312267 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: using dynamic variable in cfset statement
Would something like this work? cfset Evaluate(application.#appconfig.code_name#) = '#appconfig.code_value#' ~ David Moore _ Get more out of the Web. Learn 10 hidden secrets of Windows Live. http://windowslive.com/connect/post/jamiethomson.spaces.live.com-Blog-cns!550F681DAD532637!5295.entry?ocid=TXT_TAGLM_WL_domore_092008 ~| 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:312269 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: using dynamic variable in cfset statement
Ouch! Evaluate On Tue, Sep 9, 2008 at 2:15 PM, David Moore, Jr. [EMAIL PROTECTED]wrote: Would something like this work? cfset Evaluate(application.#appconfig.code_name#) = '#appconfig.code_value#' ~ David Moore _ Get more out of the Web. Learn 10 hidden secrets of Windows Live. http://windowslive.com/connect/post/jamiethomson.spaces.live.com-Blog-cns!550F681DAD532637!5295.entry?ocid=TXT_TAGLM_WL_domore_092008http://windowslive.com/connect/post/jamiethomson.spaces.live.com-Blog-cns%21550F681DAD532637%215295.entry?ocid=TXT_TAGLM_WL_domore_092008 ~| 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:312270 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: using dynamic variable in cfset statement
Also, the [] is an invalid constrict in coldfusion. well, if appconfig.code_name is an empty string, then [appconfig.code_name] will be equivalent to [], which is an invalid constrict in coldfusion. If I were you, I'll really make sure appconfig.code_name is not an empty string ;-) Just try this: CFOUTPUT[#appconfig.code_name#]/CFOUTPUT ~| 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:312271 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: using dynamic variable in cfset statement
hehe :) On Tue, Sep 9, 2008 at 2:18 PM, Patrick Santora [EMAIL PROTECTED] wrote: Ouch! Evaluate On Tue, Sep 9, 2008 at 2:15 PM, David Moore, Jr. [EMAIL PROTECTED] wrote: Would something like this work? cfset Evaluate(application.#appconfig.code_name#) = '#appconfig.code_value#' ~ David Moore _ Get more out of the Web. Learn 10 hidden secrets of Windows Live. http://windowslive.com/connect/post/jamiethomson.spaces.live.com-Blog-cns!550F681DAD532637!5295.entry?ocid=TXT_TAGLM_WL_domore_092008http://windowslive.com/connect/post/jamiethomson.spaces.live.com-Blog-cns%21550F681DAD532637%215295.entry?ocid=TXT_TAGLM_WL_domore_092008 http://windowslive.com/connect/post/jamiethomson.spaces.live.com-Blog-cns%21550F681DAD532637%215295.entry?ocid=TXT_TAGLM_WL_domore_092008 ~| 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:312272 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: using dynamic variable in cfset statement
I just love giving you guys something to laugh at ... Rag the newbie... It's OK. At least I am learning, and trying. :) hehe :) Ouch! Evaluate _ See how Windows Mobile brings your life togetherat home, work, or on the go. http://clk.atdmt.com/MRT/go/msnnkwxp1020093182mrt/direct/01/ ~| 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:312273 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: using dynamic variable in cfset statement
It's sometimes the best and fastest way to learn :-). Evaluate works, it's just not really recommended Ouch. ;-) On Tue, Sep 9, 2008 at 2:27 PM, David Moore, Jr. [EMAIL PROTECTED]wrote: I just love giving you guys something to laugh at ... Rag the newbie... It's OK. At least I am learning, and trying. :) hehe :) Ouch! Evaluate _ See how Windows Mobile brings your life togetherat home, work, or on the go. http://clk.atdmt.com/MRT/go/msnnkwxp1020093182mrt/direct/01/ ~| 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:312274 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: using dynamic variable in cfset statement
On Tue, Sep 9, 2008 at 4:53 PM, Wally Randall [EMAIL PROTECTED]wrote: Why does this fail inside a cfoutput loop over a query: cfset application.#appconfig.code_name# = '#appconfig.code_value#' It generates this message: A CFML variable name cannot end with a . character. The variable application. ends with a . character. You must supply an additional structure key or delete the . character. Just throwing something out here since you are mentioning that you are doing this by looping over a query. You could set all of those appconfig variables by looping over the column names. cfloop index=ColumnName list=#appconfig.ColumnList# cfset APPLICATION.appconfig.#ColumnName# = appconfig[#ColumnName#] /cfloop ~| 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:312275 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: using dynamic variable in cfset statement
hey i was laughing at patrick laughing at you, not laughing at you directly, so it's ok :) serious face there's probably not one of us on this list that didn't used to use evaluate() before being taught to look at other alternatives (and i'm sure some who still do use it). it's all good. participating is how you learn. keep doing what you're doing. /serious face :) On Tue, Sep 9, 2008 at 2:27 PM, David Moore, Jr. [EMAIL PROTECTED]wrote: I just love giving you guys something to laugh at ... Rag the newbie... It's OK. At least I am learning, and trying. :) hehe :) Ouch! Evaluate _ See how Windows Mobile brings your life togetherat home, work, or on the go. http://clk.atdmt.com/MRT/go/msnnkwxp1020093182mrt/direct/01/ ~| 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:312276 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: using dynamic variable in cfset statement
laughingIt's kind of like a right of passage/laughing It just looks to tempting to use sometimes :-) Well said Charlie. On Tue, Sep 9, 2008 at 2:33 PM, Charlie Griefer [EMAIL PROTECTED]wrote: hey i was laughing at patrick laughing at you, not laughing at you directly, so it's ok :) serious face there's probably not one of us on this list that didn't used to use evaluate() before being taught to look at other alternatives (and i'm sure some who still do use it). it's all good. participating is how you learn. keep doing what you're doing. /serious face :) On Tue, Sep 9, 2008 at 2:27 PM, David Moore, Jr. [EMAIL PROTECTED] wrote: I just love giving you guys something to laugh at ... Rag the newbie... It's OK. At least I am learning, and trying. :) hehe :) Ouch! Evaluate _ See how Windows Mobile brings your life togetherat home, work, or on the go. http://clk.atdmt.com/MRT/go/msnnkwxp1020093182mrt/direct/01/ ~| 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:312277 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: using dynamic variable in cfset statement
Pat wrote: It's sometimes the best and fastest way to learn :-). Evaluate works, it's just not really recommended Ouch. ;-) Yes. It's just painful to the character of ones soul. I didn't know that about Evaluate. Glad I do know that...now. I wish there was an asterisks next to code somewhere that says, here's some code, but don't use this. It's really BAD. It works, but you shouldn't use it I mean, why is it there if you are not supposed to use it. It's like Eve and the apple all over again... ~ David _ See how Windows Mobile brings your life togetherat home, work, or on the go. http://clk.atdmt.com/MRT/go/msnnkwxp1020093182mrt/direct/01/ ~| 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:312278 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: using dynamic variable in cfset statement
Casey Dougall wrote: cfloop index=ColumnName list=#appconfig.ColumnList# cfset APPLICATION.appconfig.#ColumnName# = appconfig[#ColumnName#] /cfloop Or the same thing with a few less pound signs and quotes. cfset Application['appconfig'][ColumnName] = appconfig[ColunName] Or to completely eliminate the loop, but then you will be working with a record set rather then a simple structure. cfset application.appconfig = appconfig ~| 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:312279 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: using dynamic variable in cfset statement
Charlie wrote: hey i was laughing at patrick laughing at you, not laughing at you directly, so it's ok :) Oh, I'm cool. I worked in Radio for 15 years as a DJ, so I don't expect a whole lot out of myself. I thought it was funny too. :) ~David _ Want to do more with Windows Live? Learn 10 hidden secrets from Jamie. http://windowslive.com/connect/post/jamiethomson.spaces.live.com-Blog-cns!550F681DAD532637!5295.entry?ocid=TXT_TAGLM_WL_domore_092008 ~| 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:312280 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: using dynamic variable in cfset statement
Yeah, but it never stops. We still laugh at Will T. every chance we get. ..:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Patrick Santora [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 09, 2008 5:38 PM To: CF-Talk Subject: Re: using dynamic variable in cfset statement laughingIt's kind of like a right of passage/laughing It just looks to tempting to use sometimes :-) Well said Charlie. On Tue, Sep 9, 2008 at 2:33 PM, Charlie Griefer [EMAIL PROTECTED]wrote: hey i was laughing at patrick laughing at you, not laughing at you directly, so it's ok :) serious face there's probably not one of us on this list that didn't used to use evaluate() before being taught to look at other alternatives (and i'm sure some who still do use it). it's all good. participating is how you learn. keep doing what you're doing. /serious face :) On Tue, Sep 9, 2008 at 2:27 PM, David Moore, Jr. [EMAIL PROTECTED] wrote: I just love giving you guys something to laugh at ... Rag the newbie... It's OK. At least I am learning, and trying. :) hehe :) Ouch! Evaluate _ See how Windows Mobile brings your life together?at home, work, or on the go. http://clk.atdmt.com/MRT/go/msnnkwxp1020093182mrt/direct/01/ ~| 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:312281 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
IIS integrated security and homesite problems
I recently turned on integrated authorization on IIS 6.0, in an attempt to use the CGI.AUTH_USER variable to detect the logged-in user based on the domain login. I am now having problems with HomeSite in that I get an intermittent request to login, with an occasional Remote Server Operation Failure indicating access denied due to bad credentials in the WWW-Authenticate header field. I am not sure why this would be happening when I am using RDS? Anyone have any insights on why this might be happening, and how to fix it? Remarks about switching to eclipse would not be particularly helpful at this point. TNX for any comments. Rick Colman ~| 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:312282 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Error Executing Database Query Connection reset errors.
Recently we migrated our database server to a separate machine. This machine was on a separate standalone IP (our hosting company could not allow the two machines to be networked together), which we can connect via CF datasource. The website works fine and is actually faster than before when everything was on one machine. However, during the course of a day we get about 20 errors such as the one shown below: We average about a few thousand requests per day, and except for these errors everything seems fine with the site. These errors happen randomly at any page â it is not limited to any particular page so we cannot even replicate this issue. Is there something we can do to fix this? Is this look like a JDBC driver issue or a network issue? Our webserver does have to make an outgoing requests to the database server through the same network card â could this be an issue. It does not look like the card is maxed out though. Any help would be appreciated. We are running CF 8 standard edition, and SQL 2005 standard. Our webserver machine is a Intel Xeon P4 2.8ghz with 2Gb RAM running Windows 2003 server. Our database server is a Intel Xeon 3 Ghz with 2 Gb memory.running windows 2003 server with service pack 2. error type: coldfusion.runtime.CfErrorWrapper root cause: coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. Error Executing Database Query. Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server. brThe error occurred on line 65. CF_WORKERTHREAD COLUMN - 0 TEMPLATE - Server returned RAW_TRACE - Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server. ~| 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:312283 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: IIS integrated security and homesite problems
I am now having problems with HomeSite in that I get an intermittent request to login, with an occasional Remote Server Operation Failure indicating access denied due to bad credentials in the WWW-Authenticate header field. I am not sure why this would be happening when I am using RDS? RDS is sent over HTTP, so if you're requiring HTTP authentication generally, your RDS connection will require it too. That may or may not work in various RDS clients. I know it used to work in CF Studio, but I haven't used that in a long time. In theory, you should be able to disable HTTP authentication for RDS by ensuring that you can get to this URL without authentication: /CFIDE/Main/ide.cfm Since that's not an actual file, you may need to create the file and directory just so you can control it from IIS. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:312284 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 navigation help
well, your link passes a ChilID url var - you can use that. wrap your second cfinvoke into a cfif checking for existence of url.childid. Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ erik tom wrote: How can I do that . Shouid I use 1 more argument something like page. ~| 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:312285 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Two queries and an array
Assuming that you're sticking with passing back value objects, I would think an array would make more sense than a query... But in general, not knowing what this is being used for, it sounds like it's probably overcomplicated for what your flex application is likely to do with the data. Just a guess, but from looking at the variable names it looks like you're displaying a list of users with a sum or average score for each user? (like a forum with an awards system) Not sure why you would want Flex to receive an array of scores for each user, rather than simply returning a query with an total_score or avg_score column - would be orders of magnitude faster and less complicated. Of course if I've mis-guessed about the purpose of the code, just ignore my comments. :) -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 781.769.0723 http://onTap.riaforge.org/blog ~| 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:312286 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4