close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Dynamic Lists

Thread began 3/22/2015 5:34 am by markdoyle87077 | Last modified 12/03/2015 2:21 pm by Ray Borduin | 2465 views | 18 replies |

markdoyle87077

Dynamic Lists

I am using Dreamweaver CC 2014.1.1 and I am having trouble using the MySQLi dynamic list behavior. When I click Dymanic in the properties area I get the following 2 errors:

unexpected file format

---------------------------
Dreamweaver
---------------------------
JavaScript error while loading DynamicSelectList.htm:

At line 67 of file "C:\Program Files\Adobe\Adobe Dreamweaver CC 2014.1\Configuration\Shared\Common\Scripts\GridControlClass.js":
this.object has no properties

---------------------------
OK
---------------------------

I have gone to the trouble of uninstalling and re-installing DW and all your extensions. I then tried to use the behavior in question and it worked once but now I get the error.

Done some more testing and if I uninstall and re-install the MySQLi server behavior I can get it to work once before getting the error.

Please help.

Sign in to reply to this post

Jason ByrnesWebAssist

Open the database panel, and dour able click the MySQLi database, press the test button, does the connection test properly?

also:
reset the workspace layout:
go to Window -> Work Space layout -> Reset '<your layout name>'

Then close Dreamweaver and Delete the Dreamweaver Cache file from the users configuration folder:
http://www.webassist.com/tutorials/Common-installation-issues

Sign in to reply to this post

markdoyle87077

The database connection is fine. I have been creating MySQLi today.

I had tried these options before re-installing everything. I have just tried them again and now Dreamweaver locks when you give focus to the dynamic select so I am now uninstalling and re-installing everything. I am sure the error will reappear after this has been done and will update this tocket in about 30 mins.

Sign in to reply to this post

markdoyle87077

Everything re installed and still getting the error. Code in question is runs from line 696 to 705 in the attached file. As stated previously the only way to get the dynamic select to work is to uninstall and reinstall the MySQLi behavior and it will work once before presenting the error again. COuld it be because I am using CC 2014.1.1 build 6981. Are your extensions working for that release? I use to have 2014.1 but it seems to have updated itself (damn you Adode!!)

Attached Files
invoice.php
Sign in to reply to this post

Jason ByrnesWebAssist

Please provide a Skype username or a US phone number and a good time to contact you when you will be in front of your computer and we will have an engineer contact you to resolve this issue over the phone.

We are available Monday - Friday from 9am - 4pm EST (except major U.S. holidays).

Sign in to reply to this post

markdoyle87077

See PM

Sign in to reply to this post

Jason ByrnesWebAssist

I have forwarded your contact info to ray, he should be in contact soon

Sign in to reply to this post

markdoyle87077

MySQLi Errors

Thank you Ray for your time. I hope you can replicate and provide a fix for everyone in your next update. As requested at the time of the call I have found 2 more bugs.

Whenever you amend or insert a WA eCart Get Info From MySQLi RS if corrupts the recordset:

Original recordset:

<?php
$rs_new_order_detail = new WA_MySQLi_RS("rs_new_order_detail",$dmbc_database,0);
$rs_new_order_detail->setQuery("SELECT * FROM cartdetail WHERE orderid = ? ORDER BY packingorder, itemnumber");
$rs_new_order_detail->bindParam("int", "".(isset($_SESSION['order_id'])?$_SESSION['order_id']:"") ."", "-1"); //colname
$rs_new_order_detail->execute();
?>

Recordset after amending or inserting a WA eCart Get Info From MySQLi RS:

<?php
$rs_new_order_detail = new WA_MySQLi_RS("rs_new_order_detail",$dmbc_database,0);
$rs_new_order_detail->setQuery("SELECT * FROM cartdetail WHERE orderid = %s ORDER BY packingorder, itemnumber");
$rs_new_order_detail->bindParam("int", "".(isset($_SESSION['order_id'])?$_SESSION['order_id']:"") ."", "-1"); //colname
$rs_new_order_detail->execute();
?>

it corrupts the WHERE orderid =

Also when you change the default 1 to a zero in the following code:

$dmbc_in_stock->AddToCart(1, "", $dmbc_in_stock_itemID, $dmbc_in_stock_itemName, $dmbc_in_stock_itemDescription, $dmbc_in_stock_itemThumbnail, $dmbc_in_stock_itemWeight, $dmbc_in_stock_itemQuantity, $dmbc_in_stock_itemPrice, $dmbc_in_stock_itemPack, $dmbc_in_stock_itemVD, $dmbc_in_stock_itemLocation, $dmbc_in_stock_itemCost, $dmbc_in_stock_itemCategory, $dmbc_in_stock_itemSupplier);

Dreamweaver freezes/timesout for around 60 seconds and displays this error:

---------------------------
Dreamweaver
---------------------------
A script in file UNKNOWN has been running for a long time. Do you want to continue?
---------------------------
Yes No
---------------------------

Sign in to reply to this post

Ray BorduinWebAssist

I was able to reproduce these issues and we will get a fixed build out tomorrow to address these issues.

Sign in to reply to this post

markdoyle87077

MySQLi Errors

Hi Ray,

Thank you, looking forward to the update. I was also under the impression from the forums that Data Bridge should have been made MySQLi compliant by now. Can you please update on general announcements so the community is aware of the timeline on both Data Bridge and Design Extender.

Kind regards.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...