close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Dynamic drop Down with multiple insert

Thread began 12/08/2010 1:20 pm by CreateColl | Last modified 10/16/2011 7:54 am by info97301 | 4921 views | 18 replies |

CreateColl

Dynamic drop Down with multiple insert

Hello
I would like to create a form with three menus link by your dynamic drop down methode.
It's work fine -)))

But now I need to use the multiple insert on this form and when a do this the dynamic drop down does't work.

Is it possible to use multiple insert (or update )with the dynamic drop down menu ?

Best regards
G.S

Sign in to reply to this post

Jason ByrnesWebAssist

No, dynamic drop downs is not compatible with the multiple insert.

Sign in to reply to this post

CreateColl

Bad new for me, any project to go that sens in the futur ?

Sign in to reply to this post

Dave BuchholzBeta Tester

It is possible to do this with jQuery dependant dropdowns like the ones I have here index.html

When I have a few minutes spare I'll write up a blog post on how to achieve this.

Sign in to reply to this post

CreateColl

Hy Dave,
can you give me the link to download the jquery source please, I'll try to do it with the multiple insert.

I also work with document.php?id_doc=62, very powerfull +++ because with one recordset you can link up to five or more menu.

But to make it work with the multiple insert, we have to put also the hand in the motor like with the WA solution...,

Otherwith there is the ADDT solution, I'm not sur but I think it menage the mixt dynamic DD * multiple transaction, as I try to go with WA now I'm looking for a direct solution if possible.

Sign in to reply to this post

Dave BuchholzBeta Tester

This is the code for the jQuery Plugin

/*
* jQuery Dynamic Dependant Select Lists
*/
function makeSublist(parent,child,isSubselectOptional,childVal){$("body").append("<select style='display:none' id='"+parent+child+"'></select>");$("#"+parent+child).html($("#"+child+" option"));var parentValue=$("#"+parent).attr("value");$("#"+child).html($("#"+parent+child+" .sub_"+parentValue).clone());childVal=(typeof childVal=="undefined")?"":childVal;$("#"+child).val(["'+ childVal +'"]).attr("selected","selected");$("#"+parent).change(function(){var parentValue=$("#"+parent).attr("value");$("#"+child).html($("#"+parent+child+" .sub_"+parentValue).clone());if(isSubselectOptional){$("#"+child).prepend("<option value='none'> -- Select -- </option>")}if($("#"+child+" option").length==0){$("#"+child).prepend("<option value=''> -- No Options Available -- </option>")}if($("#"+child+" option").length==1&&$("#"+child+" option").val()==""){$("#"+child).empty().prepend("<option value=''> -- No Options Available -- </option>")}$("#"+child).trigger("change");})};



you will obviously need to include jQuery itself as well.

Sign in to reply to this post

Jenny I

Hi Dave

Does this code work independantly of WA Dynamic Dropdowns? Do you have a tutorial you can point me to? I am a J query novice.

I am looking at the code you have posted but have no idea how to implement it.

Your Help is much appreciated

Sign in to reply to this post

Dave BuchholzBeta Tester

Jenny,

describe what you are trying to achieve and I'll do my best to help you.

Sign in to reply to this post

Jenny I

Thanks Dave

I am trying to incorporate a dynamic dropdown with data assist multiple insert.

I have a table in my database called mediaLibrary. I have created an upload folder called Media-Library in my site root and all files uploaded go in this folder.

Basically I am trying to create a website where an admin can create training series that can be viewed on the public site (a bit like lynda.com). I am currently making the admin part of my site.

In order to make my site scalable I had to create a table (mediaLibrary) that stores all files, another table (trainingLibrary) that allows users to select items from the mediaLibrary table. I then have another table called trainingSeries and the primary key for this table is stored as a foreign key in the trainingLibrary table.

So say for example an admin wanted to create a new training series with 20 videos. I would like to apply dataassist multiple insert and your jquery solution on the trainingLibrary insert page, where the mediaLibrary table would be the child and mediaLibraryCategory (e.g. audio, video) would be the Parent table.

Sign in to reply to this post

Dave BuchholzBeta Tester

Have you got a multiple insert/update form set up yet ?

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