Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › MySQLi Server Behaviors › Query Builder › MySQLi Query Builder returning all and/or random records regardless of search criteria.

View all replies to this thread

MySQLi Query Builder returning all and/or random records regardless of search criteria.

Thread began 11/04/2015 3:27 am by Nathon Jones Web Design | Last modified 1/12/2016 9:00 am by Nathon Jones Web Design | 3460 views | 8 replies

11/04/2015 12:22 pmRay BorduinWebAssist

LIKE and Contains are not valid for integer fields. That is why it is trying to update your SQL to be valid syntax... However I think they should still work though technically invalid MySQL should be smart enough to treat them like text when a LIKE operator is used.

You will have to do that manually after running the Querybuilder, but that doesn't explain the strange results you are seeing. I'd have to debug to figure that one out because it seems like it should work after you made your update.

Please post FTP information in the private area of a response and I'll figure out what is going on.

Did this help? Tips are appreciated...

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.