C8 + Vista Ultimate 64bit - Can't Install
Hi all, I give up. I need some help here. I'm trying to install the Developer Edition of CF 8 (64 bit edition) on my Vista Ultimate 64 bit laptop. Here the environment CF 8.01 Win 64 JVM 6.12 Dell XPS M1530, 6 GB RAM, Windows Ultimate 64-bit OS When I run the exe file (as Administrator), the InstallAnywhere does its thing, then CF 8 splash screen appears, I hit OK and it seems to extract the files. After about three quarters, I get an error message: Fatal Application Error This Applicatoin has Unexpectedly Quit Invocation of this Java Application has caused an Innvocation TargetException. This application will now exit. (LAX) I have repeatedly downloaded the installer, tried the 32-bit installer (same error), made sure I had the latest JVM and emptied (as well as possible) the Windows Temp folder. No success. What am I doing wrong? Thanks Adrian ~| 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:319784 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: C8 + Vista Ultimate 64bit - Can't Install
Typical. When you send out a help request, you get to solve the problem yourself. The issue was as follows: I deleted a default folder, when I set up the folder structure to my liking. Problem was, that this folder was coded into the Windows registry. I changed the path in the registry to an existing 'generic' folder and...tataaait works. This has been logged as a bug with Adobe, by the way. a. ~| 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:319785 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Creating a variable to store information on the fly
When I try with this the coding style you gave me, I get the following error: The form field SESSION.consumerProductExtraImg.Img1 did not contain a file. The error occurred in C:\ColdFusion8\wwwroot\e-Ghana\process_UpLoadExtraConsumerProductImages.cfm: line 26 24 : filefield=SESSION.consumerProductExtraImg.Img1 25 : destination= #upLoadDestination# 26 : nameconflict=makeunique It seems the session variable is being created but the assignment is not being done Try this: cfset SESSION.consumerProductExtraImg[Img#i#] = filename Adrian ~| 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:319786 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Creating a variable to store information on the fly
This method also seems to create the session variable, but assignment fails. The error is: The form field SESSION.consumerProductExtraImg.Img1 did not contain a file. The error occurred in C:\ColdFusion8\wwwroot\e-G try this: cfset SESSION.consumerProductExtraImg[Img i] = filename Fawzi Amadu ha scritto: ~| 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:319787 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ajax and special characters
hi we are developing an Ajax based system using JavaScript and Coldfusion. we have only just started to realise the need for escaping / encoding special characters. how do you guys deal with this, e.g: 1) how do we deal with the special characters in JavaScript to ensure that Coldfusion receives them correctly 2) how does Coldfusion decode them to read them exactly how they were sent 3) how does Coldfusion send them back encoded to ensure JavaScript receives them OK 4) how does JavaScript then decode them when it receives them i would appreciate any advice on where to start looking and any tutorials there may be to understand this. 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;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319788 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ajax and special characters
If, when making your Ajax calls, you pass the returnFormat = JSON attribute to your CFC method, then CF will automatically encode the result when creating the JSON output. When passing a JSON value to ColdFusion, inside your CFC method you can use the DeserializeJson() method to decode the value. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of Learning Ext JS http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com Richard White wrote: hi we are developing an Ajax based system using JavaScript and Coldfusion. we have only just started to realise the need for escaping / encoding special characters. how do you guys deal with this, e.g: 1) how do we deal with the special characters in JavaScript to ensure that Coldfusion receives them correctly 2) how does Coldfusion decode them to read them exactly how they were sent 3) how does Coldfusion send them back encoded to ensure JavaScript receives them OK 4) how does JavaScript then decode them when it receives them i would appreciate any advice on where to start looking and any tutorials there may be to understand this. 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;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319789 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Fwd: Long Text Buffer (chr) question...
Hey all, this was sent to me by one of the other developers in our group... Can anyone address this? Thanks sas Original Message Subject:Long Text Buffer (chr) question... Date: Wed, 25 Feb 2009 10:04:23 -0500 From: Brian Horkey To: Scott Stewart Hi Scott, I was just wondering what the impact of increasing the Coldfusion admin setting Long Text Buffer (chr) from 64k to 2 megs. Is this feature have an impact on performance? or is it simply a throttle for performance abuse? I was just curious. Feel free to post if you would like. Thanks! -Brian -- Scott Stewart ColdFusion Developer Office of Research Information Systems Research amp; Economic Development University of North Carolina at Chapel Hill Phone:(919)843-2408 Fax: (919)962-3600 Email: saste...@email.unc.edu ~| 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:319790 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
js validation
how to pull 2 fiels from database when you enter account number in edit form which is already entered into database by other. Thanks 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:319791 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: js validation
Take a look at jQuery. $(function() { $(selector for your input).blur(function() { $.post(check-exists.cfm, {theFormField: $(this.val()), function(data) { alert(data); // See what the response was and act accordingly }}) }); }); The above is waiting for a change in the form field, sending the value to a CF page, the result of this is available in data. Have a play about with it, see what you find. Adrian -Original Message- From: Priya Koya [mailto:priya23...@gmail.com] Sent: 25 February 2009 16:14 To: cf-talk Subject: js validation how to pull 2 fiels from database when you enter account number in edit form which is already entered into database by other. Thanks 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:319792 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Bind question on cfselect
Hey guys i have a text field that i display if 'other' is selected in a cfselect visible={product_present.selectedItem.data == '10'} but this only works if 'other' is the only selection or if 'other' is the last thing selected. i basically need a Contains or IN operator instead of the == any 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:319793 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ajax and special characters
In addition to Cutter's points about JSON encoding, look into the URLEncodedFormat and URLDecode. -Original Message- From: Cutter (CFRelated) [mailto:cold.fus...@cutterscrossing.com] Sent: Wednesday, February 25, 2009 8:34 AM To: cf-talk Subject: Re: ajax and special characters If, when making your Ajax calls, you pass the returnFormat = JSON attribute to your CFC method, then CF will automatically encode the result when creating the JSON output. When passing a JSON value to ColdFusion, inside your CFC method you can use the DeserializeJson() method to decode the value. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of Learning Ext JS http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com Richard White wrote: hi we are developing an Ajax based system using JavaScript and Coldfusion. we have only just started to realise the need for escaping / encoding special characters. how do you guys deal with this, e.g: 1) how do we deal with the special characters in JavaScript to ensure that Coldfusion receives them correctly 2) how does Coldfusion decode them to read them exactly how they were sent 3) how does Coldfusion send them back encoded to ensure JavaScript receives them OK 4) how does JavaScript then decode them when it receives them i would appreciate any advice on where to start looking and any tutorials there may be to understand this. 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;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319794 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Bind question on cfselect
this work for multiple with 10 selected! (product_present.selectedItems[1].data == '10' so how do i do the OR visible={product_present.selectedItem.data == '10' OR product_present.selectedItems[1].data == '10'} On Wed, Feb 25, 2009 at 11:34 AM, Paul Ihrig pih...@gmail.com wrote: Hey guys i have a text field that i display if 'other' is selected in a cfselect visible={product_present.selectedItem.data == '10'} but this only works if 'other' is the only selection or if 'other' is the last thing selected. i basically need a Contains or IN operator instead of the == any 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:319795 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
HTML possibly CSS weirdness.
Ok all my CFML is working just fine. I am building a table but I have two views of it. One view is optimized for the screen and the other for printing. I am using basic css media = screen|print functionality to indicate which is which. The weirdness I am experiencing is that my large, multiple page table designed for the print view, pushes itself to a second page before starting. So my print out looks something like this. TITLE OF REPORT . . . {rest of first page is blank} . . . --second page-- first page of table . . . --third page-- rest of table . . . Why is the table not starting right after the report title which is a h1 tag? Is there any thing I can do to enforce it to do so. P.S. I am experiencing this behavior in my Firefox browser. TIA Ian ~| 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:319796 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Error: FIle Not Found
Hi All, I am using COldFusion8 and trying to execute the file but error: File not found: /File1.cfm My project is in path: C:\Inetpub\Project_Folder\somefile.cfm I have created a .cfm page in the path: C:\Inetpub\Project_Folder\folder1\File1.cfm. Any Suggestions? ~| 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:319797 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (sot) CF and Section 508 compliance a 508 compliant date/time picker
Thank you Sandra for the tute. Good stuff. I would also like thank everyone for their assistance. I have a good handle on things. I was a bit confused by the JS aspect. The language in the actual specs is a bit hazy. Again, thanx! G! On Fri, Feb 20, 2009 at 7:43 PM, Sandra Clark slli...@shayna.com wrote: A good tutorial to start with would be http://jimthatcher.com/webcourse1.htm Basically, your site has to work with Javascript turned off. Check things by using just the keyboard, I've audited sites with date widgets where yes, the text could be entered manually, but the keyboard hit the date picker first and there was no way to tab out of it. Sandra Clark = http://www.shayna.com Training and Consulting in CSS and Accessibility Team Fusebox -Original Message- From: Gerald Guido [mailto:gerald.gu...@gmail.com] Sent: Friday, February 20, 2009 1:22 PM To: cf-talk Subject: (sot) CF and Section 508 compliance a 508 compliant date/time picker We just picked up a site that needs to be 508 compliant. I am getting a crash course right now. I (or any of us really) never made a site/app that needed to be 508 compliant. My only concern is the use of JS. It is basically a data entry and reporting app and there is going to be a TON of form fields. We plan to use JS for form validation (CFForm and/or other means if need be) and was wondering if using CFForm will be an issue. Yes I know... we shouldn't use CFForm etc.. but it is uber-crunch time and that is what our code generator spits out. Along the lines of validation, will we need server side validation as well? Also.. Does anyone know of any 508 compliant date/time pickers? Those are going to be the only JS widgets that may be an issue. And lastly, anyone care to pass on any general advice or gotchas and/or advice on that to be aware of and/or be careful of etc. As always, many TIA. G! -- Gerald Guido http://www.myinternetisbroken.com To invent, you need a good imagination and a pile of junk. -- Thomas A. Edison ~| 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:319798 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: HTML possibly CSS weirdness.
Definitely a CSS issue. I'm assuming you are using the print/screen @mediatype correctly. In your @print CSS you can try adding: H1 {page-break-after: avoid;} table {page-break-before: avoid;} That may help. If not, I'd be happy to take a quick look at the CSS to see if any sticks out. Hope that helps. Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| 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:319799 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Client IP changes on SSL- tricks load balancer
OK, I'm having troubles with session management on one of my sites which is mostly in HTTP but switches over to HTTPS when the user checks out and enters their credit card info, etc. What is happening is that occasionally people will get the your session expired message at the point that they redirect to the https URLs. This site uses 3 CF 8 servers in stand-alone mode behind a hardware firewall. What is happening is the client's IP address changes as soon as they hit the https pages on our site. I can only assume their corporation uses some special proxy for SSL traffic. When this happens, my loadbalancer doesn't seem to recognize them and ships them off to a different server where their session doesn't exist. The company hosting the load balancer has told me that it doesn't base session on IP address. Furthermore there is a cookie set on each client that says what web server they are on and the load balancer is supposed to be using that cookie to keep them on the correct server. (this isn't happening) I guess my questions are: 1) Can anyone confirm seeing the behavior of changing IP addresses over SSL? 2) Has anyone had it screw with their load balancer like I am seeing? 3) Aren't cookies encrypted over SSL anyway-- so how would my load balancer even see the cookies in the request? 4) Suggestions? Thanks. ~Brad ~| 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:319800 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HTML possibly CSS weirdness.
Robert Harrison wrote: Definitely a CSS issue. I'm assuming you are using the print/screen @mediatype correctly. In your @print CSS you can try adding: H1 {page-break-after: avoid;} table {page-break-before: avoid;} That may help. If not, I'd be happy to take a quick look at the CSS to see if any sticks out. Hope that helps. Thanks that seemed to have helped. ~| 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:319801 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Client IP changes on SSL- tricks load balancer
Are you sure something else is not going on dealing with domain cookies? If I come into a site as http://example.com and browse around - getting sesssionID in the process and tied to a cookie, then I hit a URL http://www.example.com That's a different domain Unless you are hitting the same application with same domain you will get a new cookie... Or you need to have domain cookies set on on (cfapplication ... setDomainCookies=yes ...). -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: b...@bradwood.com [mailto:b...@bradwood.com] Sent: Wednesday, February 25, 2009 11:37 AM To: cf-talk Subject: Client IP changes on SSL- tricks load balancer OK, I'm having troubles with session management on one of my sites which is mostly in HTTP but switches over to HTTPS when the user checks out and enters their credit card info, etc. What is happening is that occasionally people will get the your session expired message at the point that they redirect to the https URLs. This site uses 3 CF 8 servers in stand-alone mode behind a hardware firewall. What is happening is the client's IP address changes as soon as they hit the https pages on our site. I can only assume their corporation uses some special proxy for SSL traffic. When this happens, my loadbalancer doesn't seem to recognize them and ships them off to a different server where their session doesn't exist. The company hosting the load balancer has told me that it doesn't base session on IP address. Furthermore there is a cookie set on each client that says what web server they are on and the load balancer is supposed to be using that cookie to keep them on the correct server. (this isn't happening) I guess my questions are: 1) Can anyone confirm seeing the behavior of changing IP addresses over SSL? 2) Has anyone had it screw with their load balancer like I am seeing? 3) Aren't cookies encrypted over SSL anyway-- so how would my load balancer even see the cookies in the request? 4) Suggestions? Thanks. ~Brad ~| 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:319802 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
How can I find my session variables from an asynchronous post?
I am using PayPal and it will be posting me asynchronously to confirm payment, so I don't think I will have direct access to my session variables. I would like to do something to use them from server memory rather than having to create a temporary file and pass its record id around. Is there something I can do to recover my session variables after I am posted? Perhaps pass the session id along and if so, how can I use it to get my variables? ~| 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:319803 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Error: FIle Not Found
/File1.cfm must be located in your site root, so Project_Folder must be defined as the site root. What does the line of code say that is throwing the File not found error? It may be that the function you are calling requires a file system path. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of Learning Ext JS http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com Priya Koya wrote: Hi All, I am using COldFusion8 and trying to execute the file but error: File not found: /File1.cfm My project is in path: C:\Inetpub\Project_Folder\somefile.cfm I have created a .cfm page in the path: C:\Inetpub\Project_Folder\folder1\File1.cfm. Any Suggestions? ~| 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:319804 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Client IP changes on SSL- tricks load balancer
That's a good question Mark. We are not using domain cookies, but I can confirm that all the requests in question are hitting the same domain. I can also confirm that the loss of session is a direct result of the load balancer moving them from one server to another where their session no longer exists. ~Brad Original Message Subject: RE: Client IP changes on SSL- tricks load balancer From: Mark Kruger mkru...@cfwebtools.com Date: Wed, February 25, 2009 11:50 am To: cf-talk cf-talk@houseoffusion.com Are you sure something else is not going on dealing with domain cookies? ~| 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:319805 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFPDF import vector graphcis
Thanks for the update. Are you using EPS for the vector graphics? Are the results what you would expect from using vector graphics, such as a smaller file size and higher quality graphics when printing? I am curious about the details regarding dropping EPS support from the PDF spec and the ramifications of this. My assumption is that this is related to PDF becoming and open standard. Im wondering if PDFs with vector graphics have any troubles in non-Adobe PDF readers. -Mike Chabot On Tue, Feb 24, 2009 at 7:01 PM, Guru cfexp...@gmail.com wrote: Update: I end up using activepdf tool to import vector pdfs, CFPDF does not support this functionality. On Sat, Feb 14, 2009 at 3:28 PM, Guru cfexp...@gmail.com wrote: Couldn't find it anywhere so thought to ask. I have couple of illustrator files (which can be export to EPS on any other vector format). I am building dynamic PDF file using CFPDF tag and want to have this EPS or illustrator graphic import in my pdf. How can I do that? is there any sample out there? can someone please post the link? 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:319806 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Error: FIle Not Found
This is what the error I get: File not found: /FIle1.cfm Resources: - Check the ColdFusion documentationhttp://www.macromedia.com/go/proddoc_getdocto verify that you are using the correct syntax. - Search the Knowledge Basehttp://www.macromedia.com/support/coldfusion/to find a solution to your problem. Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727; InfoPath.2; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729) Remote Address 127.0.0.1 ReferrerDate/Time 25-Feb-09 12:22 PM Stack Trace (click to expand)javascript:; coldfusion.runtime.TemplateNotFoundException: File not found: /EditSites.cfm at coldfusion.filter.PathFilter.invoke(PathFilter.java:89) at coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:27) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) On Wed, Feb 25, 2009 at 12:00 PM, Cutter (CFRelated) cold.fus...@cutterscrossing.com wrote: /File1.cfm must be located in your site root, so Project_Folder must be defined as the site root. What does the line of code say that is throwing the File not found error? It may be that the function you are calling requires a file system path. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of Learning Ext JS http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com Priya Koya wrote: Hi All, I am using COldFusion8 and trying to execute the file but error: File not found: /File1.cfm My project is in path: C:\Inetpub\Project_Folder\somefile.cfm I have created a .cfm page in the path: C:\Inetpub\Project_Folder\folder1\File1.cfm. Any Suggestions? ~| 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:319807 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Error: FIle Not Found
Priya, This still doesn't show us the line of code calling that file. This would determine the type of path you require. A cffile tag, for instance, would require a system path to the resource (c:\Inetpub\etc), whereas the cfinclude tag would require something like a relative path (template=/File1.cfm). Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of Learning Ext JS http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com Priya Koya wrote: This is what the error I get: File not found: /FIle1.cfm Resources: - Check the ColdFusion documentationhttp://www.macromedia.com/go/proddoc_getdocto verify that you are using the correct syntax. - Search the Knowledge Basehttp://www.macromedia.com/support/coldfusion/to find a solution to your problem. Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727; InfoPath.2; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729) Remote Address 127.0.0.1 ReferrerDate/Time 25-Feb-09 12:22 PM Stack Trace (click to expand)javascript:; coldfusion.runtime.TemplateNotFoundException: File not found: /EditSites.cfm at coldfusion.filter.PathFilter.invoke(PathFilter.java:89) at coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:27) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) On Wed, Feb 25, 2009 at 12:00 PM, Cutter (CFRelated) cold.fus...@cutterscrossing.com wrote: /File1.cfm must be located in your site root, so Project_Folder must be defined as the site root. What does the line of code say that is throwing the File not found error? It may be that the function you are calling requires a file system path. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of Learning Ext JS http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com Priya Koya wrote: Hi All, I am using COldFusion8 and trying to execute the file but error: File not found: /File1.cfm My project is in path: C:\Inetpub\Project_Folder\somefile.cfm I have created a .cfm page in the path: C:\Inetpub\Project_Folder\folder1\File1.cfm. Any Suggestions? ~| 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:319808 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Bind question on cfselect
think i got is visible={(product_present.selectedItem.data == '10') || (product_present.selectedItems[1].data == '10')} ~| 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:319809 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Client IP changes on SSL- tricks load balancer
It is possible that the user has a different proxy for http than for https - this would possibly give you a different IP for http vs https. There are not many really good reasons to do that, so it's somewhat unlikely, but possible. That's a good question Mark. We are not using domain cookies, but I can confirm that all the requests in question are hitting the same domain. I can also confirm that the loss of session is a direct result of the load balancer moving them from one server to another where their session no longer exists. ~Brad Are you sure something else is not going on dealing with domain cookies? ~| 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:319810 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Client IP changes on SSL- tricks load balancer
It is possible that the user has a different proxy for http than for https - this would possibly give you a different IP for http vs https. There are not many really good reasons to do that, so it's somewhat unlikely, but possible. That's a good question Mark. We are not using domain cookies, but I can confirm that all the requests in question are hitting the same domain. I can also confirm that the loss of session is a direct result of the load balancer moving them from one server to another where their session no longer exists. ~Brad Are you sure something else is not going on dealing with domain cookies? ~| 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:319811 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Beginning Flex
I'm just starting with Flex and I'm totally discombobulated. I've been doing ColdFusion for about 10 years, using Homesite, then CF Studio, and now Dreamweaver to develop stuff on remote servers (I work from home). Now I'm trying to get started with Flex and I'm completely confused as to how you can develop stuff remotely. Is it just not possible? Do you develop it locally and then just move the swf file to the server? What about the remote data connection? How do I connect to my CFCs on the remote server? How am I supposed to compile stuff if my local computer is not a web server? The SDK install instructions say: Ensure that the Java Runtime Environment (JRE) is installed on the computer and that the java_home/bin directory is defined in the system path. JRE 1.4, 1.5, or 1.6 is required. For 1.4, JRE 1.4.2_06 or later is required. How would I even find out if JRE is running on my laptop? I'm just.lost. Can y'all pretend I am a total idiot explain this to me with very small words, pretty please? Jen Perkins Adobe Certified ColdFusion Developer Senior Developer, iArchitects http://www.iarchitects.com/ http://www.iarchitects.com iArchitects :: Your Internet Solutions Team Architecting Internet Solutions since 1999 ~| 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:319812 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Beginning Flex
I'm just starting with Flex and I'm totally discombobulated. I've been doing ColdFusion for about 10 years, using Homesite, then CF Studio, and now Dreamweaver to develop stuff on remote servers (I work from home). Now I'm trying to get started with Flex and I'm completely confused as to how you can develop stuff remotely. Is it just not possible? Do you develop it locally and then just move the swf file to the server? You don't generally do remote development. You're compiling an application, and you do that on your local workstation. You then copy the SWF to the server. What about the remote data connection? How do I connect to my CFCs on the remote server? You invoke them as web services using WebService, or you invoke them through Flash Remoting using RemoteObject. WebService and RemoteObject are Flex components. How am I supposed to compile stuff if my local computer is not a web server? You don't need a web server to compile your SWF. You may want to install a web server and CF to run your CFCs for development and testing, but it's not required. The SDK install instructions say: Ensure that the Java Runtime Environment (JRE) is installed on the computer and that the java_home/bin directory is defined in the system path. JRE 1.4, 1.5, or 1.6 is required. For 1.4, JRE 1.4.2_06 or later is required. How would I even find out if JRE is running on my laptop? How do you find out if a program is installed, generally? You can check for environment variables in Windows by typing set at a command prompt. I'm just.lost. Can y'all pretend I am a total idiot explain this to me with very small words, pretty please? Honestly, if you're this lost, I'd strongly recommend that you either buy a Flex book or take a course. Since I'm a Flex instructor, I may be a bit biased in favor of the latter, but it seems to me that you may need more answers than a mailing list will likely provide. Speaking of mailing lists, you may want to join some Flex lists, like the cf-flex list here or flexcod...@yahoo.com. 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 inform ~| 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:319813 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Beginning Flex
I'm just.lost. Can y'all pretend I am a total idiot explain this to me with very small words, pretty please? Can do ;) get started with Flex I would HIGHLY recommend the Lynda.com Flex 3 Essential Training and Beyond the Basics (BTB) series. http://www.lynda.com/home/DisplayCourse.aspx?lpk2=438 http://www.lynda.com/home/DisplayCourse.aspx?lpk2=437 I am in the middle of Flex Essential Training right now and it will get you up to speed quickly using (to the best of my knowledge) best practices. I have been going through Lynda's CF8 BTB and it is spot on. High quality stuff delivered in manageable chunks. All I can say is that I wish I had known about it when I started off using CFC's and learning OO CF. For $25 per month you really can't beat the online training library in terms of bang for the buck (Provided you have a high speed connection). HTH G! On Wed, Feb 25, 2009 at 2:12 PM, Jen Perkins snarkmeis...@gmail.com wrote: I'm just.lost. Can y'all pretend I am a total idiot explain this to me with very small words, pretty please? -- Gerald Guido http://www.myinternetisbroken.com To invent, you need a good imagination and a pile of junk. -- Thomas A. Edison ~| 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:319814 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Client IP changes on SSL- tricks load balancer
1) Can anyone confirm seeing the behavior of changing IP addresses over SSL? I haven't seen this with SSL specifically, but there's nothing special about SSL in this case - just like HTTP, HTTPS is stateless. 3) Aren't cookies encrypted over SSL anyway-- so how would my load balancer even see the cookies in the request? Yes, cookies, like every other part of the HTTP request and response, are encrypted over SSL. However, most load balancers can host SSL certificates, so that the connection between the client and the load balancer is over SSL, but the connection between the load balancer and your web servers would be unencrypted. This has several advantages over using certificates on the individual web servers. In this case, of course, the load balancer could inject cookies into the request or response as appropriate. 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;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319815 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Beginning Flex
I'll second Linda, the library there is HUGE and the content is quite good. As Gerald said, for $25 you really can't beat that, even if you only go through one track a month. On Wed, Feb 25, 2009 at 2:43 PM, Gerald Guido gerald.gu...@gmail.comwrote: I'm just.lost. Can y'all pretend I am a total idiot explain this to me with very small words, pretty please? Can do ;) get started with Flex I would HIGHLY recommend the Lynda.com Flex 3 Essential Training and Beyond the Basics (BTB) series. http://www.lynda.com/home/DisplayCourse.aspx?lpk2=438 http://www.lynda.com/home/DisplayCourse.aspx?lpk2=437 I am in the middle of Flex Essential Training right now and it will get you up to speed quickly using (to the best of my knowledge) best practices. I have been going through Lynda's CF8 BTB and it is spot on. High quality stuff delivered in manageable chunks. All I can say is that I wish I had known about it when I started off using CFC's and learning OO CF. For $25 per month you really can't beat the online training library in terms of bang for the buck (Provided you have a high speed connection). HTH G! On Wed, Feb 25, 2009 at 2:12 PM, Jen Perkins snarkmeis...@gmail.com wrote: I'm just.lost. Can y'all pretend I am a total idiot explain this to me with very small words, pretty please? -- Gerald Guido http://www.myinternetisbroken.com To invent, you need a good imagination and a pile of junk. -- Thomas A. Edison ~| 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:319816 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Beginning Flex
I'm with Dave and Gerald... As a Lifelong CF developer moving into Flex was extremely odd. Lynda.com has EXCELLENT training videos, but alot of your questions aren't really going to be answered there. I would recommend either paid instructor led training or joining your local Flex/Flash/Adobe User Group and try to pick some brains there. These mailing lists can be helpful, but it doesn't compare to the one on one interaction you need to get you over many of the early hurdles you will likely encounter in learning Flex. http://www.lynda.com http://groups.adobe.com =] On Wed, Feb 25, 2009 at 12:43 PM, Gerald Guido gerald.gu...@gmail.comwrote: I'm just.lost. Can y'all pretend I am a total idiot explain this to me with very small words, pretty please? Can do ;) get started with Flex I would HIGHLY recommend the Lynda.com Flex 3 Essential Training and Beyond the Basics (BTB) series. http://www.lynda.com/home/DisplayCourse.aspx?lpk2=438 http://www.lynda.com/home/DisplayCourse.aspx?lpk2=437 I am in the middle of Flex Essential Training right now and it will get you up to speed quickly using (to the best of my knowledge) best practices. I have been going through Lynda's CF8 BTB and it is spot on. High quality stuff delivered in manageable chunks. All I can say is that I wish I had known about it when I started off using CFC's and learning OO CF. For $25 per month you really can't beat the online training library in terms of bang for the buck (Provided you have a high speed connection). HTH G! On Wed, Feb 25, 2009 at 2:12 PM, Jen Perkins snarkmeis...@gmail.com wrote: I'm just.lost. Can y'all pretend I am a total idiot explain this to me with very small words, pretty please? -- Gerald Guido http://www.myinternetisbroken.com To invent, you need a good imagination and a pile of junk. -- Thomas A. Edison ~| 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:319817 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Client IP changes on SSL- tricks load balancer
In a hardware load-balanced environment, I have always used Client vars rather than Session. (Just make sure you store them in the DB, not in the Registry.) Basically, the Client vars are a contract between the browser and the application, whereas Session vars are a contract between the browser and the server. Since the application verifies a user's Client session by reading back to the shared database, it doesn't matter if the user shifts back and forth across servers in the cluster, whether going from www.example.com to example.com or from http: to https:, since the application always retrieves the 'correct' session. Now, I know that there is a big push in CF8 to stop using Client vars, but I will tell you that it does work quite well in the situation you describe. We ran apps, including many ecommerce apps, in a cluster of 4-5 hardware-balanced servers for years without having dropped session issues using Client vars. ~| 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:319818 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
question about CF admin
I was curious where all the CF admin settings are stored. Are they stored in the CFIDE folder or are they stored in the Coldfusion8 folder. I could swear I moved my CFIDE folder to a new CF server and it inherited the settings, but when I moved it a second time (rebuild the new CF server), the settings didn't migrate over. It *might* have also been because apache was sending me back over to the original cf server and I didn't know it... Am I missing something? Thanks, Mike ~| 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:319819 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: question about CF admin
In CF 5 or lower settings were in the registry. As of CFMX (version 6.x and higher) most settings are in /cfusion8/lib/ stored in XML files. Keep in mind that a few things you might need are in the jrun.xml file and the jvm.config file. -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Mike Soultanian [mailto:msoul...@csulb.edu] Sent: Wednesday, February 25, 2009 2:17 PM To: cf-talk Subject: question about CF admin I was curious where all the CF admin settings are stored. Are they stored in the CFIDE folder or are they stored in the Coldfusion8 folder. I could swear I moved my CFIDE folder to a new CF server and it inherited the settings, but when I moved it a second time (rebuild the new CF server), the settings didn't migrate over. It *might* have also been because apache was sending me back over to the original cf server and I didn't know it... Am I missing something? Thanks, Mike ~| 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:319820 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Client IP changes on SSL- tricks load balancer
Chris, that is my assumption of what is happening. Either that or their network has two gateways-- one for secure, and one for non-secure. Of course, the looming question is why it tricks my load balancer. ~Brad Original Message Subject: Re: Client IP changes on SSL- tricks load balancer From: Chris Kelly juggler...@gmail.com Date: Wed, February 25, 2009 1:05 pm To: cf-talk cf-talk@houseoffusion.com It is possible that the user has a different proxy for http than for https - this would possibly give you a different IP for http vs https. There are not many really good reasons to do that, so it's somewhat unlikely, but possible. ~| 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:319821 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: question about CF admin
Cool. Thanks for the info! MIke Mark Kruger wrote: In CF 5 or lower settings were in the registry. As of CFMX (version 6.x and higher) most settings are in /cfusion8/lib/ stored in XML files. Keep in mind that a few things you might need are in the jrun.xml file and the jvm.config file. ~| 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:319822 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
(ot) api to iLinc
Sorry for the ot, I'm wondering if anyone has done anything with api to iLinc. the iLinc site has none of that. Thanks. Don Chunshen Li ~| 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:319823 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Client IP changes on SSL- tricks load balancer
O On Wed, Feb 25, 2009 at 2:09 PM, Jason Fisher ja...@wanax.com wrote: In a hardware load-balanced environment, I have always used Client vars rather than Session. (Just make sure you store them in the DB, not in the Registry.) Basically, the Client vars are a contract between the browser and the application, whereas Session vars are a contract between the browser and the server. Since the application verifies a user's Client session by reading back to the shared database, it doesn't matter if the user shifts back and forth across servers in the cluster, whether going from www.example.com to example.com or from http: to https:, since the application always retrieves the 'correct' session. Now, I know that there is a big push in CF8 to stop using Client vars, but I will tell you that it does work quite well in the situation you describe. We ran apps, including many ecommerce apps, in a cluster of 4-5 hardware-balanced servers for years without having dropped session issues using Client vars. I would agree with this one the most. It seems to me that the session data is not being shared between CF instances, and when they hit https, the client is moved to another CF instance, which does not have their session information. speeves ~| 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:319824 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Client IP changes on SSL- tricks load balancer
Thanks for the info Dave. I didn't know the bit about load balancers hosting the certs. I'll have to ask our hosting company about the specific set up of our balancer. From my research, it seems that load balancers can use one (or more?) of the following methods to to determine which server should receive a request: 1) IP address of client 2) cookie 3) URL 4) SSL session id I don't know how my load balancer is configured yet (other than it is supposedly NOT using IP). If my LB is NOT hosting the secure cert, I'm actually having difficulty figuring out HOW it would track sessions correctly at the point when my user hit their first secure page after surfing the non-secure portion of the site. That very first secure request could potentially come across from an unknown IP with no identifiable cookies and a brand new SSL session id. The url and query string would also be encrypted too wouldn't it? I can't see how the load balancer would be able to recognize you unless it was hosting the cert, or unless there is some other way for the LB to decrypt the request. Perhaps someone could explain it to me since the inner workings of secure certs and LBs are sort of new to me. ~Brad 3) Aren't cookies encrypted over SSL anyway-- so how would my load balancer even see the cookies in the request? Yes, cookies, like every other part of the HTTP request and response, are encrypted over SSL. However, most load balancers can host SSL certificates, so that the connection between the client and the load balancer is over SSL, but the connection between the load balancer and your web servers would be unencrypted. This has several advantages over using certificates on the individual web servers. In this case, of course, the load balancer could inject cookies into the request or response as appropriate. ~| 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:319825 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Client IP changes on SSL- tricks load balancer
You are correct that session data cannot be replicated between stand-alone installs of ColdFusion. You are also correct in your assessment of why my user's sessions seem to disappear when they switch servers. Unfortunately, I know what is happening. What I don't know is how to prevent it. ~Brad Now, I know that there is a big push in CF8 to stop using Client vars, but I will tell you that it does work quite well in the situation you describe. We ran apps, including many ecommerce apps, in a cluster of 4-5 hardware-balanced servers for years without having dropped session issues using Client vars. I would agree with this one the most. It seems to me that the session data is not being shared between CF instances, and when they hit https, the client is moved to another CF instance, which does not have their session information. speeves ~| 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:319826 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Client IP changes on SSL- tricks load balancer
Jason, I do see how switching to client vars stored in the database would allow for my users to switch servers seamlessly. We are persisting quite a number of components in session and it's not an option at this point to begin marshaling the entire shopping cart and user information into a string and then unmarshalling it back out for the next request. (Even though I know it's possible) Perhaps we will look to that in the future, but in the mean time I think my solution needs to be getting my load balancer to recognize my sticky sessions. ~Brad Original Message Subject: Re: Client IP changes on SSL- tricks load balancer From: Jason Fisher ja...@wanax.com Date: Wed, February 25, 2009 2:09 pm To: cf-talk cf-talk@houseoffusion.com In a hardware load-balanced environment, I have always used Client vars rather than Session. (Just make sure you store them in the DB, not in the Registry.) Basically, the Client vars are a contract between the browser and the application, whereas Session vars are a contract between the browser and the server. Since the application verifies a user's Client session by reading back to the shared database, it doesn't matter if the user shifts back and forth across servers in the cluster, whether going from www.example.com to example.com or from http: to https:, since the application always retrieves the 'correct' session. Now, I know that there is a big push in CF8 to stop using Client vars, but I will tell you that it does work quite well in the situation you describe. We ran apps, including many ecommerce apps, in a cluster of 4-5 hardware-balanced servers for years without having dropped session issues using Client vars. ~| 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:319827 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfloop form fields
I want to loop form fields without using collection=#form# or list because I want to specify which fields to loop over and not the complete form. This is the syntax: cfoutput cfloop from=1 to=7 index=i cfset F_Name#i# =#Form.L_Name[i]# #F_Name[i]# br / /cfloop /cfoutput the code above produces this error msg: ColdFusion was looking at the following text: # Can someone help me with the proper syntax or method? thx 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:319828 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 can I find my session variables from an asynchronous post?
On the post back you can get them ~| 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:319829 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Access DB without datasource
I have a friend (yes really) who is working on a project that requires him to have an access database but he does not have access to the CF Administrator so he is wondering if there is a way around this. The only thing I could come up with is to attempt to either run the query with java or create the datasource with java (Context class). I thought I'd throw this out to the list to see if anyone has any other ideas. Thanks! -Jake ~| 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:319830 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Client IP changes on SSL- tricks load balancer
@Brad, I totally understand that issue of having large / complex session blocks and facing the potential of deep re-work. One thought in that vein, especially thinking forward to the potential performance shocks of running large sessions in memory: you may want to consider pushing more to the database and keeping very few ID elements in session as retrieval points rather than persisting entire carts in memory. I've done both, and it can work either way, so just a thought ... and one that doesn't address your immediate issue :( ~| 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:319831 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Tough SQL relationship
I have a tough nut to crack of a SQL report. First off, this is against a Oracle 11ge database if that matters. I have two tables. Table A use_no (key) county rec_type 1 1 X 3 1 X 4 1 Y 5 2 X 6 2 X 7 2 Y 10 2 Y TableB use_no (key) dup_set 1A 2A 7B 8B 9B I am trying to join these together so I can make a report that looks like this. county rec_type records record_with_dups 1 X 2 3 1 Y 1 1 2 X 2 2 2 Y 2 4 But I have no idea how to join these table together to accomplish 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:319832 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 can I find my session variables from an asynchronous post?
On the post back you can get them ? How ?? Maybe I'm missing something but it was my understanding that the POST would not think it is running my application so it would not have the variables. ~| 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:319833 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfloop form fields
Try this: cfoutput cfloop from=1 to=7 index=i cfset variables[F_Name#i#] = Form[L_Name i] #variables[F_Name#i#]# br / /cfloop /cfoutput I think that's what you're looking for. I used variables scope simply to more easily use the struct notation of struct[varName] in the output. You could as easily do: cfset F_Name#i# = Form[L_Name i] ~| 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:319834 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Access DB without datasource
Jake, He may be able to use this approach. http://www.coldfusionmuse.com/index.cfm/2005/6/3/dsn_cfmx Basically it uses ANY Access DSN that is previously set up as a proxy. So you set up just one in the DSN and it serves as a proxy for any access files you wish to put on the server. FYI (I shouldn't say this) but previous versions shipped with an installed access DB already set up for - cfsnippets I think. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Jake Churchill [mailto:jake.church...@gmail.com] Sent: Wednesday, February 25, 2009 3:35 PM To: cf-talk Subject: Access DB without datasource I have a friend (yes really) who is working on a project that requires him to have an access database but he does not have access to the CF Administrator so he is wondering if there is a way around this. The only thing I could come up with is to attempt to either run the query with java or create the datasource with java (Context class). I thought I'd throw this out to the list to see if anyone has any other ideas. Thanks! -Jake ~| 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:319835 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Client IP changes on SSL- tricks load balancer
Thanks for the notes. I've actually wondered what the overhead of serializing and de-serializing things for storage in client (or some other database solution) is. As well as the the possible performance implications of the amount of read and write activity that database table would be receiving. ~Brad Original Message Subject: Re: Client IP changes on SSL- tricks load balancer From: Jason Fisher ja...@wanax.com Date: Wed, February 25, 2009 3:40 pm To: cf-talk cf-talk@houseoffusion.com @Brad, I totally understand that issue of having large / complex session blocks and facing the potential of deep re-work. One thought in that vein, especially thinking forward to the potential performance shocks of running large sessions in memory: you may want to consider pushing more to the database and keeping very few ID elements in session as retrieval points rather than persisting entire carts in memory. I've done both, and it can work either way, so just a thought ... and one that doesn't address your immediate issue :( ~| 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:319836 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFHTTP and SSL v3
I had read it in several blog postings but nothing definitive from Adobe. I've done some more checking and it appears you are right about it working for CF7. Now if only the authorize.net test site was up to date I could test my apps. Cheers Mike Michael, I had about concluded that 6 and 7 actually DO support 3.0. Can you tell me what docs indicated otherwise? -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com I got the same email from Authorize.net. We are using CFMX7 and from what I have read it doesn't support ssl 3.0 via cfhttp. If anyone has a quick solution I'd appreciate it. Likewise if I find one I'll let everyone know. Thanks Mike I got an email a while ago from Authorize.net that they have set up the test server with ssl 2.0 disabled and only ssl 3.0 enabled. and they provided all the information. To be sure i checked that using serversslsniffer and ssl 2.0 ciphers were disabled. and For SSL 3.0 only 128 bit and above ciphers were supported. So now i have tested one app that i have moved from cf5 to cf8 and it connected fine as expected. :) Now is the strange thing : I tested another app that is in cf5 and is yet to be ported to cf 8.0. Strangely that app also connected fine to the new SSL 3.0 Testing server. This is going above my head now. Docs say cfhttp in cf 5 only supports up to 56 bit. Going by that it should not have connected. Both cf5 app and cf8 apps are on different servers and both have ssl 2.0 disabled anyways. Any ideas?? what going on here. Do i port the other cf5 app?? ~Amit ~| 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:319837 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Beginning Flex
Before shelling out for lynda check out the Flex in a week videos: http://www.adobe.com/devnet/flex/videotraining/ And the adobe tv videos: http://tv.adobe.com/#pd+Flex The lynda training does seem to be very good, and it's probably still worth paying for, but I'd suggest running through those Adobe videos first - why look a gift horse in the mouth? Cheers Will -Original Message- From: Alan Rother [mailto:alan.rot...@gmail.com] Sent: 25 February 2009 19:51 To: cf-talk Subject: Re: Beginning Flex I'm with Dave and Gerald... As a Lifelong CF developer moving into Flex was extremely odd. Lynda.com has EXCELLENT training videos, but alot of your questions aren't really going to be answered there. I would recommend either paid instructor led training or joining your local Flex/Flash/Adobe User Group and try to pick some brains there. These mailing lists can be helpful, but it doesn't compare to the one on one interaction you need to get you over many of the early hurdles you will likely encounter in learning Flex. http://www.lynda.com http://groups.adobe.com =] On Wed, Feb 25, 2009 at 12:43 PM, Gerald Guido gerald.gu...@gmail.comwrote: I'm just.lost. Can y'all pretend I am a total idiot explain this to me with very small words, pretty please? Can do ;) get started with Flex I would HIGHLY recommend the Lynda.com Flex 3 Essential Training and Beyond the Basics (BTB) series. http://www.lynda.com/home/DisplayCourse.aspx?lpk2=438 http://www.lynda.com/home/DisplayCourse.aspx?lpk2=437 I am in the middle of Flex Essential Training right now and it will get you up to speed quickly using (to the best of my knowledge) best practices. I have been going through Lynda's CF8 BTB and it is spot on. High quality stuff delivered in manageable chunks. All I can say is that I wish I had known about it when I started off using CFC's and learning OO CF. For $25 per month you really can't beat the online training library in terms of bang for the buck (Provided you have a high speed connection). HTH G! On Wed, Feb 25, 2009 at 2:12 PM, Jen Perkins snarkmeis...@gmail.com wrote: I'm just.lost. Can y'all pretend I am a total idiot explain this to me with very small words, pretty please? -- Gerald Guido http://www.myinternetisbroken.com To invent, you need a good imagination and a pile of junk. -- Thomas A. Edison ~| 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:319838 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Client IP changes on SSL- tricks load balancer
Can we back up a little, just for fun? :) Can you talk a little bit about how your app is set up? Here is my take on your description: Your loadbalancer hosts your service name, www.bradsapp.com and it routes traffic to www1.bradsapp.com www2.bradsapp.com and www3.bradsapp.com. The LB is configured to use sticky sessions so the client will stay with the backend it first is routed to. Your loadbalancer is not configured to use SSL acceleration so any SSL request is routed to a backend webserver which has the SSL configuration. (FWIW LB do not read cookies. They manage stickiness internally and route accordingly. Communication between server and browser ideally has nothing to do with this.) Your backends are each single server installs of CF with apache or IIS in front of them. They manage sessions, set cookies and retain the SSL conf. When clients go to http://www.bradsapp.com, their IP is one value. However when they make the switch to SSL, their IP address changes. This is evidenced in your logs. Can you do an nslookup to compare origins? Could the IP shown when SSL requests are made be that of the LB? Can you replicate this behavior from your machines/subnets or are your clients limited to one group who all access the app the same way? What LB is being used here? Who manages its config?Can you get a copy of its config as it pertains to your app? On Wed, Feb 25, 2009 at 16:40, Jason Fisher ja...@wanax.com wrote: @Brad, I totally understand that issue of having large / complex session blocks and facing the potential of deep re-work. One thought in that vein, especially thinking forward to the potential performance shocks of running large sessions in memory: you may want to consider pushing more to the database and keeping very few ID elements in session as retrieval points rather than persisting entire carts in memory. I've done both, and it can work either way, so just a thought ... and one that doesn't address your immediate issue ~| 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:319839 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFHTTP and SSL v3
Hmmm Very interesting... CF 5 uses an ipswitch com or something to make HTTP connections ... Or is it something native to windows through the stack? -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Amit Talwar [mailto:talwar.a...@gmail.com] Sent: Wednesday, February 25, 2009 3:53 PM To: cf-talk Subject: Re: CFHTTP and SSL v3 I had read it in several blog postings but nothing definitive from Adobe. I've done some more checking and it appears you are right about it working for CF7. Now if only the authorize.net test site was up to date I could test my apps. Cheers Mike Michael, I had about concluded that 6 and 7 actually DO support 3.0. Can you tell me what docs indicated otherwise? -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com I got the same email from Authorize.net. We are using CFMX7 and from what I have read it doesn't support ssl 3.0 via cfhttp. If anyone has a quick solution I'd appreciate it. Likewise if I find one I'll let everyone know. Thanks Mike I got an email a while ago from Authorize.net that they have set up the test server with ssl 2.0 disabled and only ssl 3.0 enabled. and they provided all the information. To be sure i checked that using serversslsniffer and ssl 2.0 ciphers were disabled. and For SSL 3.0 only 128 bit and above ciphers were supported. So now i have tested one app that i have moved from cf5 to cf8 and it connected fine as expected. :) Now is the strange thing : I tested another app that is in cf5 and is yet to be ported to cf 8.0. Strangely that app also connected fine to the new SSL 3.0 Testing server. This is going above my head now. Docs say cfhttp in cf 5 only supports up to 56 bit. Going by that it should not have connected. Both cf5 app and cf8 apps are on different servers and both have ssl 2.0 disabled anyways. Any ideas?? what going on here. Do i port the other cf5 app?? ~Amit ~| 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:319840 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFHTTP and SSL v3
All right... I just tested this myself and sure enough, CF 5 handles a TLS1.0 connection on a Windows 2000 box. Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: Wednesday, February 25, 2009 4:12 PM To: cf-talk Subject: RE: CFHTTP and SSL v3 Hmmm Very interesting... CF 5 uses an ipswitch com or something to make HTTP connections ... Or is it something native to windows through the stack? -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Amit Talwar [mailto:talwar.a...@gmail.com] Sent: Wednesday, February 25, 2009 3:53 PM To: cf-talk Subject: Re: CFHTTP and SSL v3 I had read it in several blog postings but nothing definitive from Adobe. I've done some more checking and it appears you are right about it working for CF7. Now if only the authorize.net test site was up to date I could test my apps. Cheers Mike Michael, I had about concluded that 6 and 7 actually DO support 3.0. Can you tell me what docs indicated otherwise? -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com I got the same email from Authorize.net. We are using CFMX7 and from what I have read it doesn't support ssl 3.0 via cfhttp. If anyone has a quick solution I'd appreciate it. Likewise if I find one I'll let everyone know. Thanks Mike I got an email a while ago from Authorize.net that they have set up the test server with ssl 2.0 disabled and only ssl 3.0 enabled. and they provided all the information. To be sure i checked that using serversslsniffer and ssl 2.0 ciphers were disabled. and For SSL 3.0 only 128 bit and above ciphers were supported. So now i have tested one app that i have moved from cf5 to cf8 and it connected fine as expected. :) Now is the strange thing : I tested another app that is in cf5 and is yet to be ported to cf 8.0. Strangely that app also connected fine to the new SSL 3.0 Testing server. This is going above my head now. Docs say cfhttp in cf 5 only supports up to 56 bit. Going by that it should not have connected. Both cf5 app and cf8 apps are on different servers and both have ssl 2.0 disabled anyways. Any ideas?? what going on here. Do i port the other cf5 app?? ~Amit ~| 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:319841 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Client IP changes on SSL- tricks load balancer
Original Message Subject: Re: Client IP changes on SSL- tricks load balancer From: Maureen Barger m...@cornell.edu Your loadbalancer hosts your service name, www.bradsapp.com and it routes traffic to www1.bradsapp.com www2.bradsapp.com and www3.bradsapp.com. Pretty much yes, except we do not have separate DNS entries for each server right now (www1, www2 etc) The LB is configured to use sticky sessions so the client will stay with the backend it first is routed to. Yes. Your loadbalancer is not configured to use SSL acceleration so any SSL request is routed to a backend webserver which has the SSL configuration. From my understanding, yes but I'm not positive. (FWIW LB do not read cookies. They manage stickiness internally and route accordingly. Communication between server and browser ideally has nothing to do with this.) This has not been my understanding. I have understood that LB's DO manage sessions internally, but they _can_ inspect the cookies in the requests to do so. It has also been my understanding that LB's can add their own cookies into the requests for this purpose. http://www.ssl-technology.com/ssl_persistence.htm Your backends are each single server installs of CF with apache or IIS in front of them. They manage sessions, set cookies and retain the SSL conf. Yes. IIS to be exact. When clients go to http://www.bradsapp.com, their IP is one value. However when they make the switch to SSL, their IP address changes. Correct. This is evidenced in your logs. Yes. I log each page request made to my server, the IP address, and most of the CGI scope. Can you do an nslookup to compare origins? I have done whois lookups at www.netsol.com to confirm their origins and they have always belonged to the same company or organization. In once instance, both ips belonged to a military network. In today's instance, btoh IP addresses belonged to Verizon Wireless's network. (A Verizon Wireless employee was the person experiencing the problem today) Could the IP shown when SSL requests are made be that of the LB? No. Can you replicate this behavior from your machines/subnets Doubtful. I'm not sure how to do it firstly, and secondly, my office building only has one external gateway (IP) for the traffic to originate. or are your clients limited to one group who all access the app the same way? No, my clients can be anyone in the US or Canada. What LB is being used here? Radware. That's all I know at this point. Who manages its config? A hosting company who manages our racks in space purchased from a data center. Can you get a copy of its config as it pertains to your app? I can try, but I'm new here and traditionally the LB's have been a hands-off thing for the CF guy. ~Brad ~| 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:319842 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Apache Configuration Question.
Is it possible to have the same virtual host block respond to more then one url host header and|or ip:port? Ideally at least one of each. What I'm shooting for here, is we are building a new production box, we don't control our DSN server, another state agancy does and it is a very formal process to request additions or updates to them. Until that request goes through we plan to configure our virtual hosts to respond to requests from different ports so we can go ahead and test them and continue our work on building the box. But it would be really nice if you can go ahead and also configure the various virtual hosts to respond the url host headers that we know they will eventually be configured to use. So that we don't have to go back and tweak the files once the request to the agency that controls the DSN server goes through. Is that possible? In other words is there some way to combine these two forms of virtual host definitions: PORT BASED --- Listen 333.444.555.666: Listen 333.444.555.666: NameVirtualHost 333.444.555.666: NameVirtualHost 333.444.555.666: VirtualHost 333.444.555.666: ... /VirtualHost VirtualHost 333.444.555.666: ... /VirtualHost HOST HEADER -- Listen 333.444.555.80 NameVirtualHost calpip-staging:80 NameVirtualHost appprod-admin:80 VirtualHost calpip-staging:80 ServerName calpip-staging.cdpr.ca.gov ServerAlias calpip-staging ... /VirtualHost VirtualHost appprod-admin:80 ServerName appprod-admin.cdpr.ca.gov ServerAlias appprod-admin ... /VirtualHost ~| 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:319843 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Apache Configuration Question.
Yeah, you bet. Just set the list of IP/ports in the VirtualHost directive (space separated), and add necessary ServerAliases: VirtualHost 192.168.100.251:80 192.168.100.252:80 ServerName www.mentor.com ServerAlias mentor.com ServerAlias origin.mentor.com cheers, barenyb On Wed, Feb 25, 2009 at 2:26 PM, Ian Skinner h...@ilsweb.com wrote: Is it possible to have the same virtual host block respond to more then one url host header and|or ip:port? Ideally at least one of each. What I'm shooting for here, is we are building a new production box, we don't control our DSN server, another state agancy does and it is a very formal process to request additions or updates to them. Until that request goes through we plan to configure our virtual hosts to respond to requests from different ports so we can go ahead and test them and continue our work on building the box. But it would be really nice if you can go ahead and also configure the various virtual hosts to respond the url host headers that we know they will eventually be configured to use. So that we don't have to go back and tweak the files once the request to the agency that controls the DSN server goes through. Is that possible? In other words is there some way to combine these two forms of virtual host definitions: PORT BASED --- Listen 333.444.555.666: Listen 333.444.555.666: NameVirtualHost 333.444.555.666: NameVirtualHost 333.444.555.666: VirtualHost 333.444.555.666: ... /VirtualHost VirtualHost 333.444.555.666: ... /VirtualHost HOST HEADER -- Listen 333.444.555.80 NameVirtualHost calpip-staging:80 NameVirtualHost appprod-admin:80 VirtualHost calpip-staging:80 ServerName calpip-staging.cdpr.ca.gov ServerAlias calpip-staging ... /VirtualHost VirtualHost appprod-admin:80 ServerName appprod-admin.cdpr.ca.gov ServerAlias appprod-admin ... /VirtualHost ~| 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:319844 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Tough SQL relationship
Maybe I need glasses, but I missing something here. The first three report columns look like a count(*) from tableA by use_no and county. What is the tie-in with TableB and the record_with_dups column? county rec_type records record_with_dups 1 X 2 3 1 Y 1 1 2 X 2 2 2 Y 2 4 ~| 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:319845 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Apache Configuration Question.
Barney Boisvert wrote: Yeah, you bet. Just set the list of IP/ports in the VirtualHost directive (space separated), and add necessary ServerAliases: VirtualHost 192.168.100.251:80 192.168.100.252:80 ServerName www.mentor.com ServerAlias mentor.com ServerAlias origin.mentor.com cheers, barenyb Thanks, I felt it should be possible. Before I go and confuse myself with the Apache HTTPD documentation. Could you provide a little more guidance on what is the difference between 'ServerName' and 'ServerAlias'. Is there something different in the various 'ServerName' properties of multiple VirtualHost blocks in the same HTTPD file? How would the above VirtualHost would be preceded by Listen and|or NameVirtualHost commands? TIA Ian ~| 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:319846 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Tough SQL relationship
C S wrote: Maybe I need glasses, but I missing something here. The first three report columns look like a count(*) from tableA by use_no and county. What is the tie-in with TableB and the record_with_dups column? Yes, that is exactly what the first three columns are; a count of records grouped by County and then rec_type. The tie-in with TableB is that this table contains other records that are suspected to be duplicates of records that where put into TableA. When this happens all records that comprise a duplicate set are inserted into table B and identified by sharing a value key in the 'dup_set' field. The goal in the forth column is to include all these additional records into the count. county rec_type records record_with_dups 1 X 2 3 1 Y 1 1 2 X 2 2 2 Y 2 4 ~| 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:319847 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Apache Configuration Question.
ServerName sets the name for the server (as you'd expect). There can be only one per server. ServerAlias sets up additional non-canonical names for the server that it will pay attention to. There can be any number per server. You have to have a Listen for every ip/port you want to respond to. You'll have to have a NameVirtualHost for every ip/port that you want to serve multiple vhosts from, based on host headers. cheers, barneyb On Wed, Feb 25, 2009 at 3:08 PM, Ian Skinner h...@ilsweb.com wrote: Barney Boisvert wrote: Yeah, you bet. Just set the list of IP/ports in the VirtualHost directive (space separated), and add necessary ServerAliases: VirtualHost 192.168.100.251:80 192.168.100.252:80 ServerName www.mentor.com ServerAlias mentor.com ServerAlias origin.mentor.com cheers, barenyb Thanks, I felt it should be possible. Before I go and confuse myself with the Apache HTTPD documentation. Could you provide a little more guidance on what is the difference between 'ServerName' and 'ServerAlias'. Is there something different in the various 'ServerName' properties of multiple VirtualHost blocks in the same HTTPD file? How would the above VirtualHost would be preceded by Listen and|or NameVirtualHost commands? TIA Ian ~| 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:319848 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Tough SQL relationship
On Thu, Feb 26, 2009 at 12:12 AM, Ian Skinner wrote: Yes, that is exactly what the first three columns are; a count of records grouped by County and then rec_type. The tie-in with TableB is that this table contains other records that are suspected to be duplicates of records that where put into TableA. When this happens all records that comprise a duplicate set are inserted into table B and identified by sharing a value key in the 'dup_set' field. The goal in the forth column is to include all these additional records into the count. I think something like ((A join B on use_no) join A on county) union A will effectively merge both table so you have all records full complete in the result. Then you can window / partition that for yout record_with_dups column. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| 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:319849 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Tough SQL relationship
I think something like ((A join B on use_no) join A on county) union A will effectively merge both table so you have all records full complete in the result. Then you can window / partition that for yout record_with_dups column. Jochem I am still wrapping my head around it. But from what I grasp so far ;-) very slick idea. Leigh ~| 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:319850 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfloop form fields
Yes! That did the trick. Thank you! Try this: cfoutput cfloop from=1 to=7 index=i cfset variables[F_Name#i#] = Form[L_Name i] #variables[F_Name#i#]# br / /cfloop /cfoutput I think that's what you're looking for. I used variables scope simply to more easily use the struct notation of struct[varName] in the output. You could as easily do: cfset F_Name#i# = Form[L_Name i] ~| 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:319851 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Beginning Flex
Thanks everyone! I'm running through the Flex in a week videos now (thanks a bunch, Will!) and planning on buying a book or two on Amazon. Unfortunately I don't think in-person training will work at this time (small company, small budget, bad economy...plus, surprisingly few training options in the bay area, apparently). Can anyone recommend a good book for n00bs? I'm thinking of picking up the Flex for Dummies; I love the format of those books. Any other strong recommendations? Jen Perkins Adobe Certified ColdFusion Developer Senior Developer, iArchitects http://www.iarchitects.com iArchitects :: Your Internet Solutions Team Architecting Internet Solutions since 1999 -Original Message- From: Will Swain [mailto:w...@hothorse.com] Sent: Wednesday, February 25, 2009 2:01 PM To: cf-talk Subject: RE: Beginning Flex Before shelling out for lynda check out the Flex in a week videos: http://www.adobe.com/devnet/flex/videotraining/ And the adobe tv videos: http://tv.adobe.com/#pd+Flex The lynda training does seem to be very good, and it's probably still worth paying for, but I'd suggest running through those Adobe videos first - why look a gift horse in the mouth? Cheers Will -Original Message- From: Alan Rother [mailto:alan.rot...@gmail.com] Sent: 25 February 2009 19:51 To: cf-talk Subject: Re: Beginning Flex I'm with Dave and Gerald... As a Lifelong CF developer moving into Flex was extremely odd. Lynda.com has EXCELLENT training videos, but alot of your questions aren't really going to be answered there. I would recommend either paid instructor led training or joining your local Flex/Flash/Adobe User Group and try to pick some brains there. These mailing lists can be helpful, but it doesn't compare to the one on one interaction you need to get you over many of the early hurdles you will likely encounter in learning Flex. http://www.lynda.com http://groups.adobe.com =] On Wed, Feb 25, 2009 at 12:43 PM, Gerald Guido gerald.gu...@gmail.comwrote: I'm just.lost. Can y'all pretend I am a total idiot explain this to me with very small words, pretty please? Can do ;) get started with Flex I would HIGHLY recommend the Lynda.com Flex 3 Essential Training and Beyond the Basics (BTB) series. http://www.lynda.com/home/DisplayCourse.aspx?lpk2=438 http://www.lynda.com/home/DisplayCourse.aspx?lpk2=437 I am in the middle of Flex Essential Training right now and it will get you up to speed quickly using (to the best of my knowledge) best practices. I have been going through Lynda's CF8 BTB and it is spot on. High quality stuff delivered in manageable chunks. All I can say is that I wish I had known about it when I started off using CFC's and learning OO CF. For $25 per month you really can't beat the online training library in terms of bang for the buck (Provided you have a high speed connection). HTH G! On Wed, Feb 25, 2009 at 2:12 PM, Jen Perkins snarkmeis...@gmail.com wrote: I'm just.lost. Can y'all pretend I am a total idiot explain this to me with very small words, pretty please? -- Gerald Guido http://www.myinternetisbroken.com To invent, you need a good imagination and a pile of junk. -- Thomas A. Edison ~| 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:319852 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Coldfusion and windows UNC apache document root question
Hey Everyone, I moved all of my CF apps over to my file server and adjusted my Apache document roots and aliases over to the file server share via a UNC path (i.e. \\servername\share). I'm running into a problems where I'm getting a missing fusebox.xml error. I'm thinking this is a fusebox-specific error, but I thought I'd see if anyone has run into any weird issues relating to using Apache with their document root hosted on another server. Does this have to do with the fact that I'm using a UNC for the path in Apache (which is running on Windows 2003)? All of my other CF apps work fine so I'm guessing it's a fusebox issue related to the UNC path. Thanks, Mike ~| 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:319853 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Tough SQL relationship
Not sure about what the record_with_dups is exactly supposed to represent, but it looks like you want something along these lines: SELECT a.county, a.rec_type, COUNT(a.use_no) AS records, COUNT(b.dup_set) AS record_with_dups FROM [Table A] AS a LEFT OUTER JOIN [Table B] AS b ON a.use_no = b.use_no GROUP BY a.county, a.rec_type - 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:319854 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4