Search functionality not working
Hoping to get some help with a search functionality.
Created a search set with 3 fields. None of them since to work. Calling a record set with multiple UNIONs.
Thanks
Hoping to get some help with a search functionality.
Created a search set with 3 fields. None of them since to work. Calling a record set with multiple UNIONs.
Thanks
Your form tag has: method=post
It should be: method="post"
Thank you very much.
Unfortunately, that didn't resolve the issue.
Can I get FTP access and a URL to reproduce? It will be much easier to debug if I have access to the code and can test the page.
I updated the page so I think it will work.
However the recordset doesn't have any results returned to begin with, so I couldn't really test it fully.
Thank you for your quick response. It's working fine.
Is there something I need to be aware of when creating the search?
Any tips provided are appreciated.
You need to wrap UNION SELECTS into a single select statement and add a WHERE at the end to help the search code identify where to add the code properly. You can see the updated SQL statement in your recordset that I used to make it work properly.
Thank you Ray for your quick response.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
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.