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

Trying to do an advanced search with MySQLi Server Behavior

Thread began 4/11/2015 12:51 am by Brent | Last modified 4/13/2015 8:19 pm by Ray Borduin | 1091 views | 5 replies |

Brent

Trying to do an advanced search with MySQLi Server Behavior

I am doing a test website before I decide if I am going to continue to use your WebAssist MySQLi Server Behaviors product. I want to be able to search my dvd library to decide what we are going to watch. I have a database with the name, genre, rating, length, etc. I want to be able to type into a for "Comedy" and have it bring up all movies with "Comedy" in the genre even though the actual genre might be "Romantic Comedy" Then I would like to be able to select a year of release such as "Newer than 2010" I can find the "=" statement in the query but I can't make it do a "LIKE" query, "greater than", etc. Also sometimes it's nice to go, Oh yeah, I remember one called something like "Hobbit" and be able to bring up all the movies with "Hobbit" in the title. Let me know if this is an available feature that I just can't see or if I need to request a refund. Actually I may as well request a refund now because I looked pretty hard already.

Sign in to reply to this post

Ray BorduinWebAssist

It can be done pretty easily by writing the correct SQL statement. If you had the page ready and gave it a try we could point out any issues and help you get it done.

Sign in to reply to this post

Brent

I was thinking that the software would write the code and that I would not have to. I am doing an upgrade from, don't laugh, FrontPage and with it I never had to write any code. I did have a bit of code I used but I had compiled a cheat sheet that I could use to cut and paste in where needed. Let me give this another try but if I need to write the code I'm going to have to request a refund. I will give it a good shot though before I do that.

Sign in to reply to this post

Chad

We can help you write the sql statement when you get to that point, we would just need specific information about your tables and what you are trying to do. If you gave it a try and sent us over what you had we could probably give you the code to update and what to update it to.

Sign in to reply to this post

Brent

After thinking about it I don't think I want to have to contact you every time I want to make a change. How do I request a refund?

Sign in to reply to this post

Ray BorduinWebAssist

Just send an email to sales@webassist.com with your refund request including your order id.

Sign in to reply to this post

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