Re: CF Blog software
could we have an example ? On Thu, Nov 11, 2010 at 2:21 AM, Sean Corfield seancorfi...@gmail.comwrote: On Wed, Nov 10, 2010 at 8:39 AM, Adrocknaphobia adrocknapho...@gmail.com wrote: Of course, if this is CF9, you can replace all the createObject() calls by using the 'new' keyword. Interesting. So if cfobject and createObject() are completed blocked by sandbox security on CF9 Enterprise, new will still work? Good to know. Sorry to be a walking advertisement, but ColdFusion Builder refactoring will make that task very easy. ColdFusion Builder is an excellent product. I have it open 24x7x365 and use it for all my CFML editing. After seeing the sneak peek of Storm at the ColdFusion Unconference at MAX, I'm really looking forward to upgrading when that ships! I'm bummed it won't run on Linux tho'... My Unbuntu netbook arrives next week and I shall really miss CFBuilder on that when I'm traveling :( -- Sean A Corfield -- (904) 302-SEAN Railo Technologies, Inc. -- http://getrailo.com/ An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| 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:339106 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFMAIL Speed Issue
how do you generate the emails, is it a mailmerge from a database, in which case could it be the database query causing the problem ? On Thu, Nov 11, 2010 at 1:18 AM, Jake Churchill reyna...@gmail.com wrote: I'm having an odd issue with CFMAIL that comes and goes and Im not seeing a reason for it. Environment: 2 load balanced 64-bit windows 2003 servers with 8GB RAM and 2GHz Quad-core processors running CF8 I have a mailer process which processes 1000 messages at a time and alternates between the 2 web servers for relay (modifying the server attribute of the cfmail tag). Normally, this process can handle 1000 messages in under 15 seconds. From time to time (now being one of those times) it will take 3+ minutes to generate them. From what I can tell, the bottleneck is in the generating phase (where it actually creates the messages and drops them in the Spool directory). The background process which actually sends the email files off to the relay servers seems to be running normal. I've tried setting the spooler to the disk or to memory and the speed is the same (maybe slightly faster via the memory setting, but still takes several minutes to complete 1000 messages). I've got the following jvm settings: *java.args=-server -Xms3072m -Xmx5120m -Dsun.io.useCanonCaches=false -XX:MaxPermSize=192m -XX:+UseParallelGC -Xbatch* Frankly I don't really know what some of that does but I know we are using up a crapload of memory which I assume would be a good thing. There's nothing else really running on these servers except IIS and CF8. I'm at a loss right now. Any ideas would be helpful. Thanks! -Jake ~| 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:339107 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: slow cfquery cfqueryparam?
thanks, this solution worked great and is now processing at a steady 2 seconds Hey, maybe try something like this? I haven't tested this, but it should theoretically be faster cfset sqlstring = / cfset questionIDLen = arrayLen(questionIDArray)!---put this in a variable so it doesn't re-evaluate 2200 times--- cfset questionIDCheck = 0 cfloop index=i from=2 to=#questionIDLen# !---remove if statement so it doesn't evaluate 2200 times either. --- cfset questionIDCheck = isNumeric(questionIDArray[i] parentQuestionIDArray[i] parentLevelArray[i])!---since all your params were checking for a numeric value, lump together and be sure they are all numeric. probably could use a regEx or other cffunctions to accomplish the same thing if this does not fit the bill--- cfif questionIDCheck!---only add to sql string if it passes the numeric check. --- cfset sqlstring = '#sqlstring#,(#questionIDArray[i]#, #parentQuestionIDArray[i]#,#parentLevelArray[i]#)' /cfif /cfloop !---run query. manually add first line since we didn't loop over it. --- cfquery name=insertData datasource=dbname INSERT INTO parentquestions VALUES (cfqueryparam value=#questionIDArray[1]# cfsqltype=cf_sql_bigint maxlength=20,cfqueryparam value=#parentQuestionIDArray[1]# cfsqltype=cf_sql_bigint maxlength=20,cfqueryparam value=#parentLevelArray[1]# cfsqltype=cf_sql_bigint maxlength=20) #sqlstring# /cfquery ~| 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:339108 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: slow cfquery cfqueryparam?
thanks for providing the details as to what is happening behind the scenes On Wed, Nov 10, 2010 at 12:40 AM, Richard White wrote: [query with 6600 cfqueryparams taking 9 seconds vs. 1 for plain SQL] In understand that adding the cfqueryparam is adding approx 6600 validations, however would it really be the cause of slowing this query down so much? cfqueryparam is not adding 6600 validations. Each use of cfqueryparam is causing one variable to be set on the database side. So without cfqueryparam you are sending 1 SQL statement to the JDBC driver, with cfqueryparam you are first sending a prepare command with the 'structure' of the query, then the command to create an instance of it, then 6600 commands to set the 6600 parameters, then the command to execute it. I am not familiar with the wire protocol for MySQL and can not look into the propietary JDBC driver Adobe uses for MySQL, but I would not be surprised if this were implemented as a synchronous protocol and there is significant roundtripping between the database server and ColdFusion. You are testing the pathological worst case scenario for cfqueryparam. In addition to the overhead from specifiying the variables in separate statements, you add the overhead for preparing the query and caching the execution plan, and then you only execute it once. But anyway, do you really care? If this is part of a scheduled job that takes a few hours anyway ... 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:339109 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: slow cfquery cfqueryparam?
transferring data from one app to another Hi, I am running the following cfquery which inserts a large amount of rows into a table (approx 2200) Just out of curiosity, where does your insert data originate from? ~| 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:339110 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFMAIL Speed Issue
Do you use cfmail parameters for naming the server, user and password? I'm on HostMySite and I'm not forced to use these parameters but I've found it's at least 300x faster (a few seconds compared to 3-5 minutes) if I do. -Original Message- From: Jake Churchill [mailto:reyna...@gmail.com] Sent: Wednesday, November 10, 2010 8:18 PM To: cf-talk Subject: CFMAIL Speed Issue I'm having an odd issue with CFMAIL that comes and goes and Im not seeing a reason for it. Environment: 2 load balanced 64-bit windows 2003 servers with 8GB RAM and 2GHz Quad-core processors running CF8 I have a mailer process which processes 1000 messages at a time and alternates between the 2 web servers for relay (modifying the server attribute of the cfmail tag). Normally, this process can handle 1000 messages in under 15 seconds. From time to time (now being one of those times) it will take 3+ minutes to generate them. From what I can tell, the bottleneck is in the generating phase (where it actually creates the messages and drops them in the Spool directory). The background process which actually sends the email files off to the relay servers seems to be running normal. I've tried setting the spooler to the disk or to memory and the speed is the same (maybe slightly faster via the memory setting, but still takes several minutes to complete 1000 messages). I've got the following jvm settings: *java.args=-server -Xms3072m -Xmx5120m -Dsun.io.useCanonCaches=false -XX:MaxPermSize=192m -XX:+UseParallelGC -Xbatch* Frankly I don't really know what some of that does but I know we are using up a crapload of memory which I assume would be a good thing. There's nothing else really running on these servers except IIS and CF8. I'm at a loss right now. Any ideas would be helpful. Thanks! -Jake ~| 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:339111 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFMAIL Speed Issue
That would imply an issue with the default SMTP server set in the cfadmin then, if you are specifying a different server in the cfmail tags to speed it up. -Original Message- From: Stephens, Larry V [mailto:steph...@indiana.edu] Sent: 11 November 2010 13:45 To: cf-talk Subject: RE: CFMAIL Speed Issue Do you use cfmail parameters for naming the server, user and password? I'm on HostMySite and I'm not forced to use these parameters but I've found it's at least 300x faster (a few seconds compared to 3-5 minutes) if I do. -Original Message- From: Jake Churchill [mailto:reyna...@gmail.com] Sent: Wednesday, November 10, 2010 8:18 PM To: cf-talk Subject: CFMAIL Speed Issue I'm having an odd issue with CFMAIL that comes and goes and Im not seeing a reason for it. Environment: 2 load balanced 64-bit windows 2003 servers with 8GB RAM and 2GHz Quad-core processors running CF8 I have a mailer process which processes 1000 messages at a time and alternates between the 2 web servers for relay (modifying the server attribute of the cfmail tag). Normally, this process can handle 1000 messages in under 15 seconds. From time to time (now being one of those times) it will take 3+ minutes to generate them. From what I can tell, the bottleneck is in the generating phase (where it actually creates the messages and drops them in the Spool directory). The background process which actually sends the email files off to the relay servers seems to be running normal. I've tried setting the spooler to the disk or to memory and the speed is the same (maybe slightly faster via the memory setting, but still takes several minutes to complete 1000 messages). I've got the following jvm settings: *java.args=-server -Xms3072m -Xmx5120m -Dsun.io.useCanonCaches=false -XX:MaxPermSize=192m -XX:+UseParallelGC -Xbatch* Frankly I don't really know what some of that does but I know we are using up a crapload of memory which I assume would be a good thing. There's nothing else really running on these servers except IIS and CF8. I'm at a loss right now. Any ideas would be helpful. Thanks! -Jake ~| 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:339112 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFMAIL Speed Issue
IIS on the local box is what relays and no params are needed On Thu, Nov 11, 2010 at 7:44 AM, Stephens, Larry V steph...@indiana.eduwrote: Do you use cfmail parameters for naming the server, user and password? I'm on HostMySite and I'm not forced to use these parameters but I've found it's at least 300x faster (a few seconds compared to 3-5 minutes) if I do. -Original Message- From: Jake Churchill [mailto:reyna...@gmail.com] Sent: Wednesday, November 10, 2010 8:18 PM To: cf-talk Subject: CFMAIL Speed Issue I'm having an odd issue with CFMAIL that comes and goes and Im not seeing a reason for it. Environment: 2 load balanced 64-bit windows 2003 servers with 8GB RAM and 2GHz Quad-core processors running CF8 I have a mailer process which processes 1000 messages at a time and alternates between the 2 web servers for relay (modifying the server attribute of the cfmail tag). Normally, this process can handle 1000 messages in under 15 seconds. From time to time (now being one of those times) it will take 3+ minutes to generate them. From what I can tell, the bottleneck is in the generating phase (where it actually creates the messages and drops them in the Spool directory). The background process which actually sends the email files off to the relay servers seems to be running normal. I've tried setting the spooler to the disk or to memory and the speed is the same (maybe slightly faster via the memory setting, but still takes several minutes to complete 1000 messages). I've got the following jvm settings: *java.args=-server -Xms3072m -Xmx5120m -Dsun.io.useCanonCaches=false -XX:MaxPermSize=192m -XX:+UseParallelGC -Xbatch* Frankly I don't really know what some of that does but I know we are using up a crapload of memory which I assume would be a good thing. There's nothing else really running on these servers except IIS and CF8. I'm at a loss right now. Any ideas would be helpful. Thanks! -Jake ~| 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:339113 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFMAIL Speed Issue
however, on one of the boxes there was a username/password set up in the mail section of cfadmin. I removed it and I'll see if that helps. Thanks for the suggestion. On Thu, Nov 11, 2010 at 8:02 AM, Jake Churchill reyna...@gmail.com wrote: IIS on the local box is what relays and no params are needed On Thu, Nov 11, 2010 at 7:44 AM, Stephens, Larry V steph...@indiana.eduwrote: Do you use cfmail parameters for naming the server, user and password? I'm on HostMySite and I'm not forced to use these parameters but I've found it's at least 300x faster (a few seconds compared to 3-5 minutes) if I do. -Original Message- From: Jake Churchill [mailto:reyna...@gmail.com] Sent: Wednesday, November 10, 2010 8:18 PM To: cf-talk Subject: CFMAIL Speed Issue I'm having an odd issue with CFMAIL that comes and goes and Im not seeing a reason for it. Environment: 2 load balanced 64-bit windows 2003 servers with 8GB RAM and 2GHz Quad-core processors running CF8 I have a mailer process which processes 1000 messages at a time and alternates between the 2 web servers for relay (modifying the server attribute of the cfmail tag). Normally, this process can handle 1000 messages in under 15 seconds. From time to time (now being one of those times) it will take 3+ minutes to generate them. From what I can tell, the bottleneck is in the generating phase (where it actually creates the messages and drops them in the Spool directory). The background process which actually sends the email files off to the relay servers seems to be running normal. I've tried setting the spooler to the disk or to memory and the speed is the same (maybe slightly faster via the memory setting, but still takes several minutes to complete 1000 messages). I've got the following jvm settings: *java.args=-server -Xms3072m -Xmx5120m -Dsun.io.useCanonCaches=false -XX:MaxPermSize=192m -XX:+UseParallelGC -Xbatch* Frankly I don't really know what some of that does but I know we are using up a crapload of memory which I assume would be a good thing. There's nothing else really running on these servers except IIS and CF8. I'm at a loss right now. Any ideas would be helpful. Thanks! -Jake ~| 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:339114 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: slow cfquery cfqueryparam?
transferring data from one app to another I'd just use Navicat to transfer the data. No CF needed. Quick and easy. Will ~| 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:339115 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: JQuery Ajax Error issue with Site-wide Error Handler
Not sure where this goes in CF5.5. Place it in your error handler. !---if the request is ajax, throw an error that can be returned to the client in a basic string and then log the error as usual--- cfset requestHeaders = getHTTPRequestData().headers cfif StructKeyExists(requestHeaders, X-Requested-With) and StructFind(requestHeaders,X-Requested-With) eq XMLHttpRequest !--- If you want to view the error in firebug dump the error here--- cfheader statusCode=500 statusText=ColdFusion Error cfabort /cfif In your js document: $.ajaxSetup({ error:function(x,e){ if(x.status == 500 x.statusText == ColdFusion Error){ //Server side code issue. Handle it gracefully! } }); You probably want to handle all server errors the same, although you can customize the messages returned to the client. For instance, if you get a SQL error you can do cfheader statusCode=500 statusText=JDBC Error instead. ~| 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:339116 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: JQuery Ajax Error issue with Site-wide Error Handler
Thanks Tony! Will the cfheader statusCode=500 work with the site-wide error handler on? I tried adding this tag to my ajax code, but it is still returning as success. Thanks, Donnie ~| 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:339117 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: JQuery Ajax Error issue with Site-wide Error Handler
Check firebug (how many times do people say this?) If you throw a 500 and abort after, the client should treat the response as an error. You need to configure the client too, not just put in cfheader statusCode=500. Use ALL of my code, not just a fragment. Thanks Tony! Will the cfheader statusCode=500 work with the site-wide error handler on? I tried adding this tag to my ajax code, but it is still returning as success. Thanks, Donnie ~| 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:339118 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Countries Select Box
I need to provide world-wide country postal abbreviations in a drop-down select box. there must be one of those out there, although I have searched. Anybody know where to get one. TNX. rick. ~| 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:339119 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Countries Select Box
Little find-and-replace on this and you should be good to go: http://snipplr.com/view/33790/form-country-code-select-with-if-selected-test/ On Thu, Nov 11, 2010 at 12:06 PM, Rick Colman rcol...@cox.net wrote: I need to provide world-wide country postal abbreviations in a drop-down select box. there must be one of those out there, although I have searched. Anybody know where to get one. TNX. rick. ~| 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:339120 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Countries Select Box
check cflib.org On Thu, Nov 11, 2010 at 6:15 PM, John M Bliss bliss.j...@gmail.com wrote: Little find-and-replace on this and you should be good to go: http://snipplr.com/view/33790/form-country-code-select-with-if-selected-test/ On Thu, Nov 11, 2010 at 12:06 PM, Rick Colman rcol...@cox.net wrote: I need to provide world-wide country postal abbreviations in a drop-down select box. there must be one of those out there, although I have searched. Anybody know where to get one. TNX. rick. ~| 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:339121 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Countries Select Box
Rick, do you mean something like this? Most are there except Axis-of-Evil countries. Afghanistan AF Albania AL Algeria DZ American Samoa (U.S. Ter.) AS Andorra AD Angola AO Anguilla AI Antigua Barbuda AG Antilles (Netherland) AN Argentina AR Armenia AM Aruba AW Ascension GB2 Australia AU Austria AT Azerbaijan AZ Azores PT2 Bahamas BS Bahrain BH Bangladesh BD Barbados BB Barbuda (Antigua) AG Belarus BY Belgium BE Belize BZ Benin BJ Bermuda BM Bhutan BT Bolivia BO Bonaire AN2 Bosnia-Hercegovina BA Botswana BW Brazil BR British Virgin Is. VG Brunei BN Bulgaria BG Burkina Faso BF Burma (Myanmar) MM Burundi BI Cambodia (Kampuchea) KH Cameroon CM Canada CA Cape Verde CV Cayman Islands KY Central African Rep. CF Chad TD Channel Islands GB3 Chile CL China CN Colombia CO Comoros KM Congo CG Cook Islands (N.Z.) CK Corsica FR2 Costa Rica CR Cote D'ivoire (Ivory Coast) CI Croatia HR Curacao (N.A.) AN3 Cyprus CY Czech Republic CZ Denmark DK Djibouti DJ Dominica DM Dominican Republic DO East Timor ID2 Ecuador EC Egypt EG El Salvador SV England (U.K.) GB Equatorial Guinea GQ Eritrea ER Estonia EE Ethiopia ET Faeroe Islands DK1 Fiji FJ Finland FI France FR French Guiana GF French Polynesia PF Gabon GA Gambia GM Georgia GE Germany DE Ghana GH Gibraltar GI Greece GR Greenland GL Grenada GD Guadeloupe GP Guam (U.S. Ter.) GU Guatemala GT Guinea GN Guinea-Bissau GW Guyana GY Haiti HT Holland (Netherlands) NL Honduras HN Hong Kong HK Hungary HU Iceland IS India IN Indonesia ID Iraq IQ Ireland IE Israel IL Italy IT Ivory Coast CI Jamaica JM Japan JP Jordan JO Kampuchea (Cambodia) KH Kazakhstan KZ Kenya KE Kiribati KI Kosrae FM1 Kuwait KW Kyrgyzstan KG Laos LA Latvia LV Lebanon LB Lesotho LS Liberia LR Libya LY Liechtenstein LI Lithuania LT Luxembourg LU Macau MO Macedonia MK Madagascar MG Madeira Islands PT3 Malawi MW Malaysia MY Maldives MV Mali ML Malta MT Marshall Islands MH Martinique MQ Mauritania MR Mauritius MU Mexico MX Micronesia FM Moldova MD Monaco MC Mongolia MN Montenegro ME Montserrat MS Morocco MA Mozambique MZ Myanmar (Burma) MM Namibia NA Nauru NR Nepal NP Netherlands NL Netherlands Antilles AN New Caledonia NC New Zealand NZ Nicaragua NI Niger NE Nigeria NG Norfolk Island AU2 Nort. Mariana Isl. MP Northern Ireland (U.K.) GB4 Norway NO Oman OM Pakistan PK Palau PW Panama PA Papua New Guinea PG Paraguay PY Peru PE Philippines PH Pitcairn Islands GB5 Pohnpei FM3 Poland PL Portugal PT Puerto Rico PR Qatar QA Reunion RE Romania RO Rota (U.S. Ter.) XD Russia RU Rwanda RW Saba (N.A.) AN5 Saipan (U.S. Ter.) MP2 San Marino (Italy) SM Sao Tome Principe ST Saudi Arabia SA Scotland (U.K.) GB7 Senegal SN Serbia RS Seychelles SC Sierra Leone SL Singapore SG Slovak Republic SK Slovenia SI Solomon Islands SB Somalia SO South Africa ZA South Korea KR Spain ES Sri Lanka LK St. Barthelemy (Guad) GP2 St. Croix (U.S. Ter.) VI2 St. Eustatius (N.A.) AN6 St. Helena GB6 St. Kitts Nevis KN St. Lucia LC St. Maarten (N.A.) AN7 St. Martin GP3 St. Pierre Miqu. PM St. Thomas (U.S. Ter.) VI3 St. Vincent VC Suriname SR Swaziland SZ Sweden SE Switzerland CH Tahiti (Fr. Poly.) PF Taiwan TW Tajikistan TJ Tanzania TZ Thailand TH Tinian XD2 Togo TG Tonga TO Tortola VG2 Trinidad And Tobago TT Tristan Da Cunha GB8 Truk FM4 Tunisia TN Turkey TR Turkmenistan TM Turks Caicos Is. TC Tuvalu TV U.S. Virgin Islands VI Uganda UG Ukraine UA Union Island WS United Arab Emirates AE Uruguay UY Uzbekistan UZ Vanuatu VU Vatican City VA Venezuela VE Vietnam VN Wales (U.K.) GB9 Wallis Futuna Is. WF Western Samoa WS Yap FM5 Yemen YE Zaire CD Zambia ZM Zimbabwe ZW ~| 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:339122 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Countries Select Box
I need to provide world-wide country postal abbreviations in a drop-down select box. there must be one of those out there, although I have searched. Anybody know where to get one. It's just HTML, right? So if you see a site with one, view source and copy the appropriate SELECT. 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:339123 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: JQuery Ajax Error issue with Site-wide Error Handler
Hi Tony, Thanks again. I should mention that I want the site-wide error handler to run. It writes to log files, sends email notification as well as some other bug tracking pieces we have in place. If I put a cfabort in the code, the site-wide error handler won't run. Are you suggesting the code you sent over be placed in the site-wide error handler or should it be placed in the code that is called via AJAX? Thanks, Donnie Check firebug (how many times do people say this?) If you throw a 500 and abort after, the client should treat the response as an error. You need to configure the client too, not just put in cfheader statusCode=500. Use ALL of my code, not just a fragment. Thanks Tony! Will the cfheader statusCode=500 work with the site-wide error handler on? I tried adding this tag to my ajax code, but it is still returning as success. Thanks, Donnie ~| 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:339124 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: JQuery Ajax Error issue with Site-wide Error Handler
Hi Tony, I just realized you were intending for the code to go in the site-wide error handler and not the custom error handling of the AJAX code. I got it working. This was a great help!! Thanks again, Donnie Check firebug (how many times do people say this?) If you throw a 500 and abort after, the client should treat the response as an error. You need to configure the client too, not just put in cfheader statusCode=500. Use ALL of my code, not just a fragment. Thanks Tony! Will the cfheader statusCode=500 work with the site-wide error handler on? I tried adding this tag to my ajax code, but it is still returning as success. Thanks, Donnie ~| 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:339125 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Countries Select Box
Rick Colman rcol...@cox.net wrote: I need to provide world-wide country postal abbreviations in a drop-down select box. I don't know of one already to go. Since countries can change, I use the UN country code list as the starting point. It isn't that hard with cut-n-paste to knock one out. Good luck, Roger -- LinkedIn: http://www.linkedin.com/pub/roger-austin/8/a4/60 Twitter: http://twitter.com/RogerTheGeek Blog: http://rogerthegeek.wordpress.com/ http://www.misshunt.com/ Home of the Clean/Dirty Magnet ~| 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:339126 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: JQuery Ajax Error issue with Site-wide Error Handler
Nice work! - Tony Bentley (sent from iPhone) On Nov 11, 2010, at 11:06 AM, Donnie Carvajal donnie.carva...@transformyx.com wrote: Hi Tony, I just realized you were intending for the code to go in the site-wide error handler and not the custom error handling of the AJAX code. I got it working. This was a great help!! Thanks again, Donnie Check firebug (how many times do people say this?) If you throw a 500 and abort after, the client should treat the response as an error. You need to configure the client too, not just put in cfheader statusCode=500. Use ALL of my code, not just a fragment. Thanks Tony! Will the cfheader statusCode=500 work with the site-wide error handler on? I tried adding this tag to my ajax code, but it is still returning as success. Thanks, Donnie ~| 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:339127 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: slow cfquery cfqueryparam?
nice link, thanks will! transferring data from one app to another I'd just use Navicat to transfer the data. No CF needed. Quick and easy. Will ~| 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:339128 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Countries Select Box
that worked. write me if you want a copy ... On 11/11/2010 10:15 AM, John M Bliss wrote: Little find-and-replace on this and you should be good to go: http://snipplr.com/view/33790/form-country-code-select-with-if-selected-test/ On Thu, Nov 11, 2010 at 12:06 PM, Rick Colmanrcol...@cox.net wrote: I need to provide world-wide country postal abbreviations in a drop-down select box. there must be one of those out there, although I have searched. Anybody know where to get one. TNX. rick. ~| 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:339129 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm