Re: CF5 download
On Monday 11 Jan 2010, b...@bradwood.com wrote: Tom, I've always loved your signature-- does it not count now that it is 2010? We've not won it this year yet :-) -- Helping to preemptively seize networks as part of the IT team of the year, '09 and '08 This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.co ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329570 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFTALK List Problems
Is this working??? I can't update my mailing lists and I've used to contact form on House of Fusion and it's giving hard CF Errors. Is there anyone that can help me with list problems? 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 __ Information from ESET Smart Security, version of virus signature database 4763 (20100112) __ The message was checked by ESET Smart Security. http://www.eset.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329571 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFTALK List Problems
List is working. On Tue, Jan 12, 2010 at 8:22 AM, Robert Harrison rob...@austin-williams.com wrote: Is this working??? I can't update my mailing lists and I've used to contact form on House of Fusion and it's giving hard CF Errors. Is there anyone that can help me with list problems? 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 __ Information from ESET Smart Security, version of virus signature database 4763 (20100112) __ The message was checked by ESET Smart Security. http://www.eset.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329572 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFTALK List Problems
Yep. Don't know about the site, but the mail list is working fine. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329573 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFTALK List Problems
Is there anyone that can help me with list problems? FYI, if you're having problems with the list, or even more so, the HOF site; the proper course of action is generally to E-mail the administrator of both directly. He usually responds in good time. Michael Dinowitz mdino...@houseoffusion.com ~Brad ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329574 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
reorder a query
I am thinking there has to be an easier way to do this then what I currently have. I need to move a row in a Query object up or down. Like imagine a page with little arrows on each record and you want record 2 to move to the position of record 1 and move record one to the position of record 2. Then I want to delete the records from the table and insert the newly ordered records back into the database. The direction I am currently going is to loop over the query object find the records that needs moved and start creating an Array for the new order 2,1,3,4 etc. Then use QueryAddColumn(getColors, reOrder, integer, reOrderArray) to insert the array into my query object. Then user a Query of a Query to do a SELECT * FROM getColors ORDER BY reorder Then delete the records and loop over the query object to insert back into the table. Seems really overly complicated... Can anyone think of a better way? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329575 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: reorder a query
Chad... can't attach files to the list, but I'm sending you a CF Routine that does exactly that... coming shortly. 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 -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Tuesday, January 12, 2010 12:55 PM To: cf-talk Subject: reorder a query I am thinking there has to be an easier way to do this then what I currently have. I need to move a row in a Query object up or down. Like imagine a page with little arrows on each record and you want record 2 to move to the position of record 1 and move record one to the position of record 2. Then I want to delete the records from the table and insert the newly ordered records back into the database. The direction I am currently going is to loop over the query object find the records that needs moved and start creating an Array for the new order 2,1,3,4 etc. Then use QueryAddColumn(getColors, reOrder, integer, reOrderArray) to insert the array into my query object. Then user a Query of a Query to do a SELECT * FROM getColors ORDER BY reorder Then delete the records and loop over the query object to insert back into the table. Seems really overly complicated... Can anyone think of a better way? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329576 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: reorder a query
While I am looking over Roberts code that he sent me why would I get a casting error for this code? I take the ORDER BY statement out of the Query of a Query and it does not error. Error casting an object of type java.lang.Double cannot be cast to java.lang.String to an incompatible type. cfset QueryAddColumn(getColors, reOrder, integer, reOrderArray) cfquery dbtype=query name=newOrder SELECT ColorName FROM getColors ORDER BY reOrder /cfquery -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Tuesday, January 12, 2010 12:55 PM To: cf-talk Subject: reorder a query I am thinking there has to be an easier way to do this then what I currently have. I need to move a row in a Query object up or down. Like imagine a page with little arrows on each record and you want record 2 to move to the position of record 1 and move record one to the position of record 2. Then I want to delete the records from the table and insert the newly ordered records back into the database. The direction I am currently going is to loop over the query object find the records that needs moved and start creating an Array for the new order 2,1,3,4 etc. Then use QueryAddColumn(getColors, reOrder, integer, reOrderArray) to insert the array into my query object. Then user a Query of a Query to do a SELECT * FROM getColors ORDER BY reorder Then delete the records and loop over the query object to insert back into the table. Seems really overly complicated... Can anyone think of a better way? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329577 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: reorder a query
Never mind... figured it out. I needed javaCast when setting the values of the Array. cfset reOrderArray[getColors.currentRow] = javaCast(int, variables.counter) -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Tuesday, January 12, 2010 1:35 PM To: cf-talk Subject: RE: reorder a query While I am looking over Roberts code that he sent me why would I get a casting error for this code? I take the ORDER BY statement out of the Query of a Query and it does not error. Error casting an object of type java.lang.Double cannot be cast to java.lang.String to an incompatible type. cfset QueryAddColumn(getColors, reOrder, integer, reOrderArray) cfquery dbtype=query name=newOrder SELECT ColorName FROM getColors ORDER BY reOrder /cfquery ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329578 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: reorder a query
Could it be that one (or more) of the rows in column reOrder is of type Double while the other rows are all of type string? I am guessing maybe you want a numeric value in this row but one of more rows got empty. On Tue, Jan 12, 2010 at 1:34 PM, Chad Gray cg...@careyweb.com wrote: While I am looking over Roberts code that he sent me why would I get a casting error for this code? I take the ORDER BY statement out of the Query of a Query and it does not error. Error casting an object of type java.lang.Double cannot be cast to java.lang.String to an incompatible type. cfset QueryAddColumn(getColors, reOrder, integer, reOrderArray) cfquery dbtype=query name=newOrder SELECT ColorName FROM getColors ORDER BY reOrder /cfquery -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Tuesday, January 12, 2010 12:55 PM To: cf-talk Subject: reorder a query I am thinking there has to be an easier way to do this then what I currently have. I need to move a row in a Query object up or down. Like imagine a page with little arrows on each record and you want record 2 to move to the position of record 1 and move record one to the position of record 2. Then I want to delete the records from the table and insert the newly ordered records back into the database. The direction I am currently going is to loop over the query object find the records that needs moved and start creating an Array for the new order 2,1,3,4 etc. Then use QueryAddColumn(getColors, reOrder, integer, reOrderArray) to insert the array into my query object. Then user a Query of a Query to do a SELECT * FROM getColors ORDER BY reorder Then delete the records and loop over the query object to insert back into the table. Seems really overly complicated... Can anyone think of a better way? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329579 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: reorder a query
Hope that at least pointed you in the right direction Chad. I know the queries were different but the method was sound. 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 __ Information from ESET Smart Security, version of virus signature database 4765 (20100112) __ The message was checked by ESET Smart Security. http://www.eset.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329580 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Provide access to the CFIDE
When we installed our server, only one special admin site was given a mapping the the CFIDE folder. This has obviously affected the ability of ColdFusion AJAX, Flash and DHTML features from working. What are someways that we could provide access to the necessary folders without illuminating the nice feature that only our admin web site has access to the the Administrator portal. TIA Ian ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329581 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
File Upload with CFKeditor in CF8
Hello all, I have been trying to get file uploading working with cftextarea , CF 8.01 on a UNIX host. I am able to see the entire FCKEditor toolbar and I have made the tweaks to get the file upload option as described here: http://www.rakshith.net/blog/?p=58 However, when I try to upload an image, I get this error: Variable SENDERROR is undefined Thanks in Advance. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329582 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Provide access to the CFIDE
What are someways that we could provide access to the necessary folders without illuminating the nice feature that only our admin web site has access to the the Administrator portal. On our IIS servers we generally create a virtual folder mapping called cfide at the site root which points back to the CFIDE folder on the server. Then, within the virtual folder structure on the site, we redirect the administrator folder either to root (/) or to a 404 error page if the client prefers. If you didn't want to setup the redirection for each site you could also apply NTFS access permissions to the administrator folder and deny read access to the IUSR account. -Justin ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329583 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: reorder a query
You gave me some good ideas, but I don't have a column to write the sort order. I need to use the Auto increment primary key I should have mentioned that. Thanks though! Chad -Original Message- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: Tuesday, January 12, 2010 2:06 PM To: cf-talk Subject: RE: reorder a query Hope that at least pointed you in the right direction Chad. I know the queries were different but the method was sound. 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 __ Information from ESET Smart Security, version of virus signature database 4765 (20100112) __ The message was checked by ESET Smart Security. http://www.eset.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329584 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Provide access to the CFIDE
On 1/12/2010 11:13 AM, Justin Scott wrote: On our IIS servers we generally create a virtual folder mapping called cfide at the site root which points back to the CFIDE folder on the server. Then, within the virtual folder structure on the site, we redirect the administrator folder either to root (/) or to a 404 error page if the client prefers. If you didn't want to setup the redirection for each site you could also apply NTFS access permissions to the administrator folder and deny read access to the IUSR account. -Justin Most of those ideas apply, I believe, but our server is a Unix system with Apache so if nothing else no IUSR account. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329585 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFFILE move is copying
I'm using ColdFusion 9 on Windows with Apache 2 (in case that matters) and am trying to do a basic cffile action=move but it appears to be copying rather than moving (i.e., the file is now in both the source and destination folders). Does anyone know what could cause that? Here's my cffile tag: cffile action=move source=#arguments.stConfig.ftpFileLocations.pending##local.qFiles.name# destination=#arguments.stConfig.ftpFileLocations.badFiles##local.qFiles.name# / Scott -- - Scott Brady http://www.scottbrady.net/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329586 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF5 download
Tom, I've always loved your signature-- does it not count now that it is 2010? We've not won it this year yet :-) -- Helping to preemptively seize networks as part of the IT team of the year, '09 and '08 I would prefer that my network not be preemptively seized, TIA. 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. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329587 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Provide access to the CFIDE
Most of those ideas apply, I believe, but our server is a Unix system with Apache so if nothing else no IUSR account. Use .htaccess to secure the admninistrator folder. Alternatively, I have two copies of the CFIDE folder-- one with ALL the sub-folders that is ONLY mapped to my internal default site and cannot be accessed by anyone outside my network. And a second CFIDE folder where I have deleted the adminapi, administrator, componentutils, and wizards folders that I map to my external-facing sites. ~Brad ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329588 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
500 Internal Server Error
Anybody care to take a guess what a HTTP/1.1 500 538 error might mean. We have a web application that is returning an *Internal Server Error* with that error code in the Apache error log file. The trouble is I have no idea why. The exact same code running on a different configured the same ColdFusion instance is working just fine. Just as other ColdFusion applications running on this instance are. Also I have robust exception messages turned on, so this is more then just a bad piece of code as best as I can tell. Ian ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329589 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: 500 Internal Server Error
Sometimes when I use IE the robust exception message does not appear you just get a default IE 500 page. Switch to Firefox or dig into the CF logs to view the error. -Original Message- From: Ian Skinner [mailto:h...@ilsweb.com] Sent: Tuesday, January 12, 2010 3:44 PM To: cf-talk Subject: 500 Internal Server Error Anybody care to take a guess what a HTTP/1.1 500 538 error might mean. We have a web application that is returning an *Internal Server Error* with that error code in the Apache error log file. The trouble is I have no idea why. The exact same code running on a different configured the same ColdFusion instance is working just fine. Just as other ColdFusion applications running on this instance are. Also I have robust exception messages turned on, so this is more then just a bad piece of code as best as I can tell. Ian ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329590 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Provide access to the CFIDE
On 1/12/2010 12:43 PM, b...@bradwood.com wrote: Use .htaccess to secure the admninistrator folder. Alternatively, I have two copies of the CFIDE folder-- one with ALL the sub-folders that is ONLY mapped to my internal default site and cannot be accessed by anyone outside my network. And a second CFIDE folder where I have deleted the adminapi, administrator, componentutils, and wizards folders that I map to my external-facing sites. ~Brad Your second option is one of the first I considered, but I wasn't sure what folders I needed to keep and|or could get rid of such as you listed. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329591 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: 500 Internal Server Error
That kind of an error is a web server error. What do your web server logs say? What web server are you using? This wording is a little confusing: The exact same code running on a different configured the same ColdFusion instance is working just fine. Do you mean a different instance on the same box? Or a different instance on a different box that's configured the same? Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Open BlueDragon Steering Committee Railo Community Distributions Ian Skinner wrote: Anybody care to take a guess what a HTTP/1.1 500 538 error might mean. We have a web application that is returning an *Internal Server Error* with that error code in the Apache error log file. The trouble is I have no idea why. The exact same code running on a different configured the same ColdFusion instance is working just fine. Just as other ColdFusion applications running on this instance are. Also I have robust exception messages turned on, so this is more then just a bad piece of code as best as I can tell. Ian ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329592 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: 500 Internal Server Error
Note to self: need more coffee. :) Not sure how I missed Apache in your note. My fault. What does your error log say exactly? Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Open BlueDragon Steering Committee Railo Community Distributions Jordan Michaels wrote: That kind of an error is a web server error. What do your web server logs say? What web server are you using? This wording is a little confusing: The exact same code running on a different configured the same ColdFusion instance is working just fine. Do you mean a different instance on the same box? Or a different instance on a different box that's configured the same? Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Open BlueDragon Steering Committee Railo Community Distributions Ian Skinner wrote: Anybody care to take a guess what a HTTP/1.1 500 538 error might mean. We have a web application that is returning an *Internal Server Error* with that error code in the Apache error log file. The trouble is I have no idea why. The exact same code running on a different configured the same ColdFusion instance is working just fine. Just as other ColdFusion applications running on this instance are. Also I have robust exception messages turned on, so this is more then just a bad piece of code as best as I can tell. Ian ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329593 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Provide access to the CFIDE
Your second option is one of the first I considered, but I wasn't sure what folders I needed to keep and|or could get rid of such as you listed. My list of folders is just one I came up with based how they seemed to be used, but it hasn't seemed to affect anything unexpected to date. :) YMMV. ~Brad ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329594 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Problem deleting structure in an array
Hello: Sorry, I forgot the subject in my last post. I'm having an issue deleting a form structure that is in a shopping cart array. I'm sure it's something simple I'm doing wrong, but it's driving me crazy. I have a checkbox to select which items to delete. If only one item is selected there is no error and it works fine. If more than one item is selected then the error is triggered. Strangely, if I resubmit the form after the error it works OK. If I select two items to delete the error is: The error message is Element at position [3] doesn't exist in array Here is the form code: cfloop from=1 to=#arrayLen(session.shoppingcart)# index=i tr td cfinput type=checkbox value=#i# name=itemid#i# /td td cfinput type=text name=quantity#i# value=#session.shoppingcart[i].quantity# size=3 /td td cfinput type=text name=catalogno#i# value=#HTMLEditFormat(session.shoppingcart[i].catalog)# size=10 /td td cfinput type=text name=description#i# value=#HTMLEditFormat(session.shoppingcart[i].description)# size=40/td td cfinput type=text name=price#i# value=#session.shoppingcart[i].price# size=3 /td /tr /cfloop Here is the cfc code: cfloop from=1 to=#arrayLen(session.shoppingcart)# index=i cfif StructKeyExists(rc,itemid i) cfset private.temp = arrayDeleteAt(session.shoppingcart,i) /cfif /cfloop Any help is greatly appreciated. Regards, Jaime ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329595 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFFILE move is copying
I'm using ColdFusion 9 on Windows with Apache 2 (in case that matters) and am trying to do a basic cffile action=move but it appears to be copying rather than moving (i.e., the file is now in both the source and destination folders). Does anyone know what could cause that? Here's my cffile tag: cffile action=move source=#arguments.stConfig.ftpFileLocations.pending##local.qFiles.name# destination=#arguments.stConfig.ftpFileLocations.badFiles##local.qFiles.name# / Well, a move is basically just a copy followed by a delete. So maybe CF can't delete the file? Maybe it's locked by CF itself, preventing it from being deleted. 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 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329596 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Problem deleting structure in an array
My best guess is if you remove one item it changes the structure of the array and when it goes to remove the next one it cannot be found? Use CFDump to display the array as you are looping over it to help debug. This way you can see the way the array is changing as you are removing items. -Original Message- From: jrmuniz [mailto:jrmu...@sfsailing.com] Sent: Tuesday, January 12, 2010 4:16 PM To: cf-talk Subject: Problem deleting structure in an array Hello: Sorry, I forgot the subject in my last post. I'm having an issue deleting a form structure that is in a shopping cart array. I'm sure it's something simple I'm doing wrong, but it's driving me crazy. I have a checkbox to select which items to delete. If only one item is selected there is no error and it works fine. If more than one item is selected then the error is triggered. Strangely, if I resubmit the form after the error it works OK. If I select two items to delete the error is: The error message is Element at position [3] doesn't exist in array Here is the form code: cfloop from=1 to=#arrayLen(session.shoppingcart)# index=i tr td cfinput type=checkbox value=#i# name=itemid#i# /td td cfinput type=text name=quantity#i# value=#session.shoppingcart[i].quantity# size=3 /td td cfinput type=text name=catalogno#i# value=#HTMLEditFormat(session.shoppingcart[i].catalog)# size=10 /td td cfinput type=text name=description#i# value=#HTMLEditFormat(session.shoppingcart[i].description)# size=40/td td cfinput type=text name=price#i# value=#session.shoppingcart[i].price# size=3 /td /tr /cfloop Here is the cfc code: cfloop from=1 to=#arrayLen(session.shoppingcart)# index=i cfif StructKeyExists(rc,itemid i) cfset private.temp = arrayDeleteAt(session.shoppingcart,i) /cfif /cfloop Any help is greatly appreciated. Regards, Jaime ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329597 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: 500 Internal Server Error
On 1/12/2010 12:57 PM, Jordan Michaels wrote: Note to self: need more coffee. :) Not sure how I missed Apache in your note. My fault. What does your error log say exactly? From the access log 10.104.97.39 - - [12/Jan/2010:12:21:19 -0800] GET /calpiq/index.cfm HTTP/1.1 500 538 10.104.97.39 - - [12/Jan/2010:12:22:40 -0800] GET /calpiq/index.cfm HTTP/1.1 500 538 10.104.97.39 - - [12/Jan/2010:12:22:42 -0800] GET /calpiq/index.cfm HTTP/1.1 500 538 10.104.97.39 - - [12/Jan/2010:12:22:45 -0800] GET /calpiq/index.cfm HTTP/1.1 500 538 10.104.97.39 - - [12/Jan/2010:12:24:21 -0800] GET /calpiq/index.cfm HTTP/1.1 500 538 10.104.97.39 - - [12/Jan/2010:12:24:22 -0800] GET /calpiq/index.cfm HTTP/1.1 500 538 10.104.97.22 - - [12/Jan/2010:12:27:15 -0800] GET /calpiq HTTP/1.1 500 538 From the error log. [Tue Jan 12 12:21:19 2010] [alert] [client 10.104.97.39] /export/home/devuser/site/htdocs/calpiq/.htaccess: order not allowed here [Tue Jan 12 12:22:40 2010] [alert] [client 10.104.97.39] /export/home/devuser/site/htdocs/calpiq/.htaccess: order not allowed here [Tue Jan 12 12:22:42 2010] [alert] [client 10.104.97.39] /export/home/devuser/site/htdocs/calpiq/.htaccess: order not allowed here [Tue Jan 12 12:22:45 2010] [alert] [client 10.104.97.39] /export/home/devuser/site/htdocs/calpiq/.htaccess: order not allowed here Thanks that pointed me to the rogue .htaccess file that had illegal, and unnecessary allow deny directives in it. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329598 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFFILE move is copying
That's probably it -- though, I guess I'd expect an error to result. I guess I can try deleting after the move -- not a solution, but it might tell me if the file is locked. (It's just a text file, so not much should be locking it) Scott On Tue, Jan 12, 2010 at 2:24 PM, Dave Watts dwa...@figleaf.com wrote: Well, a move is basically just a copy followed by a delete. So maybe CF can't delete the file? Maybe it's locked by CF itself, preventing it from being deleted. -- - Scott Brady http://www.scottbrady.net/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329599 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem deleting structure in an array
You are looping over the array sequentially from 1 but are you sure your array key values are sequential from 1 as well? Your loop goes 1, 2, 3, which means it will expect to find session.shoppingCart[1].itemid, session.shoppingCart[2].itemid and session.shoppingCart[3].itemid. But are you sure those are indeed the key values in the session array? If your array key values go 1,3,4 then that will definitely break things. On Tue, Jan 12, 2010 at 4:31 PM, Chad Gray cg...@careyweb.com wrote: My best guess is if you remove one item it changes the structure of the array and when it goes to remove the next one it cannot be found? Use CFDump to display the array as you are looping over it to help debug. This way you can see the way the array is changing as you are removing items. -Original Message- From: jrmuniz [mailto:jrmu...@sfsailing.com] Sent: Tuesday, January 12, 2010 4:16 PM To: cf-talk Subject: Problem deleting structure in an array Hello: Sorry, I forgot the subject in my last post. I'm having an issue deleting a form structure that is in a shopping cart array. I'm sure it's something simple I'm doing wrong, but it's driving me crazy. I have a checkbox to select which items to delete. If only one item is selected there is no error and it works fine. If more than one item is selected then the error is triggered. Strangely, if I resubmit the form after the error it works OK. If I select two items to delete the error is: The error message is Element at position [3] doesn't exist in array Here is the form code: cfloop from=1 to=#arrayLen(session.shoppingcart)# index=i tr td cfinput type=checkbox value=#i# name=itemid#i# /td td cfinput type=text name=quantity#i# value=#session.shoppingcart[i].quantity# size=3 /td td cfinput type=text name=catalogno#i# value=#HTMLEditFormat(session.shoppingcart[i].catalog)# size=10 /td td cfinput type=text name=description#i# value=#HTMLEditFormat(session.shoppingcart[i].description)# size=40/td td cfinput type=text name=price#i# value=#session.shoppingcart[i].price# size=3 /td /tr /cfloop Here is the cfc code: cfloop from=1 to=#arrayLen(session.shoppingcart)# index=i cfif StructKeyExists(rc,itemid i) cfset private.temp = arrayDeleteAt(session.shoppingcart,i) /cfif /cfloop Any help is greatly appreciated. Regards, Jaime ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329600 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFFILE move is copying
I would check permissions too. CF might have permissions to write and read, but not delete. If this was the case though, I would expect there to be an error. As a debugging measure, you could dump out the contents of a cfdirectory right after moving the file and see if the file exists. It is possible some other process is writing the file back in a minute later before you are looking. Also, trying a straight-up delete with cffile will show you if it is a delete permissions error. ~Brad Original Message Subject: Re: CFFILE move is copying From: Scott Brady dsbr...@gmail.com Date: Tue, January 12, 2010 3:46 pm To: cf-talk cf-talk@houseoffusion.com That's probably it -- though, I guess I'd expect an error to result. I guess I can try deleting after the move -- not a solution, but it might tell me if the file is locked. (It's just a text file, so not much should be locking it) Scott On Tue, Jan 12, 2010 at 2:24 PM, Dave Watts dwa...@figleaf.com wrote: Well, a move is basically just a copy followed by a delete. So maybe CF can't delete the file? Maybe it's locked by CF itself, preventing it from being deleted. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329601 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Problem deleting structure in an array
My best guess is if you remove one item it changes the structure of the array and when it goes to remove the next one it cannot be found? Yes. !--- does not work --- cfset myArray = [ a, b, c, d ] / cfoutput cfloop from=1 to=#arrayLen(myArray)# index=i delete element [#i#] array size = #arrayLen(myArray)#br / cfset arrayDeleteAt(myArray, i) / /cfloop /cfoutput When deleting within a loop, iterate in _descending_ order. cfset myArray = [ a, b, c, d ] / cfoutput cfloop from=#arrayLen(myArray)# to=1 index=i step=-1 delete element [#i#] array size = #arrayLen(myArray)#br / cfset arrayDeleteAt(myArray, i) / /cfloop /cfoutput ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329602 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem deleting structure in an array
Nope, on 2nd thought, Chat was right. If your array index was messed up, then the error would have occurred sooner while rendering the form. I bet the error happens only if item 3 is selected. If you do 1 and 2 then you'll get the original number 2 remaining in the array. On Tue, Jan 12, 2010 at 4:51 PM, Qing Xia txiasum...@gmail.com wrote: You are looping over the array sequentially from 1 but are you sure your array key values are sequential from 1 as well? Your loop goes 1, 2, 3, which means it will expect to find session.shoppingCart[1].itemid, session.shoppingCart[2].itemid and session.shoppingCart[3].itemid. But are you sure those are indeed the key values in the session array? If your array key values go 1,3,4 then that will definitely break things. On Tue, Jan 12, 2010 at 4:31 PM, Chad Gray cg...@careyweb.com wrote: My best guess is if you remove one item it changes the structure of the array and when it goes to remove the next one it cannot be found? Use CFDump to display the array as you are looping over it to help debug. This way you can see the way the array is changing as you are removing items. -Original Message- From: jrmuniz [mailto:jrmu...@sfsailing.com] Sent: Tuesday, January 12, 2010 4:16 PM To: cf-talk Subject: Problem deleting structure in an array Hello: Sorry, I forgot the subject in my last post. I'm having an issue deleting a form structure that is in a shopping cart array. I'm sure it's something simple I'm doing wrong, but it's driving me crazy. I have a checkbox to select which items to delete. If only one item is selected there is no error and it works fine. If more than one item is selected then the error is triggered. Strangely, if I resubmit the form after the error it works OK. If I select two items to delete the error is: The error message is Element at position [3] doesn't exist in array Here is the form code: cfloop from=1 to=#arrayLen(session.shoppingcart)# index=i tr td cfinput type=checkbox value=#i# name=itemid#i# /td td cfinput type=text name=quantity#i# value=#session.shoppingcart[i].quantity# size=3 /td td cfinput type=text name=catalogno#i# value=#HTMLEditFormat(session.shoppingcart[i].catalog)# size=10 /td td cfinput type=text name=description#i# value=#HTMLEditFormat(session.shoppingcart[i].description)# size=40/td td cfinput type=text name=price#i# value=#session.shoppingcart[i].price# size=3 /td /tr /cfloop Here is the cfc code: cfloop from=1 to=#arrayLen(session.shoppingcart)# index=i cfif StructKeyExists(rc,itemid i) cfset private.temp = arrayDeleteAt(session.shoppingcart,i) /cfif /cfloop Any help is greatly appreciated. Regards, Jaime ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329603 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem deleting structure in an array
So maybe you can figure out which array index values are NOT selected for deletion, clear out the original array and insert the un-deleted array elements back in there. On Tue, Jan 12, 2010 at 5:10 PM, Qing Xia txiasum...@gmail.com wrote: Nope, on 2nd thought, Chat was right. If your array index was messed up, then the error would have occurred sooner while rendering the form. I bet the error happens only if item 3 is selected. If you do 1 and 2 then you'll get the original number 2 remaining in the array. On Tue, Jan 12, 2010 at 4:51 PM, Qing Xia txiasum...@gmail.com wrote: You are looping over the array sequentially from 1 but are you sure your array key values are sequential from 1 as well? Your loop goes 1, 2, 3, which means it will expect to find session.shoppingCart[1].itemid, session.shoppingCart[2].itemid and session.shoppingCart[3].itemid. But are you sure those are indeed the key values in the session array? If your array key values go 1,3,4 then that will definitely break things. On Tue, Jan 12, 2010 at 4:31 PM, Chad Gray cg...@careyweb.com wrote: My best guess is if you remove one item it changes the structure of the array and when it goes to remove the next one it cannot be found? Use CFDump to display the array as you are looping over it to help debug. This way you can see the way the array is changing as you are removing items. -Original Message- From: jrmuniz [mailto:jrmu...@sfsailing.com] Sent: Tuesday, January 12, 2010 4:16 PM To: cf-talk Subject: Problem deleting structure in an array Hello: Sorry, I forgot the subject in my last post. I'm having an issue deleting a form structure that is in a shopping cart array. I'm sure it's something simple I'm doing wrong, but it's driving me crazy. I have a checkbox to select which items to delete. If only one item is selected there is no error and it works fine. If more than one item is selected then the error is triggered. Strangely, if I resubmit the form after the error it works OK. If I select two items to delete the error is: The error message is Element at position [3] doesn't exist in array Here is the form code: cfloop from=1 to=#arrayLen(session.shoppingcart)# index=i tr td cfinput type=checkbox value=#i# name=itemid#i# /td td cfinput type=text name=quantity#i# value=#session.shoppingcart[i].quantity# size=3 /td td cfinput type=text name=catalogno#i# value=#HTMLEditFormat(session.shoppingcart[i].catalog)# size=10 /td td cfinput type=text name=description#i# value=#HTMLEditFormat(session.shoppingcart[i].description)# size=40/td td cfinput type=text name=price#i# value=#session.shoppingcart[i].price# size=3 /td /tr /cfloop Here is the cfc code: cfloop from=1 to=#arrayLen(session.shoppingcart)# index=i cfif StructKeyExists(rc,itemid i) cfset private.temp = arrayDeleteAt(session.shoppingcart,i) /cfif /cfloop Any help is greatly appreciated. Regards, Jaime ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329604 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF5 download
On Tue, Jan 12, 2010 at 3:09 PM, Dave Watts dwa...@figleaf.com wrote: Tom, I've always loved your signature-- does it not count now that it is 2010? We've not won it this year yet :-) -- Helping to preemptively seize networks as part of the IT team of the year, '09 and '08 I would prefer that my network not be preemptively seized, TIA. Me, too. That would give me a seizure. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329605 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Recent SQL Injection attacks
Has anyone seen any recent SQL injection attacks on their sites or in the wild? I just cleaned a bunch of JS and other code from a clients DB. Most of the scripts were running those fake anti-virus popups but some had other things like lung cancer scams. Anyone see anything? Thanks -- Michael ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329606 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFFILE move is copying
I don't think permissions or other processes would be an issue. This is on my local machine, and I haven't had problems before. Now, I'm doing a cffile delete and it's not even throwing an error if the file doesn't exist (which it should, right?). Maybe I'll restart CF and see what happens. :) On Tue, Jan 12, 2010 at 2:55 PM, b...@bradwood.com wrote: I would check permissions too. CF might have permissions to write and read, but not delete. If this was the case though, I would expect there to be an error. As a debugging measure, you could dump out the contents of a cfdirectory right after moving the file and see if the file exists. It is possible some other process is writing the file back in a minute later before you are looking. Also, trying a straight-up delete with cffile will show you if it is a delete permissions error. ~Brad Original Message Subject: Re: CFFILE move is copying From: Scott Brady dsbr...@gmail.com Date: Tue, January 12, 2010 3:46 pm To: cf-talk cf-talk@houseoffusion.com That's probably it -- though, I guess I'd expect an error to result. I guess I can try deleting after the move -- not a solution, but it might tell me if the file is locked. (It's just a text file, so not much should be locking it) Scott On Tue, Jan 12, 2010 at 2:24 PM, Dave Watts dwa...@figleaf.com wrote: Well, a move is basically just a copy followed by a delete. So maybe CF can't delete the file? Maybe it's locked by CF itself, preventing it from being deleted. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329607 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Recent SQL Injection attacks
Yes. All from ip 91.212.226.161 Which we have blocked at our firewall. Annoying, but we saw these coming 2 summers ago, and took steps. On Tue, Jan 12, 2010 at 6:05 PM, Michael Dinowitz mdino...@houseoffusion.com wrote: Has anyone seen any recent SQL injection attacks on their sites or in the wild? I just cleaned a bunch of JS and other code from a clients DB. Most of the scripts were running those fake anti-virus popups but some had other things like lung cancer scams. Anyone see anything? Thanks -- Michael ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329608 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: QoQ DataType Error
Hi James, Did you ever get past this? I am running code that gets this exact qoq error (The value '' cannot be converted to a number), but here's the twist: It only happens on our fully updated and patched cf8 production server (original install would have been cf8 I think). On our shared dev server (installed at 8.0.1 and subsequently patched) and a shared cf9 dev server it doesn't happen. I am absolutely stumped and I can't get it out of my head that its an internal issue to cf that has been fixed somewhere. That means that any effort invested in fixing it for our production box could well be negated with the right patch. I can't see anything on the Adobe site that references this though. Thanks Duncan On Thu, Jan 1, 2009 at 7:00 AM, James Davis jamesda...@kaleidasystems.comwrote: Hey all, got a brain buster for you: I have a query object result that I'm building out in a function. I've defined all my query column datatypes. The problem is that for one column, the datatype is varchar, but the data in this particular instance is all numeric, save 1 row that is an empty string. Note: The data being all numeric is coincidental. The field is user-defined data, which is why it was declared a varchar field. When I do a query of queries on result, I get an error thrown saying The value '' cannot be converted to a number. Double checked myself by dumping getMetaData(result), and sure enough, the column data type is varchar. Even doing cfquery name=result dbtype=query SELECT * FROMresult /cfquery Throws the same error! I know ColdFusion is seeing all the numeric values, and casting it as a numeric variable behind the scenes, but this is NOT what I want it to do. How can I get the blasted QoQ to work without throwing the error?!? James Davis Software Engineer Kaleida Systems, Inc. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329609 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Recent SQL Injection attacks
Didn't know about that IP. Thanks They got in through some code that was written literally 10 years ago on one of the clients forgotten sites. I've fixed up the cfquery tags and added my anti-injection code to the whole dir. Thanks -- Michael On Tue, Jan 12, 2010 at 6:31 PM, Jerry Johnson jmi...@gmail.com wrote: Yes. All from ip 91.212.226.161 Which we have blocked at our firewall. Annoying, but we saw these coming 2 summers ago, and took steps. On Tue, Jan 12, 2010 at 6:05 PM, Michael Dinowitz mdino...@houseoffusion.com wrote: Has anyone seen any recent SQL injection attacks on their sites or in the wild? I just cleaned a bunch of JS and other code from a clients DB. Most of the scripts were running those fake anti-virus popups but some had other things like lung cancer scams. Anyone see anything? Thanks -- Michael ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329610 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Problem deleting structure in an array
Chad Qing Xia: Thanks for your responses. You are both correct. But I still can't figure out how to fix it. Chad: I used cfdump in the loop and what is happening is that the session.shopping array index is decreasing by 1 every time one structure is deleted. Which makes sense. When the index is off it can't find the others. Qing Xia: This statement is correct. I bet the error happens only if item 3 is selected. If you do 1 and 2 then you'll get the original number 2 remaining in the array. However, I don't understand how this would work: So maybe you can figure out which array index values are NOT selected for deletion, clear out the original array and insert the un-deleted array elements back in there. I have tried to compensate for that in the loop but nothing works so far. It seems I need to decrease the session.shopping [i] by 1 every time it loops. Or maybe there is another way to accomplish this? I tried the array resize function and did not work. cfset private.arraycount = #arrayLen(session.shoppingcart)# cfloop from=1 to=#arrayLen(session.shoppingcart)# index=i cfif StructKeyExists(rc,itemid i) cfset private.temp = arrayDeleteAt(session.shoppingcart,i) cfset private.arraycount = private.arraycount - 1 cfset private.resize = ArrayResize(session.shoppingcart,private.arraycount) /cfif /cfloop Thanks for any insights. Jaime Chad Gray wrote: My best guess is if you remove one item it changes the structure of the array and when it goes to remove the next one it cannot be found? Use CFDump to display the array as you are looping over it to help debug. This way you can see the way the array is changing as you are removing items. -Original Message- From: jrmuniz [mailto:jrmu...@sfsailing.com] Sent: Tuesday, January 12, 2010 4:16 PM To: cf-talk Subject: Problem deleting structure in an array Hello: Sorry, I forgot the subject in my last post. I'm having an issue deleting a form structure that is in a shopping cart array. I'm sure it's something simple I'm doing wrong, but it's driving me crazy. I have a checkbox to select which items to delete. If only one item is selected there is no error and it works fine. If more than one item is selected then the error is triggered. Strangely, if I resubmit the form after the error it works OK. If I select two items to delete the error is: The error message is Element at position [3] doesn't exist in array Here is the form code: cfloop from=1 to=#arrayLen(session.shoppingcart)# index=i tr td cfinput type=checkbox value=#i# name=itemid#i# /td td cfinput type=text name=quantity#i# value=#session.shoppingcart[i].quantity# size=3 /td td cfinput type=text name=catalogno#i# value=#HTMLEditFormat(session.shoppingcart[i].catalog)# size=10 /td td cfinput type=text name=description#i# value=#HTMLEditFormat(session.shoppingcart[i].description)# size=40/td td cfinput type=text name=price#i# value=#session.shoppingcart[i].price# size=3 /td /tr /cfloop Here is the cfc code: cfloop from=1 to=#arrayLen(session.shoppingcart)# index=i cfif StructKeyExists(rc,itemid i) cfset private.temp = arrayDeleteAt(session.shoppingcart,i) /cfif /cfloop Any help is greatly appreciated. Regards, Jaime ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329611 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem deleting structure in an array
See my previous response. You must remove the item in _descending_ order. That way the element you are trying to remove will always exist. -Leigh ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329612 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem deleting structure in an array
Leigh: My apologies. When I read your post I stopped at the word Yes not realizing there was more. What you are saying makes perfect sense. I'll give that a try. Jaime See my previous response. You must remove the item in _descending_ order. That way the element you are trying to remove will always exist. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329613 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem deleting structure in an array
Yep, Leigh's solution is much simpler. [?] On Tue, Jan 12, 2010 at 9:47 PM, jrmuniz jrmu...@sfsailing.com wrote: Leigh: My apologies. When I read your post I stopped at the word Yes not realizing there was more. What you are saying makes perfect sense. I'll give that a try. Jaime See my previous response. You must remove the item in _descending_ order. That way the element you are trying to remove will always exist. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329614 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem deleting structure in an array
Jaime, No problem. I just wanted to make sure you saw the examples, as I think they give a good demonstration of both the issue and resolution. -Leigh ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329615 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem deleting structure in an array
Hello: For those of you following the tread Leigh had the correct solution. When deleting using a loop, delete in reverse or descending order. It makes so much sense, yet in never occurred to me. That's why I love this list it makes you less dumb. Jaime ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329616 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem deleting structure in an array
That's why I love this list it makes you less dumb. Now that would make a good T-Shirt ;-) Join CF-Talk (It makes you less dumb) ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329617 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4