Participating Frequently

Question

Anyone See this error? cs6 Data Object Delete Record error

Forum|Forum|13 years ago
June 13, 2012
5 replies
13140 views

Have anyone seen this error on Lion Yet? While executing onBlur in DeleteRecord.htm the following JavaScript error(s) occurred: at line 173 ...cs6:Configuration:ServerBehaviors:PHP_MySQL:DeleteRecprd.js": -ColumnList has no properties

Server side applications

This topic has been closed for replies.

A

Alex Tangerine

Participant

If you still want to use Delete Record onBlur I think I found another solution.

I had the same error, but after the error I could choose everything except the table. If you create it anyway you can change the table name directly on the code (it only appears in one place, so it's easy) and you will see on Server Behaviors that Dreamweaver will recognize the change. I don't know if this is exactly your situation, I'm also a beginner, but this worked for me.

Hope this will help someone....

L

lopezpagan

Participant

Hi, maybe this is solve, but in case not, I did something that help.

I had this error too.

CS6 Error (Version 12.0 Build 5842):

While executing onBlur in DeleteRecord.htm, the following JavaScript error(s)occurred:

At line 173 of file "Macintosh HD: Applications Adobe Dreamweaver CS6: Configuration: Server Behaviors: PHP_MySQL: DeleteRecord.js": _ColumnList has no properties

I close DW (ctrl+q) and then opened the DeleteRecord.htm in a TextEditor in Macintosh HD: Applications Adobe Dreamweaver CS6: Configuration: Server Behaviors: PHP_MySQL: . Then I look (ctrl+f) for onBlur and changed to onClick. Like this.

Before: onBlur="updateUI('PrimaryKeyParameterValue', 'onBlur')"

Now: onClick="updateUI('PrimaryKeyParameterValue', 'onClick')"

The error is gone and is working. The thing about this is when the Delete Form loads it doesn't make any action, it will do it when you click.

Maybe this can help.

lopezpagan.com

H

holymackeral

Participating Frequently

WAY TO GO lopezpagan!!

After waiting in vain for over a year for Adobe to fix this bug, your suggested fix worked for me.

You should apply for a job at Adobe... they could use a few good men!! This non-responsive 'support' from Adobe also tells me a lot about upgrading to Adobe's CC... that AIN"T GONNA HAPPEN!!

D

DdoubleU

Participant

YES! I get exactly the same error, too! In my effort to fix the problem (tried ALL the recommendations), I discovered the same error in both Dreamwaver CS6 and CS5.5.

However, get this, the Delete Server Behavior works find in Dreamweaver CS4. So my fix is to open up CS4, apply the Behavior, and then return to CS6—waiting for a fix.

Here’s a recap of the Error Dialog boxes:

CS6 Error (Version 12.0 Build 5842):

While executing onBlur in DeleteRecord.htm, the following JavaScript error(s)occurred:

At line 173 of file "Macintosh HD: Applications Adobe Dreamweaver CS6: Configuration: Server Behaviors: PHP_MySQL: DeleteRecord.js": _ColumnList has no properties

CS5.5 Error:

While executing onBlur in DeleteRecord.htm, the following JavaScript error(s) occurred:

At line 173 of file "Macintosh HD-2: CSS.5: Adobe Dreamweaver CSS.5: Configuration: Server Behaviors: PHP_MySQL: DeleteRecord.js": _ColumnList has no properties

Again, in CS4 it works OK. And, again I’m waiting for fix.

E

EasternOregonOReilly

Participant

Encountered the same problem while trying to implement the Adobe's tutorial on a confirmation form for deletions. Here is the solution I came up with. I used a blank PHP document called "delete.php" that simply had a form and a hiddenText field for the Primary Key that I was passing in.

I implemented DW's delete Server Behavior in that file and even though I got the error message, it still functions.

To delete the file, I created a confirm_delete.php in accordance with tutorial. Then I created two buttons, one titled cancel and the other titled delete. Here is the code for the buttons:

<span class="hiddentext">CONFIRM DELETION</span>

Where confirmclassdelete is the name of my RecordSet in confirm_delete.php.

Works well and I did not have to jerk around with DW error.

T

tharring

Inspiring

You've probably all figured this out by now, but if not, here's what to do:

To isolate the line-item record you want to delete, set up a complete link in your <form action= as shown next> that goes to the Delete.php page using a URL Parameter called recordID, like this:

When you set up the Server Behavior on the deleteItem.php page, set the 1st and 5th field in the "Delete Record" dialog box to "Primary key value", and on the last one, flip to URL Parameter, and enter recordID, not li_id or class_id or member_id. Then you'll get it to work and the record will be deleted.

P

Petkovic7

Participant

Was this ever solved? I am encountering the same error and have had no luck fixing it.

J

Jerry_CannonAuthor

Participating Frequently

No, I have not gotten any additional info re this issue. I noticed an update for dwcs6 but it did not address this issue, or any of the many related issues.

Jerry

J

Jerry_CannonAuthor

Participating Frequently

Still nothing 4 months later......

I

inwebsname

Participating Frequently

Hi,

YES! I get exactely the same error!..

as you said: when trying to delete a record (PHP_MySQL) I got this error... the strange thing however is that I was in the middle of the site (i.e. I created several "delete records" before on other pages - without problem).. and then suddenly this error came up..

hope we get an answer soon... (have to finish my site )

I

inwebsname

Participating Frequently

please... does anyone knows how to solve this ~weird~ problem?.. Is this a bug? Are there more people having this error?..

J

Jerry_CannonAuthor

Participating Frequently

Still Nothing..........

I have made serveral case numbers re this. Adobe keeps responding with emails stateing they believe the case is closed. I can not drop this as it is a critical part of rapid application building. Could I write this code by hand? Sure I could but, DW should write it for me.

Do not give up. Your calls can help shine light on this and get it fixed.

Thanks

Jerry

Taliking with Adobe tech. Started with low level attempt tp blow the case off, then was transfered to the wrong departement and told that I had to pay $250.00 US for a fix. I asked for a supervisor. Several mins later Shemesh Stated that no one was trained to handle this problem and I should look for a fix on public forums. I explained that there is no fix on the forums. Shemesh finally stated that he would ask his manager for assistance. Several more mins later Shemesh stated that no senior tech staff were available and he would arrange for on to call me in about 48 hours. That would make it on a Sunday..... After discussing that error, sometime on Monday was mentioned, which would not work for me as I would be at the hospital on Monday and out of town for a week starting the next day. An agreement was made that a senior tech would call me within a "couple" of hours.

Sooooooooooo, I am waiting!!!!

If there are any Adobe staff, Managers, Superviosrs, Tech Leads, Directors, Officers, Investors, or any other titles who care about your customers today, and want to somehow improve or build customers for tomarrow, please get involved. Not just for me and my problems with your products but to just do the right thing for people who have paid their money for fully functioning products that are not working. While everyone understands that nothing is perfect, we should still try to make things right. There is a need to take the high road in business and politics. If one expect others to be honest and fair, one must be that themselves.

So Adobe..... Get involved where you can, on a corporate level, you will be glad you did.

Thanks

Jerry Cannon

Ps Sorry for the rant with typos!!!!

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded