Navigation

Changeset 6532

Timestamp:

09/01/08 15:38:40 (3 months ago)

Author:

ethans

Message:

Changes for sqlite3 syntax for LIKE _% queries and escaping _ properly.

Files:

r6449	r6532
30	30
31	31	// Read old IVR format, part of xtns..
32		$sql = "SELECT context,descr FROM extensions WHERE extension = 's' AND application LIKE 'DigitTimeout' AND context LIKE '".$dept."aa_%' ORDER BY context,priority";
	32	if ($amp_conf["AMPDBENGINE"] == "sqlite3") {
	33	$sql = "SELECT context,descr FROM extensions WHERE extension = 's' AND application LIKE 'DigitTimeout' AND context LIKE '".$dept."aa\_%' ESCAPE '\' ORDER BY context,priority";
	34	}
	35	else {
	36	$sql = "SELECT context,descr FROM extensions WHERE extension = 's' AND application LIKE 'DigitTimeout' AND context LIKE '".$dept."aa_%' ORDER BY context,priority";
	37	}
33	38	$unique_aas = $db->getAll($sql);
34	39	if (isset($unique_aas)) {