Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Update Multiple Select prefill existing values

Update Multiple Select prefill existing values

Thread began 2/25/2013 11:15 am by tn228553 | Last modified 9/26/2013 8:13 am by tn228553 | 6961 views | 10 replies

9/25/2013 2:25 pmHeckie

I replaced 5 columns (Style, Category, Age, Location and Venue) in my table with 5 relational tables - DirStyle, DirCat, DirAge, DirLoc and DirVenue.

I had a search results page on my site that worked fine when I had the items comma separated in the Directory table but I can't get the WA Search to work now that I have removed the 5 columns.

I have written (bodged) some SQL (pasted below) to try and replicate the functionality by joining the tables and re-creating the columns.

However, WA Search will not allow me to use choose these columns, even though they appear when I test my SQL in dreamweaver.

Any ideas?

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.