nuBuilder Forum

Code: Select all

[0] : 
===USER==========

globeadmin

===PDO MESSAGE=== 

SQLSTATE[42000]: Syntax error or access violation: 1064 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 'HIGH'' != ''
					ORDER BY prosup_code' at line 5

===SQL=========== 


					SELECT product_supplier_id, prosup_code, prosup_description
					 FROM product_supplier   JOIN product ON product.product_id = product_supplier.prosup_product_id
					 WHERE prosup_supplier_id = 'a0ba5ff9ec808d1'
					AND (prosup_code LIKE ? OR prosup_description LIKE ?)
					AND ''HIGH'' != ''
					ORDER BY prosup_code
					

===BACK TRACE====

/var/www/html/core/nuform.php - line 829 (nuRunQuery)

/var/www/html/core/nuapi.php - line 79 (nuGetAllLookupList)

Code: Select all

	$s				= "
					SELECT $id, $code, $description
					$SQL->from
					$SQL->where
					AND $code = ?
					ORDER BY $code
					";

	$s				= nuReplaceHashVariables($s);
	$t				= nuRunQuery($s, array($C));

Code: Select all

	$s				= "
					SELECT $id, $code, $description
					$SQL->from
					$SQL->where
					AND $code LIKE ? AND '$C' != '' 
					ORDER BY $code
					";

	$s				= nuReplaceHashVariables($s);
	
	$t				= nuRunQuery($s, array('%' . $C . '%'));