cfinput autosuggest list not correct
I have verified that the JSON being returned shows the correct values, but the values that the cfinput are displaying are only the people with a first name that starts with the value I have typed... cfinput type=text name=full_name id=full_name message=Start typing autosuggest=cfc:e.util.api.User.findUser({cfautosuggestvalue}) TIA Bill ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355303 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfinvoke and Proxy Auto Configuration
Configuration: So our ColdFusion 9.0.1 instance has a dedicated active directory account under which the ColdFusion services run. It has been granted internet access by the network guys, and the internet configuration has been setup with a proxy auto configuration script, as our proxy servers can change based on company needs, etc. Using this information, how do I setup cfinvoke to connect to an external web service? Thanks in advance ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354944 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: ColdFusion 10 - Web Service Proxy User Domain
So does that still work for Active Directory domains? e.g. ad/username = username@ad I ask because it isn't working either. Best regards, Bill Franklin Bayer CropScience LP Kansas City, MO, Tel: +1 816 242 2148 Fax: E-mail: bill.frank...@bayer.com Please visit our anniversary website: Bayer: 150 Years - Science For A Better Life -Original Message- From: Bill Moniz [mailto:hydro.b...@gmail.com] Sent: Friday, March 08, 2013 4:28 PM To: cf-talk Subject: Re: ColdFusion 10 - Web Service Proxy User Domain Use the other form of the domain username: usern...@domain.com That should work. On 9 March 2013 09:23, Bill Franklin bill.frank...@bayer.com wrote: I am trying to setup a webservice in CF Administrator. I get everything setup but when I try to specify the required domain with the username, it appears to break it...any help would be appreciated. For instance, I setup domain\username...it removes the \ and sets it to domainusername, which doesn't work. If I setup the domain\username in the cfinvoke proxyUser parameter, it works just fine. TIA ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354923 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: ColdFusion 10 - Web Service Proxy User Domain
Just to clarify, if I use the user@ad syntax in the cfinvoke call, it works fine too...but if I set the same way up in the CF Administrator, it doesn't Best regards, Bill Franklin Ext: Midwest Consulting Group, Inc. Bayer CropScience LP Kansas City, MO, Tel: +1 816 242 2148 Fax: E-mail: bill.frank...@bayer.com Please visit our anniversary website: Bayer: 150 Years - Science For A Better Life -Original Message- From: Bill Moniz [mailto:hydro.b...@gmail.com] Sent: Friday, March 08, 2013 4:28 PM To: cf-talk Subject: Re: ColdFusion 10 - Web Service Proxy User Domain Use the other form of the domain username: usern...@domain.com That should work. On 9 March 2013 09:23, Bill Franklin bill.frank...@bayer.com wrote: I am trying to setup a webservice in CF Administrator. I get everything setup but when I try to specify the required domain with the username, it appears to break it...any help would be appreciated. For instance, I setup domain\username...it removes the \ and sets it to domainusername, which doesn't work. If I setup the domain\username in the cfinvoke proxyUser parameter, it works just fine. TIA ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354925 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
ColdFusion 10 - Web Service Proxy User Domain
I am trying to setup a webservice in CF Administrator. I get everything setup but when I try to specify the required domain with the username, it appears to break it...any help would be appreciated. For instance, I setup domain\username...it removes the \ and sets it to domainusername, which doesn't work. If I setup the domain\username in the cfinvoke proxyUser parameter, it works just fine. TIA ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354906 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Looking for Homesite+
It would be nice if Adobe would opensource Homesite+ Freundliche Grüße / Best regards, Bill Franklin Computer Integrated Mfg. Bayer CropScience LP 8400 Hawthorne Road, Room 2447 Kansas City, MO 64120 Tel: +1 816 242 2148 Fax: +1 816 242 2047 E-mail: bill.frank...@bayer.com Web: http://www.bayercropscience.com Vorstand: Sandra E. Peterson, Vorsitzende | Lykele van der Broek, Achim Noack, Rüdiger Scheitza, Michael A. Schulz Vorsitzender des Aufsichtsrats: Werner Baumann Sitz der Gesellschaft: Monheim am Rhein | Eintragung: Amtsgericht Düsseldorf, HRB 46985 -Original Message- From: Michael Muller [mailto:ad...@montaguema.net] Sent: Thursday, August 16, 2012 11:01 AM To: cf-talk Subject: Looking for Homesite+ I recently bought a new laptop and am installing all my apps on it, until I realized I can't find my old Dreamweaver CD anymore. Homesite+ is my editor of choice. I know this is a really old program and everyone has moved on to new tools, but I really like Homesite+ and am used to all the hot key commands. Is there anywhere I can get this app without having to buy a copy of the old DW CD on eBay? I tried looking online but all I see are torrents that want to install all kinds of other crap on your machine. Thanks. Mik ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352174 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Force logout a user
Unless you are dealing only with machines on your LAN, I don't know of any reliable method to obtain the MAC of remote computers...also I believe there is an issue with MAC address re-use, so uniqueness isn't guaranteed. I doubt you'll find a solution that will work in 100% of the cases you could run across, unless you are dealing only with computers on a LAN. Freundliche Grüße / Best regards, Bill Franklin Computer Integrated Mfg. Bayer CropScience LP 8400 Hawthorne Road, Room 2447 Kansas City, MO 64120 Tel: +1 816 242 2148 Fax: +1 816 242 2047 E-mail: bill.frank...@bayer.com Web: http://www.bayercropscience.com Vorstand: Sandra E. Peterson, Vorsitzende | Lykele van der Broek, Achim Noack, Rüdiger Scheitza, Michael A. Schulz Vorsitzender des Aufsichtsrats: Werner Baumann Sitz der Gesellschaft: Monheim am Rhein | Eintragung: Amtsgericht Düsseldorf, HRB 46985 -Original Message- From: Uday Patel [mailto:udayjpatel2...@gmail.com] Sent: Wednesday, July 11, 2012 4:41 AM To: cf-talk Subject: Re: Force logout a user Hi, I want to force logout a user if he logs in on another machine. I am using CF9 and session scope to track user user logins. what are the possible ways of achieving this. Thanks in advance Hi, Thank you folks for your responses and suggestions. I spend my weekend playing around with this app on my personal network. This is what I did. maybe this helps someone. If you guys have some tips tricks suggestions, please let me know. I appreciate all you folks taking time to read and post messages. Objective : User should be able to login on only one machine. If he tries to login from another machine, his old session should be terminated. I am using cf sessions for the purpose of tracking user. Solutions provided: check user's IP address : This might not work very well. what is the user is inside a network, or behind a proxy. I know my ISP in canada keeps changing the IP address on my home network. As Cameron mentioned CFID/CFTOKEN and that this is one single best way to determine unique logins. and i agree with this. But what if user clears his cache in that case his browser will get new CFID/CFTOKEN from cf server. Roadblock: While i was playing around with this. I started thinking is there any way that we can get some information about user's machine, like his mac address(since we cannot rely on ip address, cfid's, coz these might change). I googled around with no luck and than came back to my app. But this is one thing that I will explore later on. What I did: I already had logins table in my db wherein i was making entry each time user logs in. I added two more columns here: logout_date and logout_by. These columns will be updated when a user logs out. He can click on logout button or he will be logged out on session end. I also created dead_session_array and put this in application scope. Here I will keep adding all dead sessions. (will explain this later) Scenario 1: User logs in on machine A. entry is made in logins table but logout_date and logout_by is empty. (If user clicks on logout i update these two columns. If session ends I have some code in onsessionend in application.cfc which will update these two columns. when coding inside onsessionend, make sure you read CF documentations. since onsessionend is a self triggered CF event only applicaiton and session scope is available inside via applicationscope and sessionscope). Now suppose user goes to machine B. CF will provide him with new CFID/CFTOKEN (sessionid). when he tries to login I will check in logins table and show him a message that this user already has a session open on another machine. Provide him with a button (something like 'logout old session and continue logging on this machine') When he clicks on this button I will update the logout_date and logout_by columns in logins table for this user and I will take this sessionid(of machine A which i got form logins table that i recorded when he logged on machine A) and I will add this sessionid in application.dead_session_array. So use succefully logs in on mahine B, I will make new entry in logins table with this new login data. Now when he goes to machine A and tries to do something. I will check if application.dead_session_array contains any sessionid. If it does and the sessionid matches with sessionid of machine A. logout this user simply by clearing his session scope. There was a good link about session scope by Ben Nadel http://www.bennadel.com/blog/1847-Explicitly-Ending-A-ColdFusion-Session.htm. clearing session scope does not mean that user logs out. It depends how you design your application. In my case I simply put useObj in session scope. clearing session scope will remove userObj from session scope. But people have diffferent ideas and different ways of doing this. Scenario 2: User logs in on machine A. I make an entry in logins table with logout_date and logout_by columns
RE: Force logout a user
Just validate their CGI.remote_host against what is already being used for a valid session...then force a logout of the oldest session if the same user logs on more than once from different IP Addresses Freundliche Grüße / Best regards, Bill Franklin Computer Integrated Mfg. Bayer CropScience LP 8400 Hawthorne Road, Room 2447 Kansas City, MO 64120 Tel: +1 816 242 2148 Fax: +1 816 242 2047 E-mail: bill.frank...@bayer.com Web: http://www.bayercropscience.com Vorstand: Sandra E. Peterson, Vorsitzende | Lykele van der Broek, Achim Noack, Rüdiger Scheitza, Michael A. Schulz Vorsitzender des Aufsichtsrats: Werner Baumann Sitz der Gesellschaft: Monheim am Rhein | Eintragung: Amtsgericht Düsseldorf, HRB 46985 -Original Message- From: Uday Patel [mailto:udayjpatel2...@gmail.com] Sent: Saturday, July 07, 2012 9:38 AM To: cf-talk Subject: Force logout a user Hi, I want to force logout a user if he logs in on another machine. I am using CF9 and session scope to track user user logins. what are the possible ways of achieving this. Thanks in advance ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351851 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Force logout a user
Surely checking only during your logon script would be smarter and more efficient than checking on EVERY REQUEST? I mean, how many times during a request does a user logon Freundliche Grüße / Best regards, Bill Franklin Computer Integrated Mfg. Bayer CropScience LP 8400 Hawthorne Road, Room 2447 Kansas City, MO 64120 Tel: +1 816 242 2148 Fax: +1 816 242 2047 E-mail: bill.frank...@bayer.com Web: http://www.bayercropscience.com Vorstand: Sandra E. Peterson, Vorsitzende | Lykele van der Broek, Achim Noack, Rüdiger Scheitza, Michael A. Schulz Vorsitzender des Aufsichtsrats: Werner Baumann Sitz der Gesellschaft: Monheim am Rhein | Eintragung: Amtsgericht Düsseldorf, HRB 46985 -Original Message- From: Cameron Childress [mailto:camer...@gmail.com] Sent: Friday, July 06, 2012 10:46 AM To: cf-talk Subject: Re: Force logout a user On Sat, Jul 7, 2012 at 10:38 AM, Uday Patel udayjpatel2...@gmail.comwrote: I want to force logout a user if he logs in on another machine. I am using CF9 and session scope to track user user logins. what are the possible ways of achieving this. Unique CF sessions are tracked using either CF's internal CFID/CFTOKEN or JSessionID as a unique session identifier, depending on how you have configured in in the administrator. These are typically stored as cookies in the visitors browser and are the single best way to determine unique logins. The visitor's IP address is not a reliable tacking mechanism and should NOT be used for this. The best/simplest way that I can think of to do this is that when the user logs into your website, store that session identifier (CFID/etc) in a database field along with that user's record in the database. Then, on each request, check that user's database record to see if the user's session identifier matches the one in the database. If it does not, log them out. This does require an extra DB hit with each request, and could be replaced by a mechanism that lives in another shared scope like the application scope, but that will require significantly more effort. If your app does not have heavy load, using the database for this should be fine. -Cameron -- Cameron Childress -- p: 678.637.5072 im: cameroncf facebook http://www.facebook.com/cameroncf | twitterhttp://twitter.com/cameronc | google+ https://profiles.google.com/u/0/117829379451708140985 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351854 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Charles Proxy and ColdFusion 9
I think the key problem here, is that ColdFusion 9 is returning the CFMLDebugger class, instead of the AMFDebugger class...perhaps a channel configuration issue??? Freundliche Grüße / Best regards, Bill Franklin Computer Integrated Mfg. Bayer CropScience LP 8400 Hawthorne Road, Room 2447 Kansas City, MO 64120 Tel: +1 816 242 2148 Fax: +1 816 242 2047 E-mail: bill.frank...@bayer.com Web: http://www.bayercropscience.com Vorstand: Sandra E. Peterson, Vorsitzende | Lykele van der Broek, Achim Noack, Rüdiger Scheitza, Michael A. Schulz Vorsitzender des Aufsichtsrats: Werner Baumann Sitz der Gesellschaft: Monheim am Rhein | Eintragung: Amtsgericht Düsseldorf, HRB 46985 -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Monday, April 23, 2012 3:57 PM To: cf-talk Subject: Re: Charles Proxy and ColdFusion 9 Actually, we don't output anything...ColdFusion handles it automatically for you. All we do is enable debugging output in CF Administrator Do you have the option to output query information checked as well? Also, I suspect that this might not work in CF 9 because having CFCs return something other than the specific output format of the CFC method result (JSON, XML, etc) could easily break the client. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350831 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Charles Proxy and ColdFusion 9
Anyone even use Charles Proxy? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350816 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Charles Proxy and ColdFusion 9
Are you able to see the SQL Query calls in firebug w/ CF9 as the back-end? Freundliche Grüße / Best regards, Bill Franklin Computer Integrated Mfg. Bayer CropScience LP 8400 Hawthorne Road, Room 2447 Kansas City, MO 64120 Tel: +1 816 242 2148 Fax: +1 816 242 2047 E-mail: bill.frank...@bayer.com Web: http://www.bayercropscience.com Vorstand: Sandra E. Peterson, Vorsitzende | Lykele van der Broek, Achim Noack, Rüdiger Scheitza, Michael A. Schulz Vorsitzender des Aufsichtsrats: Werner Baumann Sitz der Gesellschaft: Monheim am Rhein | Eintragung: Amtsgericht Düsseldorf, HRB 46985 -Original Message- From: Brian Thornton [mailto:br...@cfdeveloper.com] Sent: Monday, April 23, 2012 11:47 AM To: cf-talk Subject: Re: Charles Proxy and ColdFusion 9 Firebug does most of it so no not anymore. On Mon, Apr 23, 2012 at 12:45 PM, Bill Franklin bill.frank...@bayer.com wrote: Anyone even use Charles Proxy? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350819 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Charles Proxy and ColdFusion 9
Hence the use of Charles Proxy, which, up until ColdFusion 9, allowed us to see the SQL Queries that were run inside the CFC calls... Freundliche Grüße / Best regards, Bill Franklin Computer Integrated Mfg. Bayer CropScience LP 8400 Hawthorne Road, Room 2447 Kansas City, MO 64120 Tel: +1 816 242 2148 Fax: +1 816 242 2047 E-mail: bill.frank...@bayer.com Web: http://www.bayercropscience.com Vorstand: Sandra E. Peterson, Vorsitzende | Lykele van der Broek, Achim Noack, Rüdiger Scheitza, Michael A. Schulz Vorsitzender des Aufsichtsrats: Werner Baumann Sitz der Gesellschaft: Monheim am Rhein | Eintragung: Amtsgericht Düsseldorf, HRB 46985 -Original Message- From: Brian Thornton [mailto:br...@cfdeveloper.com] Sent: Monday, April 23, 2012 3:38 PM To: cf-talk Subject: Re: Charles Proxy and ColdFusion 9 No you wou;dn't be able to see that unless it was local dev and had firebug detector installed. On Mon, Apr 23, 2012 at 4:36 PM, Bill Franklin bill.frank...@bayer.com wrote: Are you able to see the SQL Query calls in firebug w/ CF9 as the back-end? Freundliche Grüße / Best regards, Bill Franklin Computer Integrated Mfg. Bayer CropScience LP 8400 Hawthorne Road, Room 2447 Kansas City, MO 64120 Tel: +1 816 242 2148 Fax: +1 816 242 2047 E-mail: bill.frank...@bayer.com Web: http://www.bayercropscience.com Vorstand: Sandra E. Peterson, Vorsitzende | Lykele van der Broek, Achim Noack, Rüdiger Scheitza, Michael A. Schulz Vorsitzender des Aufsichtsrats: Werner Baumann Sitz der Gesellschaft: Monheim am Rhein | Eintragung: Amtsgericht Düsseldorf, HRB 46985 -Original Message- From: Brian Thornton [mailto:br...@cfdeveloper.com] Sent: Monday, April 23, 2012 11:47 AM To: cf-talk Subject: Re: Charles Proxy and ColdFusion 9 Firebug does most of it so no not anymore. On Mon, Apr 23, 2012 at 12:45 PM, Bill Franklin bill.frank...@bayer.com wrote: Anyone even use Charles Proxy? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350821 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Charles Proxy and ColdFusion 9
Actually, we don't output anything...ColdFusion handles it automatically for you. All we do is enable debugging output in CF Administrator Freundliche Grüße / Best regards, Bill Franklin Computer Integrated Mfg. Bayer CropScience LP 8400 Hawthorne Road, Room 2447 Kansas City, MO 64120 Tel: +1 816 242 2148 Fax: +1 816 242 2047 E-mail: bill.frank...@bayer.com Web: http://www.bayercropscience.com Vorstand: Sandra E. Peterson, Vorsitzende | Lykele van der Broek, Achim Noack, Rüdiger Scheitza, Michael A. Schulz Vorsitzender des Aufsichtsrats: Werner Baumann Sitz der Gesellschaft: Monheim am Rhein | Eintragung: Amtsgericht Düsseldorf, HRB 46985 -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Monday, April 23, 2012 3:46 PM To: cf-talk Subject: Re: Charles Proxy and ColdFusion 9 Hence the use of Charles Proxy, which, up until ColdFusion 9, allowed us to see the SQL Queries that were run inside the CFC calls... I've used Charles before, but since it's an HTTP proxy, I don't see how it would let you see the actual SQL queries being run unless the CFC were outputting that information in some way. If that's what you need, you can use CF's own logging facility and not use any proxy at all. If you're testing AJAX functionality, you can use CF's JavaScript API to output items to the AJAX debug output window directly. You can also output items to the regular JavaScript console, which will show up in Firebug. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350823 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Charles Proxy and ColdFusion 9
Yes Freundliche Grüße / Best regards, Bill Franklin Computer Integrated Mfg. Bayer CropScience LP 8400 Hawthorne Road, Room 2447 Kansas City, MO 64120 Tel: +1 816 242 2148 Fax: +1 816 242 2047 E-mail: bill.frank...@bayer.com Web: http://www.bayercropscience.com Vorstand: Sandra E. Peterson, Vorsitzende | Lykele van der Broek, Achim Noack, Rüdiger Scheitza, Michael A. Schulz Vorsitzender des Aufsichtsrats: Werner Baumann Sitz der Gesellschaft: Monheim am Rhein | Eintragung: Amtsgericht Düsseldorf, HRB 46985 -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Monday, April 23, 2012 3:56 PM To: cf-talk Subject: Re: Charles Proxy and ColdFusion 9 Actually, we don't output anything...ColdFusion handles it automatically for you. All we do is enable debugging output in CF Administrator Do you have the option to output query information checked as well? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350826 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Charles Proxy and ColdFusion 9
Just wondering if anyone has had any luck with getting the SQLQuery information in response header with Charles Proxy after upgrading to ColdFusion 9. It works correctly on ColdFusion 8, with the exact same debugging settings, but although the header comes shows up, it does not have any of the child objects in it. I had thought that the JSON Serialization issue, that was fixed in ColdFusion 9.0.1 Hot Fix 2, would fix it...but alas, it did not. TIA Bill ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350811 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFinclude issues
Try a cfabort showerror=Here I am in the included page. Also, try using the fully qualified path name for the include to see if that works. Freundliche Grüße / Best regards, Bill Franklin Computer Integrated Mfg. Bayer CropScience LP 8400 Hawthorne Road, Room 2447 Kansas City, MO 64120 Tel: +1 816 242 2148 Fax: +1 816 242 2047 E-mail: bill.frank...@bayer.com Web: http://www.bayercropscience.com Vorstand: Sandra E. Peterson, Vorsitzende | Lykele van der Broek, Achim Noack, Rüdiger Scheitza, Michael A. Schulz Vorsitzender des Aufsichtsrats: Werner Baumann Sitz der Gesellschaft: Monheim am Rhein | Eintragung: Amtsgericht Düsseldorf, HRB 46985 -Original Message- From: Eileen Harberts [mailto:eil...@tdai.net] Sent: Friday, March 02, 2012 9:08 AM To: cf-talk Subject: Re: CFinclude issues Thank you for your response. I did take the .. away: cfinclude template=/includes/sponsors.cfm and it still did not display the include. There are not any errors that pop up, it just does not display. Thank you, Eileen Are you sure you need the .. in front of the first slash? It could be a relative path issue. What errors are you getting? Best regards, Bill Franklin -Original Message- From: Eileen Harberts [mailto:eil...@tdai.net] Sent: Thursday, March 01, 2012 3:16 PM To: cf-talk Subject: CFinclude issues I am trying to code a cfinclude on a template page: cfinclude template=../includes/sponsors.cfm to show this include when its pages are displayed. The name of the include is correct, the location it is directing to is correct, but it will not work. Does someone have an easy solution to help me? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350198 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFinclude issues
Are you sure you need the .. in front of the first slash? It could be a relative path issue. What errors are you getting? Best regards, Bill Franklin -Original Message- From: Eileen Harberts [mailto:eil...@tdai.net] Sent: Thursday, March 01, 2012 3:16 PM To: cf-talk Subject: CFinclude issues I am trying to code a cfinclude on a template page: cfinclude template=../includes/sponsors.cfm to show this include when its pages are displayed. The name of the include is correct, the location it is directing to is correct, but it will not work. Does someone have an easy solution to help me? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350189 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFBuilder Colorization
Are you talking about the tokens? Should be the AttributeName option that you need to change... -Original Message- From: Michael Brennan-White [mailto:mailinglists...@gmail.com] Sent: Friday, December 09, 2011 8:09 AM To: cf-talk Subject: CFBuilder Colorization Really stupid question: I am using one of the really great colorization resources I found for CFBuilder 2 which really is helpful on my eyes with a dark background. However: When I type a tag like cfset Variablename = 'string' / the variablename part displays as black text which doesn't stand out enough to me. What would I need to set for the Variablename piece of this code be a different color. Like I said, a very dumb question. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349042 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Quick CF9 Install questions
Sounds about right... -Original Message- From: Robert Rhodes [mailto:rrhode...@gmail.com] Sent: Saturday, November 26, 2011 12:19 PM To: cf-talk Subject: Quick CF9 Install questions Hell to all. I have to deploy a couple new CF9 installs today, and I just want to confirm that I have this right: Download the installer here: https://www.adobe.com/cfusion/tdrc/index.cfm?product=coldfusion Then the CF 9 Update 1 (9.01) here: http://www.adobe.com/support/coldfusion/downloads_updates.html Then the CF9 Cumulative Hot-Fix here: http://kb2.adobe.com/cps/918/cpsid_91836.html That's all I need for CF, yes? Sorry for the dumb question, it's still yesterday to me. :( -RR ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348878 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Dynamically Added Form Fields Not Submitted
Try here: http://www.coldfusionjedi.com/index.cfm/2009/1/18/Mixing-client-side-dynamic-forms-with-dynamic-ColdFusion-form-processing -Original Message- From: Robert Nurse [mailto:rnu...@gmail.com] Sent: Wednesday, September 14, 2011 11:18 AM To: cf-talk Subject: Dynamically Added Form Fields Not Submitted Hi All, I've written some Javascript that will dynamically add file type inputs to a form. Or, so I thought. They show up on the page just fine when the control is clicked. But, when I submit the form to the CF template, those form fields are absent from the form structure. The added fields are displayed in a table that is within the form tags. The JS code adds table rows (TR) then cells to that row then the file inputs to the cells. All this is done using DOM methods like appendChild(), createElement(), createTextNode(), etc. Is there some extra step needed in either JS or CF to make sure the added fields are made part of the form? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347460 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF9 - SpreadsheetSetCellValue exception
Okay, I have a spreadsheet loaded up. I am trying to create multiple copies of the spreadsheet on the server with different sets of values set in them. So, I have an index based loop..0 to 9 First run through, seems to go okay (although the formulas won't update based on the new values, unless I manually edit the cell and press enter...haven't looked into that yet). Second run through, blows up on the SpreadsheetSetCellValue command. It is setting the same cell's value to a different value on each pass through (3 cells total are getting changed on each pass). Error is: An exception occurred while calling the function setCellValue. org.apache.xmlbeans.impl.values.XmlValueDisconnectedException The error occurred in E:\http\test\test.cfm: line 19 17 : --- 18 : 19 :cfset SpreadsheetSetCellValue(ss,111,3,19) 20 :cfset SpreadsheetSetCellValue(ss,222,3,20) 21 :cfset SpreadsheetSetCellValue(ss,333,3,21) Is the spreadsheet variable ss getting de-referenced when I perform the write action on the cfspreadsheet (occurs on line 22, right before the /cfloop)? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347325 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF9 - SpreadsheetSetCellValue exception
Apparently, you must get a new reference to the spreadsheet after each write action. Once I put the Read action inside the loop, it started working. Anyone know how to cause the formulas to update based on the updated data? -Original Message- From: Bill Franklin Sent: Thursday, September 08, 2011 12:32 PM To: cf-talk Subject: CF9 - SpreadsheetSetCellValue exception Okay, I have a spreadsheet loaded up. I am trying to create multiple copies of the spreadsheet on the server with different sets of values set in them. So, I have an index based loop..0 to 9 First run through, seems to go okay (although the formulas won't update based on the new values, unless I manually edit the cell and press enter...haven't looked into that yet). Second run through, blows up on the SpreadsheetSetCellValue command. It is setting the same cell's value to a different value on each pass through (3 cells total are getting changed on each pass). Error is: An exception occurred while calling the function setCellValue. org.apache.xmlbeans.impl.values.XmlValueDisconnectedException The error occurred in E:\http\test\test.cfm: line 19 17 : --- 18 : 19 :cfset SpreadsheetSetCellValue(ss,111,3,19) 20 :cfset SpreadsheetSetCellValue(ss,222,3,20) 21 :cfset SpreadsheetSetCellValue(ss,333,3,21) Is the spreadsheet variable ss getting de-referenced when I perform the write action on the cfspreadsheet (occurs on line 22, right before the /cfloop)? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347326 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Using excel NumberFormat in coldfusion
Double # for each # you want to use... -Original Message- From: fun and learning [mailto:funandlrnn...@gmail.com] Sent: Tuesday, August 09, 2011 2:19 PM To: cf-talk Subject: Using excel NumberFormat in coldfusion Hi All - As suggested by a couple of coldfusion developers a weeks ago, I am using xml to generate excel sheets from coldfusion. I am stuck with the following issue. Style ss:ID=s71 Borders Border ss:Position=Bottom ss:LineStyle=Continuous ss:Weight=1 ss:Color=#00/ Border ss:Position=Left ss:LineStyle=Continuous ss:Weight=1 ss:Color=#00/ Border ss:Position=Right ss:LineStyle=Continuous ss:Weight=1 ss:Color=#00/ Border ss:Position=Top ss:LineStyle=Continuous ss:Weight=1 ss:Color=#00/ /Borders NumberFormat ss:Format=#,##0/ /Style The number format within Style tags above has pound signs which Coldfusion does not like. Escaping them does not produce the desired result. Can anyone suggest a work around for this issue? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346620 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: COMPLEX SQL RANDOM
Yeah, for my needs, I used the following (for our Oracle backend database).. SELECT * FROM ( SELECT rownum, {various fields} FROM {some joined tables} WHERE {some criteria} ORDER BY dbms_random.value ) WHERE rownum = {however many I needed} -Original Message- From: Jochem van Dieten [mailto:joch...@gmail.com] Sent: Wednesday, August 03, 2011 3:08 PM To: cf-talk Subject: Re: COMPLEX SQL RANDOM On Wed, Aug 3, 2011 at 9:36 PM, Bill Franklin wrote: Why not try something like this...(not sure which database you are using) SELECT TOP 1 * FROM ( SELECT DISTINCT portal_polls.poll_id, portal_polls.question, portal_polls.answer1, portal_polls.answer2, portal_polls.answer2, portal_polls.answer4, portal_polls.answer4, portal_polls.number_answers FROM portal_polls, portal_groups_x_polls, portal_groups_x_students WHERE (portal_polls.start_date #Now()# and portal_polls.end_date #Now()#) and (everyone=1 OR (portal_groups_x_polls.poll_id=portal_polls.poll_id and portal_groups_x_students.group_id=portal_groups_x_polls.group_id and portal_groups_x_students.student_user_id=#session.userid#)) and not exists (SELECT * FROM portal_students_x_polls_completed WHERE portal_students_x_polls_completed.poll_id=portal_polls.poll_id and portal_students_x_polls_completed.student_user_id=#session.userid#); ) Because this query does not have a random result. The result of the outer query will always be the first row of the inner query. The result of the inner query will be in a predictable order based on the indexes and statistics (probably whichever row is returned first by the index over poll_id, start_date and end_date as I suspect that will be the driving index). Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346516 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Running systeminfo with CFEXECUTE returns an empty string. Why?
Logon to the CF server using the name of the user that CF was installed with and try running systeminfo.exe using a CMD prompt. My guess is that it is using a user that doesn't have permission to run that process, as I tried the second command you provided, and it worked just fine... -Original Message- From: Scott Niven [mailto:scott_ni...@ncsu.edu] Sent: Wednesday, August 03, 2011 11:39 AM To: cf-talk Subject: Running systeminfo with CFEXECUTE returns an empty string. Why? Any ideas what I'm doing wrong? Here's my code: cfexecute name=c:\windows\system32\systeminfo.exe arguments=/FO CSV variable=data timeout=10 / cfdump var=#data# I've also tried running it without the arguments (see below). Both the code above and the code below return an empty string: cfexecute name=c:\windows\system32\systeminfo.exe variable=data timeout=10 / cfdump var=#data# Any ideas? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346489 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: COMPLEX SQL RANDOM
Why not try something like this...(not sure which database you are using) SELECT TOP 1 * FROM ( SELECT DISTINCT portal_polls.poll_id, portal_polls.question, portal_polls.answer1, portal_polls.answer2, portal_polls.answer2, portal_polls.answer4, portal_polls.answer4, portal_polls.number_answers FROM portal_polls, portal_groups_x_polls, portal_groups_x_students WHERE (portal_polls.start_date #Now()# and portal_polls.end_date #Now()#) and (everyone=1 OR (portal_groups_x_polls.poll_id=portal_polls.poll_id and portal_groups_x_students.group_id=portal_groups_x_polls.group_id and portal_groups_x_students.student_user_id=#session.userid#)) and not exists (SELECT * FROM portal_students_x_polls_completed WHERE portal_students_x_polls_completed.poll_id=portal_polls.poll_id and portal_students_x_polls_completed.student_user_id=#session.userid#); ) -Original Message- From: Steve Milburn [mailto:scmilb...@gmail.com] Sent: Wednesday, August 03, 2011 2:33 PM To: cf-talk Subject: Re: COMPLEX SQL RANDOM The error message you are getting is because the value of your order by clause, newID(), is not a part of your list of values you are selecting. You could, of course, include it in your list of values by first setting it to a variable, like so: declare @orderClause as uniqueidentifier; set @orderClause = NEWID(); select distinct top 1 fieldA, fieldB, @orderClause as fieldC from table order by fieldC This would get you past the error you are receiving about the ORDER BY clause must appear in the select list. However, because every row in your resulting recordset now has a field called fieldC with the value of your previously generated ID, you will lost your randomness as the first row will always be returned. Experiment on a simpler table than what you are working with using the above code as a guide and you'll see what I mean. I'm not sure you can do this in 1 step. I would still recommend the temporary table (rather, the derived table as pointed out by Leigh). Steve On Wed, Aug 3, 2011 at 2:54 PM, Robert Harrison rob...@austin-williams.comwrote: Since the query you have gives you the list of polls that you want, what about dumping the results of that query into a temp table, and doing a random select on the temp table with SELECT TOP 1 and ORDER BY NEWID() ? I have considered that, but this should be possible in one straight up SQL statement. It's annoying me and I'm being anal... but I want it right. Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346500 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cf9 multiple sheet excel
Just tested a comment... Cell ss:Index=4Comment ss:Author=Bill Franklinss:Data xmlns=http://www.w3.org/TR/REC-html40;BFont html:Face=Tahoma x:CharSet=1 html:Size=9 html:Color=#00Bill Franklin:/Font/BFont html:Face=Tahoma x:CharSet=1 html:Size=9 html:Color=#00#10;Testing 123/Font/ss:Data/Comment/Cell -Original Message- From: Ras Tafari [mailto:rastaf...@gmail.com] Sent: Tuesday, August 02, 2011 11:08 AM To: cf-talk Subject: Re: cf9 multiple sheet excel has anyone figured out how to add comments to a cell? i cannot make it work without breaking and causing a 500 server error. ras On Mon, Aug 1, 2011 at 3:44 PM, Captain Obvious mr.happ...@gmail.com wrote: Tried that (specifying XML in filenme attribute of cfheader tag) but Excel 2010 appends .xls to the filename, which then results in the extension prompt. No such problem prior to MS-Office 2007. But thanks Bill, appreciate the input. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346460 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cf9 multiple sheet excel
The way we have always handled excel spreadsheet generation (CF8), has been to take a formatted spreadsheet, save it as and XML sheet, open that XML in Notepad, copy the XML code and paste it inside a cfsavecontent variable=strXmlData tag...then edit the code to make it dynamic (e.g. Rows, Columns, sheets, etc.). Then we run the following code to have it open in Excel... cfheader name=content-disposition value=attachment; filename=#fileName#/ cfcontent type=application/vnd.ms-excel variable=#ToBinary( ToBase64( strXmlData.Trim().ReplaceAll( '\s+', '' ).ReplaceAll( '\s+', '' ) ) )#/ When we upgrade to CF9 next quarter, the only use I really have for the new office functionality, is to modify existing sheets Anyways, that's just my $0.02 -Original Message- From: fun and learning [mailto:funandlrnn...@gmail.com] Sent: Monday, August 01, 2011 10:30 AM To: cf-talk Subject: cf9 multiple sheet excel Hi All - I am trying to generate a multiple tabs excel sheet. I have the following code. The excel code is copied from coldfusionjedi.com cfset q = queryNew(Name,Beers,Vegetables,Fruits,Meats, cf_sql_varchar,cf_sql_integer,cf_sql_integer,cf_sql_integer,cf_sql_integer) cfloop index=x from=1 to=10 cfset queryAddRow(q) cfset querySetCell(q, Name, Name1) cfset querySetCell(q, Beers, 2) cfset querySetCell(q, Vegetables, 15) cfset querySetCell(q, Fruits, 33) cfset querySetCell(q, Meats, 3) /cfloop cfset filename = expandPath(./myexcel.xls) !--- cfspreadsheet action=write query=q filename=#filename# overwrite=true --- !--- Make a spreadsheet object --- cfset s = spreadsheetNew() !--- Add header row --- cfset spreadsheetAddRow(s, Name,Beers,Vegetables,Fruits,Meats) !--- format header --- cfset spreadsheetFormatRow(s, { bold=true, fgcolor=lemon_chiffon, fontsize=14 }, 1) !--- Add query --- cfset spreadsheetAddRows(s, q) cfset SpreadsheetCreateSheet (s, EvaluationSheet) cfheader name=content-disposition value=attachment; filename=myexcel.xls cfcontent type=application/msexcel variable=#spreadsheetReadBinary(s)# reset=true So the first sheet displays fine. To create a new sheet, I am using spreadsheetCreateSheet. How can I add data to the sheet? I mean I can use cfspreadsheet with action write, but I do not want to save the excel, rather have the user save it. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346428 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Method Opinion
I would take a look at using the MINUS union operator, and a table of poll/user IDs that have completed the poll. MINUS should return only the records in the first part of the query that are not in the second part of the querythe first part being the list of candidates and the second part being the list of completed candidates. Alternately, you could have a table that lists the candidates also include a status or completion date...and exclude those from an joined table. My $0.02... -Original Message- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: Monday, August 01, 2011 8:47 AM To: cf-talk Subject: Method Opinion Curious as to what you all think is the best method for something. I have a table that contains a list of polls. I have a user table that contains a list of possible persons who may complete the poll (it requires log-in access). I want to present a poll only one time so users can't complete a poll more than once, so I need to maintain a list of users who have completed a poll. I see two ways I can do this: 1. I can create a cross reference table that keeps users ID and Poll IDs (of users/polls completed), then use an SQL NOT IN to select polls for users who are NOT IN the completed poll table. 2. I can add a field in the POLLs record and put a delimited list of User IDs who've complete the poll, then not select any polls where the COMPLETED field contains the user ID of a given user. There are about 1,500 users. There will probably be not more than 10 polls going on at any one time. Poll history will be maintained for about 60 days. Thus, there may be thousands of COMPLETED records. Given that, is one of these methods better than the other, and if so, why? Should I use a delimited list in the POLL record, or should I use a cross-reference table with a join and NOT IN select... or should I do something different. Thanks Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346429 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cf9 multiple sheet excel
I guess so...I only get the message saying Do you want to Open or Save this file? Try including this and don't output anything in the code that isn't inside the cfsavecontent... cfsetting showdebugoutput=false -Original Message- From: Captain Obvious [mailto:mr.happ...@gmail.com] Sent: Monday, August 01, 2011 12:58 PM To: cf-talk Subject: Re: cf9 multiple sheet excel Me too. Have you figured a way to avoid Excel 2010 from producing the message below when opening files generated in this manner? The file you are trying to open is in a different format than specified by the extension... On Mon, Aug 1, 2011 at 1:07 PM, Bill Franklin bill.frank...@bayer.comwrote: The way we have always handled excel spreadsheet generation (CF8), has been to take a formatted spreadsheet, save it as and XML sheet, open that XML in Notepad, copy the XML code and paste it inside a cfsavecontent variable=strXmlData tag... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346433 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cf9 multiple sheet excel
Are you opening the file as *.xml, or *.xls? I open mine as *.xml...it knows to open it as Excel. -Original Message- From: Leigh [mailto:cfsearch...@yahoo.com] Sent: Monday, August 01, 2011 2:12 PM To: cf-talk Subject: RE: cf9 multiple sheet excel The file you are trying to open is in a different format than specified by the extension... That is Excel's extension hardening. It can only be disabled on the client computer. http://support.microsoft.com/kb/948615 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346436 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: What event specifically triggers OnApplicationStart?
On said diagnostic page, what is the value of CGI.SERVER_NAME and CGI.HTTP_HOST when the configName's value is dev? -Original Message- From: Dave Burns [mailto:cft...@burnsorama.com] Sent: Monday, March 28, 2011 1:10 PM To: cf-talk Subject: Re: What event specifically triggers OnApplicationStart? memory variables only timeout if they are not accessed the specified timeout period. every time anyone loads a page on your site, it accesses the application scope and their session scope, so the timeout is reset back to 0. An application will restart when ColdFusion restarts, when you reach the applicationTimeout, if you force a restart via code or via the CFADMIN/server monitor To confirm my understanding, are you saying that on a very busy site, it's possible that OnApplicationStart might never run again once the app has started? (server admin and restarts aside.) Since the app is running fine for months and then all of a sudden switches configs, something else then must trigger a call to OnApplicationStart but with a screwy environment. (I'm going to add logging to track this down but I can't predict when the problem might happen again.) When you say you use cgi.server_name to determine which variables to use, are you being VERY explicity, as in the SERVER_NAME must match EXACTLY, or are you doing an if/else to say if its this then set as live else set as dev? My code looks like this: configName = dev if CGI.SERVER_NAME contains blah.com configName = production I can tell from a diagnostic page I have that configName's value ended up being dev. Fixing the problem is as easy as forcing a call to OnApplicationStart by hitting a special URL. Which makes me wonder under what circumstances OnApplicationStart can be called without CGI being set properly. Strange. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343359 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm