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.

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

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.

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!!)

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

See PM

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

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

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

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.