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

Filter results by dynamic drop down

Thread began 8/28/2010 6:37 pm by mckenzie135328 | Last modified 8/31/2010 11:43 am by Jason Byrnes | 970 views | 9 replies |

mckenzie135328

Filter results by dynamic drop down

How do I filter the results of a DataAssist results page via a drop down that is triggered after making a selection instead of the DataAssist Search form that you can lump at the top of the results page?

I haven't done this stuff for about 6 years when I built a custom CMS using interAKT's tools. I remember back then it was easy to populate the drop down with a related tables field/values that could be used to filter your current results page.

In this case the results page will only have 3 fields: img url, name and type.

I need to be able to filter the results by type via a dynamic drop down menu.

The type field is a related field to another table.

Thanks in advance!

Sign in to reply to this post

CraigRBeta Tester

Have you seen the dynamic dropdowns extension ?

it allows you to create cascading parent and child dropdowns from your recordsets.

Sign in to reply to this post

mckenzie135328

Drop Downs

Do I have to combine that with DA Search in order to filter the results?

Sorry for any dumb questions, I only got the extensions yesterday.

Sign in to reply to this post

CraigRBeta Tester

no you don't need DA at all to use this extension, it is separate

Sign in to reply to this post

mckenzie135328

Drop down

I know that, but can it be used in conjunction with DA to filter a DA results page?

Sign in to reply to this post

Jason ByrnesWebAssist

Yes it can.

You can use the dynamic dropdowns just like any other form element to filter the results page.

Sign in to reply to this post

mckenzie135328

drop downs

is there a guide anywhere on how to do this?

Sign in to reply to this post

Jason ByrnesWebAssist

dynamic dropdowns are just like any other form element.


when creating the recordset, in the filtering section, select the column that should be filtered. set the type to Form and then enter the name of the dropdown.

Sign in to reply to this post

mckenzie135328

Drop Downs

Thats what I thought and vaguely remembered although without a default value the results will be blank.

My sql is:

SELECT id_prd, name_prd, type_prd, tnailurl_prd
FROM products_prd
WHERE type_prd = colname

Colname =
Numeric
Default -1
$_POST['type_dropdown']

The Default value returns no records. How do I get the default to return all records?

Sign in to reply to this post

Jason ByrnesWebAssist

you cant do this using a regular recordset, you would need to use DataAssist Search

set the criteria to use the select list and the type_prd column

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