Re: Could use some inputs
On Thursday 06 Aug 2009, Gerald Guido wrote: Don, This scenario has been repeated so many times with your posts it is as it follows a script. One could call it The Don Show. To be slightly constructive about it, the OP might want to read http://catb.org/esr/faqs/smart-questions.html#intro -- Helping to ambassadorially industrialize information 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:325242 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Could use some inputs
And if this is the case, I would guess that you are using some kind of component that is a singleton and maintaining its id field state - thus updating an existing record rather than creating a new one. Dominic 2009/8/5 Maureen mamamaur...@gmail.com You can't delete a row without delete, but you can overwrite it, which appears to be what is happening here. The last row written is overwriting the previous rows because the identity field is not changing. ~| 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:325243 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Could use some inputs
Here's a situation I hope you could provide some thoughtful input. I've converted a cf8-based app into an open source one. Initially it seemed all's well but lately, right when I'm ready to deploy it (not to be hosted like many do), some core functionality like automatically data saving, normal data saving are no longer reliable, let me explain. I have a form for data entry with multiple fields. Function 1: auto save the data elements at an interval, thanks again Sam. This feature does not seem to be consistently reliably on the new platform but this function is less critical. Function 2: manually save the form, this one now is a MAJOR PROBLEM! the form data is saved/updated all right, BUT it deleted 2 or 3 most recent rows of the data table (all with data of required columns)! The query does not delete anything. Would other scripts delete them? No, here's why. Here's the basic structure of this table: id -- title -- content 27 -- 'agri' -- 'one phase of humanity' 28 -- 'indu' -- 'mass production' -- newest entry 29 -- 'new here' -- 'bla bla' -- where id is of identity (1,1) not null Upon clicking on save, rows of id(27 and 28) would be mysteriously gone. I've checked the table does not have any triggers whatsoever, and the machine is totally offline. On some other instances, the newest value and id would replace the second newest one, like upon SAVE, the above would read 27 -- 'agri' -- 'one phase of humanity' -- newest entry 28 -- 'new here' -- 'bla bla' Also, please note there's only ONE user. If it's coding problem, somewhere there's some code like DELETE from theTABLE where Len(title) 0 or something like that but there's absolutely not code across board like that, absolutely not. So, how did they disappear? FYI, I've also provided the open source company a copy of compiled code set (to them it's no different from source code) upon their request in hope of obtaining an flexible installer of their engine, which didn't happen. Also, I don't mind paying 400 or 500 bucks for service of making my app deployable but unlike the online web apps I don't need a full year service... but please do not read too much into this... I'm just laying out facts. Also, I've been using the app for over a year without any of the above mentioned problem. Now, it's extremely unlikely for cf coding issue regarding to this problem, so, who has the motivation and capability to cause this problem? I'm at wits end if any... ~| 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:325210 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Could use some inputs
Don, You are giving us the wrong information here. What you should post is the code in question and a description of the former environment (cf8 + what? MSSQL?) and the new environment. -mark -Original Message- From: Don L [mailto:do...@yahoo.com] Sent: Wednesday, August 05, 2009 8:22 AM To: cf-talk Subject: Could use some inputs Here's a situation I hope you could provide some thoughtful input. I've converted a cf8-based app into an open source one. Initially it seemed all's well but lately, right when I'm ready to deploy it (not to be hosted like many do), some core functionality like automatically data saving, normal data saving are no longer reliable, let me explain. I have a form for data entry with multiple fields. Function 1: auto save the data elements at an interval, thanks again Sam. This feature does not seem to be consistently reliably on the new platform but this function is less critical. Function 2: manually save the form, this one now is a MAJOR PROBLEM! the form data is saved/updated all right, BUT it deleted 2 or 3 most recent rows of the data table (all with data of required columns)! The query does not delete anything. Would other scripts delete them? No, here's why. Here's the basic structure of this table: id -- title -- content 27 -- 'agri' -- 'one phase of humanity' 28 -- 'indu' -- 'mass production' -- newest entry 29 -- 'new here' -- 'bla bla' -- where id is of identity (1,1) not null Upon clicking on save, rows of id(27 and 28) would be mysteriously gone. I've checked the table does not have any triggers whatsoever, and the machine is totally offline. On some other instances, the newest value and id would replace the second newest one, like upon SAVE, the above would read 27 -- 'agri' -- 'one phase of humanity' -- newest entry 28 -- 'new here' -- 'bla bla' Also, please note there's only ONE user. If it's coding problem, somewhere there's some code like DELETE from theTABLE where Len(title) 0 or something like that but there's absolutely not code across board like that, absolutely not. So, how did they disappear? FYI, I've also provided the open source company a copy of compiled code set (to them it's no different from source code) upon their request in hope of obtaining an flexible installer of their engine, which didn't happen. Also, I don't mind paying 400 or 500 bucks for service of making my app deployable but unlike the online web apps I don't need a full year service... but please do not read too much into this... I'm just laying out facts. Also, I've been using the app for over a year without any of the above mentioned problem. Now, it's extremely unlikely for cf coding issue regarding to this problem, so, who has the motivation and capability to cause this problem? I'm at wits end if any... ~| 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:325212 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Could use some inputs
I have help with problems to your motivated issue of capable proportions that might hint to the extinction of the not cf coding issue... Here's a situation I hope you could provide some thoughtful input. I've converted a cf8-based app into an open source one. Initially it seemed all's well but lately, right when I'm ready to deploy it (not Will ~| 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:325232 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Could use some inputs
Don, You are giving us the wrong information here. What you should post is the code in question and a description of the former environment (cf8 + what? MSSQL?) and the new environment. -mark Mark, the converted app uses a cfml engine, sql2005express and Ext (2) for UI, I've tested the converted app in late July, all working, so, recent hiccups struck me as very odd. The query in question did not use cfqueryParam... across board for all sql statements, once took the extra care and another minor thing, it functions as expected, in this sense, the hiccup isn't really a bad thing. ~| 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:325233 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Could use some inputs
What nonsense are you churning out? I have help with problems to your motivated issue of capable proportions that might hint to the extinction of the not cf coding issue... ~| 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:325234 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Could use some inputs
This note is to correct myself, Railo rocks in general and I'm grateful to Gert etc. It's not some sort of promo for them but rather a remedy in case of misunderstanding of the op. ~As you know, I'm impatient and a great friend of mistakes. ~| 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:325236 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Could use some inputs
How about you start with a search of your code base for the word DELETE. Rows can't just be deleted without a DELETE statement. If your app uses stored procedures, you may need to look there. Also check your database for any triggers that may be setup to delete rows. The alternative is that someone is running some sql injection code, but you said you were the only user right? Brook -Original Message- From: Don L [mailto:do...@yahoo.com] Sent: August-05-09 12:29 PM To: cf-talk Subject: Re: Could use some inputs What nonsense are you churning out? I have help with problems to your motivated issue of capable proportions that might hint to the extinction of the not cf coding issue... ~| 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:325237 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Could use some inputs
You can't delete a row without delete, but you can overwrite it, which appears to be what is happening here. The last row written is overwriting the previous rows because the identity field is not changing. On Wed, Aug 5, 2009 at 3:39 PM, cftalkcft...@logiforms.com wrote: How about you start with a search of your code base for the word DELETE. Rows can't just be deleted without a DELETE statement. If your app uses stored procedures, you may need to look there. Also check your database for any triggers that may be setup to delete rows. ~| 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:325238 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Could use some inputs
Don, This scenario has been repeated so many times with your posts it is as it follows a script. One could call it The Don Show. Scene 1 You post a nebulous, vague and rambling post where you don't really ask a question but ask for help. You may provide some pseudo code but nothing that people can actually use to help you trouble shoot the problem. You never ask a direct question that can be answered with out people asking further questions seeking elucidation about whiskey tango foxtrot you are actually talking about Scene 2: PPL who actually want to help ask you to provide more information so they can help you. Scene 3: You state that you have given enough information need for us to solve the problem and reiterate the question. Scene 4: People ask you to post some code because we cannot help you with out it. Scene 5: you begrudgingly post the least amount of code humanly possible. Scene 6: People do your debugging for you and point out that the problem is a bug in your code. Scene 7: Rinse and repeat. Sound about right? HTH, G On Wed, Aug 5, 2009 at 4:15 PM, Don L do...@yahoo.com wrote: This note is to correct myself, Railo rocks in general and I'm grateful to Gert etc. It's not some sort of promo for them but rather a remedy in case of misunderstanding of the op. ~As you know, I'm impatient and a great friend of mistakes. ~| 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:325239 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Could use some inputs
i do not think anyone could have said it better, G! though i did laugh at Will's reply (and even more at DonL's reply to that) :) Azadi Saryev On 06/08/2009 07:09, Gerald Guido wrote: Don, This scenario has been repeated so many times with your posts it is as it follows a script. One could call it The Don Show. Scene 1 You post a nebulous, vague and rambling post where you don't really ask a question but ask for help. You may provide some pseudo code but nothing that people can actually use to help you trouble shoot the problem. You never ask a direct question that can be answered with out people asking further questions seeking elucidation about whiskey tango foxtrot you are actually talking about Scene 2: PPL who actually want to help ask you to provide more information so they can help you. Scene 3: You state that you have given enough information need for us to solve the problem and reiterate the question. Scene 4: People ask you to post some code because we cannot help you with out it. Scene 5: you begrudgingly post the least amount of code humanly possible. Scene 6: People do your debugging for you and point out that the problem is a bug in your code. Scene 7: Rinse and repeat. Sound about right? HTH, G On Wed, Aug 5, 2009 at 4:15 PM, Don L do...@yahoo.com wrote: This note is to correct myself, Railo rocks in general and I'm grateful to Gert etc. It's not some sort of promo for them but rather a remedy in case of misunderstanding of the op. ~As you know, I'm impatient and a great friend of mistakes. ~| 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:325240 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
