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?..

M

manoj9585

Participant

Hi SnakeEyez02,

thanks for the info!.. for a moment I thought it would get solved, but unfortunately.. nothing did the trick..

- as suggested I started with 12,

- then 4

and so on... I've created a brand new page, checked the database (created a test tbl with another name, just in case), I checked all the latest versions of the extensions, disabled & enabled the extensions,.... but am still at the same starting point:

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

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

when I check this file/line(s):

171 else if (control == "PrimaryKeyParameterValue")

172 {

173 var columnInfo = _ColumnList.getValue();

174 if (columnInfo)

175 {

176 var paramValue = _PrimaryKeyParameterValue.getValue();

177 var paramType = _PrimaryKeyParameter.getValue();

178 var paramInfo = dwscripts.getParameterCodeFromType(paramType, paramValue, "");

179 columnInfo.setVariableName(paramInfo.nameVal);

180 }

181 }

I really hope someone got this same error solved... my technical skills are not sufficient to figure this one out...

All tips / help appreciated!

In this case if you search on internet you will get the answer or you can go on website w3cschool for all the information about your problem.

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