How to create a drop down menu populated by mysql and selection redirects to a new web page
Can someone help me create a page with a drop down menu populated by a column in a table in my mysql database. Choosing a selection would then redirect you to a new web page with the result of the drop down menu saved in a variable and used in the resulting search in the new page.
Any help appreciated.




Drop Down from DB with Global Var
Hi there,
Attached is a small app that demonstrates this.
There are a few parts here.
The select edtior is populated by a liveVariable from the database. in this case we used cIty from sakila.
To populate the select editor from a livevariable (or any other service variable) use the editor properties to set the dataSet property of the editor
Since we want to use the selected item on another page, we need to create a Global Variable to hold our selection. To do that, select the project, not the page, when creating the varible.
Since our selection is of the type city, we'll create our variable of the type city.
Lastly we use navigation calls to navigate across the pages.
See the attached example app for all the details.
Thanks for the help. I have
Thanks for the help. I have attempted to duplicate your example but don't have enough information to do it. I don't know what to do with your attachment. Remember I am a newbee and need step by step help.
Thanks again for your help
Its simple.
Ok ted, download uncompress the attached file to into your projects folder for Wavemaker. Launch it and you'll see the attached file on the welcome screen along with others that you previously had. Now you can open it. Let us know if you run into further problems.
What Lenny Said
There's also a wiki page about project exports that might help:
http://dev.wavemaker.com/wiki/bin/view/Dev/Project+Exports
Many of the DB driven samples use mysql sakila as a db. You don't really need the db to run the app, you just won't have any data in it. Info about Sakila is here:
http://dev.wavemaker.com/forums/?q=node/1996
(fixed link)
The link to the Sakila link
The link to the Sakila link does not work. Thanks anyway. I have gotten the example to work. Thanks for the help on how to open the zip file and where to put it.
I still need more information about creating a mysql populated drop down menu. The example is fine and it has all the info in it but I don't know how or in what order the menu was prepared. As I said before, I need a step by step procedure to do this. Can someone point me to this?
Drop Downs Menus From MySQL
Ted,
Thanks for noting the bad link. Fixed. The link dialog box flakes out on me sometimes. <g>
Have you seen power point deck in the learning center ? In T Advanced Editors, starting at slide 7, it covers select editors in some detail. Please give that a go. Let us know if that provides the details you seek.
Cheers,
Ed
Another option
Here is another thread with an example included. Use which ever fits best your scenario.
http://dev.wavemaker.com/forums/?q=node/1466#comment-5276
I have tried to configure
I have tried to configure the drop down menu examples to see if I can learn how to do it and NONE of the examples work. I installed the sakila database and installed the examples but nothing. The help on how to do this or setup the examples SUCKS!!!
Wavemaker seems to be an excellant product but the LACK of information on how to use it or books on how to create projects is really aweful!!! I have been going over all the information I can get a hold of but find it really lacking.
Newbees need a lot more hand holding.....
So again please can someone tell me how to create a drop down menu populated from a mysql table and store the result somehow to be used on other pages.
Thanks very much,
Well..
Sorry ted, but being aware of the endless possibilities is simply impossible. If you feel that you can't get it from there just ask politely. Where are you lost in this example? if you are not familiar yet with Wavemaker basics you are better having a look on the training materials before going through some examples because people will guide you to the specifics since the basics are repeated over and over.
http://dev.wavemaker.com/wiki/bin/view/Learning/
Then again, let us know where you are getting stuck with this example.
HTH
I have read all the training
I have read all the training materials you mentioned in the link. These materials are not complete since I believe they are based on a webinar and these are mostly outlines. Does WaveMaker do classes? I would be very open to paying for a 2 or 3 day course that I can attend and ask questions as the material is presented. Are there any published books on WaveMaker. I have always prefered books to terse web explanations. I normally purchase 2 or 3 books on the material I am studying since I then get more than one view on how to attack the problem.
Again thanks for the help. Outside of the link you mentioned above are there any other areas I should be looking at to get more help. I have also gone through the help in wavemaker itself.
BTW, I still think that WaveMaker is excellant, but I just need more help to get over the hump and start using it!!
re: Need more help
Hi Ted,
We do offer training courses, you probably saw the base slide decks in the Learning section Lenny linked to. Let's discuss your needs and see if the course meets them. I will contact you via email.
Regards,
Ed