From: Matt M. <jma...@gm...> - 2006-10-16 20:54:42
|
Hello, I just fixed the issue I reported 2 hours ago. On about line 203 of where/crosstab.inc $sql1 = "SELECT count(*) FROM ".$GLOBALS['ESPCONFIG'][$tbl[0].'_table']." r1, ".$GLOBALS['ESPCONFIG'][$tbl[1].'_table']." r2 WHERE (r1.question_id = ${qids[0]} AND r1.choice_id = '${xx}') AND (r2.question_id = ${qids[1]} AND r2.choice_id = '${yy}') I added the single quotes around ${xx} and ${yy} The lack of single quotes was throwing an error, thinking I was looking at columns named Y or N as opposed to looking at the value within the column. -Matt Miller |