Re: [phpesp-general] more on the ADODB Bug?

[Christopher K. <ck...@im...>]

Hi Everyone (and Matt).  I am seeing some of the same error messages 
that Matt reported last week.  I put in his fix but it did not help 
me out when using the view response report feature.  It is mixed 
likert and open text data.  When I try to look at an individual 
response I see the text answers but no likert items.  Here is a 
segment of the results page, it continues this way all the way down.

Section One: Teaching
1. What do you see as the strengths of this teacher's approach to teaching?
Notice: Only variable references should be returned by reference in 
/home/.nana/imsarese/imsaresearch.org/survey/admin/include/lib/adodb/adodb.inc.php 
on line 859
#Response
2. What suggestions do you have to improve the teaching in this course?
Notice: Only variable references should be returned by reference in 
/home/.nana/imsarese/imsaresearch.org/survey/admin/include/lib/adodb/adodb.inc.php 
on line 859
#Response
3. The teacher has clearly communicated the learning objectives and 
expectations of this course.
Notice: Only variable references should be returned by reference in 
/home/.nana/imsarese/imsaresearch.org/survey/admin/include/lib/adodb/adodb.inc.php 
on line 859

Running php5.x  mysql 4.1 (dreamhost).  Note it was working earlier 
in the morning and just started throwing the errors all of 
sudden.  Any suggestions?  Thanks,

--chris


At 03:54 PM 10/16/2006, you wrote:
>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
>-------------------------------------------------------------------------
>Using Tomcat but need to do more? Need to support web services, security?
>Get stuff done quickly with pre-integrated technology to make your job easier
>Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
>_______________________________________________
>phpESP-general mailing list
>php...@li...
>https://lists.sourceforge.net/lists/listinfo/phpesp-general

/////\\\\\/////\\\\\
Christopher G. Kolar
    Coordinator of Research and Evaluation
    Illinois Mathematics and Science Academy
  ck...@im...  -- 
<http://staff.imsa.edu/~ckolar>staff.imsa.edu/~ckolar --  PGP Public 
Key ID: 0x43879C9B