Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Can't figure out the operator like BETWEEN, coma seperated value etc in advance query builder

View all replies to this thread

Can't figure out the operator like BETWEEN, coma seperated value etc in advance query builder

Thread began 4/20/2020 8:48 am by Rokon | Last modified 4/20/2020 5:44 pm by Rokon | 1246 views | 11 replies

4/20/2020 11:22 amRokon

Originally Said By: Ray Borduin

Try:

HAVING hadithmain.BookID = ? ORDER BY hadithmain.HadithNo ASC");
$mainHadith->bindParam("il", "".(isset($_GET['hadith'])?$_GET['hadith']:"") ."", "-1"); //WAQB_Param1

adding the "l" to the parameter tell it that you are passing an "integer list" and not a single integer.

After changing and passing value to url like index.php?hadith=1,2 it shows
There is an error in your SQL syntax.

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.