Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Dynamic List/Menu - MySQLi recordset not showing as an option?

Dynamic List/Menu - MySQLi recordset not showing as an option?

Thread began 9/16/2014 5:32 am by Nathon Jones Web Design | Last modified 8/10/2015 11:10 am by Ray Borduin | 2838 views | 14 replies |

9/16/2014 5:32 am | #1 Nathon Jones Web Design

Dynamic List/Menu - MySQLi recordset not showing as an option?

I have a regular drop down menu on my page and I'm clicking the "Dynamic" button to select my MySQLi recordset as the source for the data except DWCC 2014 isn't, once I get to the Dynamic List/Menu properties dialog, showing any recordsets in the "Options from recordset" drop down. It simply states "None".

Problem with DW or problem with MySQLi?

Page attached. Thank you.
NJ

9/16/2014 9:11 am | #2 Jason ByrnesWebAssist

What version of the MySQLi extension do you have installed?

Make sure you have the most recent version, 1.0.2. if you have a previous version, make sure to uninstall it from the extension manager before installing the newer one.

9/16/2014 9:23 am | #3 Nathon Jones Web Design

1.0.2 is already installed.

9/16/2014 9:40 am | #4 Jason ByrnesWebAssist

Uninstall MySQLi 1.0.2 and reinstall. I am not able to reproduce on my system with 1.0.2 installed.

9/16/2014 10:19 am | #5 Nathon Jones Web Design

Re-install fixed it. Thank you.
NJ

9/16/2014 10:23 am | #6 Jason ByrnesWebAssist

you're welcome.

9/30/2014 7:18 am | #7 Nathon Jones Web Design

Hi Jason. This issue has arisen again, so I removed and reinstalled the extension but this time it isn't resolving the issue.
I have uninstalled and reinstalled twice now, including an uninstall, reboot, reinstall, reboot. In short, I've tried everything but the problem remains.
I attach the page for further investigation.

My setup:
Intel i7, 32GB RAM, DWCC2014, MySQLi Server Behaviours 1.0.2

Thank you
NJ

9/30/2014 1:27 pm | #8 Jason ByrnesWebAssist

Can you test the recordsets?

The only way I am able to reproduce this is if I turn of the MySQL server so that the recordsets do not work.

double click the MySQLi recordset and click the test button to make sure they work before trying to use the Dynamic List button.

8/07/2015 9:06 am | #9 anonymous

I'm having this same issue since installation. Newest version of the MySQLi extension and DWCC2015. I give up on working then go home. And voila on my home computer it shows up. Then it stops working and I give up working at home. Next morning on my work computer voila it shows up. Then it stops working......

I've refreshed my files. Tested my recordsets. Deleted and redid my recordsets. Rebooted the computer. Turned computer off for an hour. Refreshed my MySQL server. Nothing solves the issue other than just giving up and going home to another computer.

What is the issue?

8/07/2015 9:24 am | #10 Nathon Jones Web Design

You can't build dynamic menu's in DW with the WebAssist MySQLi recordsets. If you create a MySQL recordset, it will work.

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.