Date: Tuesday March 19, 2024
Time: 2024-03-19
System Error: General Search SQL Query execution failed
SQL statement: select citemno, cdescript, nprice, nspprice, dspstart, dspend, onhand, nbook, nonorder, cclass, zweb, zccategory, zcauthor, zcauthor2, zcbooktype, category, size_display, zsize, zsize2, nweight, nlistprice, flagpromo, promodesc, zinstcode, zdesccode, zdesccode2, zdesccode3, cprodline, zbrand, zbrand2, zextcolor, zintcolor, zextcolor2, zintcolor2, subcat, subcat2, style, style2, style3, itype, itype2, itype3, webcat, webcat2, zinstcode2, zinstcode3, zinstcode4, zinstcode5, zinstcode6, editor, nweightrange, npricerange, npricerange2, npricerange3, sortprice from smusicsearch WHERE (ZINSTCODE2 = 'VA' or ZINSTCODE3 = 'VA' or ZINSTCODE4 = 'VA' or ZINSTCODE5 = 'VA' or ZINSTCODE6 = 'VA') and (WEBCAT = 'IB'or WEBCAT2 = 'IB') and ( ((dspstart <= '2024-03-19' and '2024-03-19' <= dspend and nspprice>= ) or ('2024-03-19' > dspend and nprice>=)or ('2024-03-19' < dspstart and nprice>=) ) ) and (itype = 'BW')
DBI::err: 1064
DBI::errstr: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') or ('2024-03-19' > dspend and nprice>=)or ('2024-03-19' < dspstart and nprice>' at line 1