<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7653.14">
<TITLE>Selectquery display results</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">Firstly thanks for an excellent wiki product.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Here is my problem, I think I may be missing something simple to make this work but at the moment I am unable to locate that piece. I am using selectquery to try to display some records from a local mysql table. </FONT></P>
<P><FONT SIZE=2 FACE="Arial">The selectquery.php page is in the cookbook folder.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Here is the config.php:</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">#adodb db connection</FONT>
<BR><FONT SIZE=2 FACE="Arial">$Databases['smac'] = array(</FONT>
<BR><FONT SIZE=2 FACE="Arial">'driver' => 'mysql',</FONT>
<BR><FONT SIZE=2 FACE="Arial">'hostname' => 'localhost',</FONT>
<BR><FONT SIZE=2 FACE="Arial">'database' => 'smac',</FONT>
<BR><FONT SIZE=2 FACE="Arial">'username' => 'XXXXXXX',</FONT>
<BR><FONT SIZE=2 FACE="Arial">'password' => 'XXXXXX');</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">include "cookbook/dataquery.php";</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">#selectquery</FONT>
<BR><FONT SIZE=2 FACE="Arial">$SelectQuerySettings['database']='smac';</FONT>
<BR><FONT SIZE=2 FACE="Arial">include "cookbook/selectquery.php";</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">This is the query that i try to run on the page.</FONT>
<BR><FONT SIZE=2 FACE="Arial">(:selectquery columns="date, coe_release" tables=release_history where="coe_release > 0" display=debug:)</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">In display=debug mode I get the following response at the top:</FONT>
</P>
<P><FONT FACE="Arial">SelectQuery Version: 2.0 Beta 4<BR>
params key: '#' value: Array<BR>
params key: 'columns' value: date, coe_release<BR>
params key: 'tables' value: release_history<BR>
params key: 'where' value: coe_release > 0<BR>
params key: 'display' value: debug<BR>
params key: 'n' value: Admin.Relhist<BR>
params key: 'author' value: 853232650<BR>
params key: 'PHPSESSID' value: 43efd6ed85c8077ef988764b3adbaf2b<BR>
Processing : date and isliteral:false<BR>
Processing : coe_release and isliteral:false<BR>
query: SELECT date, coe_release FROM release_history WHERE coe_release > 0<BR>
out: 23 rows selected.<br /><br /><table class="selectquery"><tr><th>date</th><th> coe_release</th></tr><tr><td></td><td></td></tr><tr><td></td><td></td></tr><tr><td></td><td></td></tr><tr><td></td><td></td></tr><tr><td></td><td></td></tr><tr><td></td><td></td></tr><tr><td></td><td></td></tr><tr><td></td><td></td></tr><tr><td></td><td></td></tr><tr><td></td><td></td></tr><tr><td></td><td></td></tr><tr><td></td><td></td></tr><tr><td></td><td></td></tr><tr><td></td><td></td></tr><tr><td></td><td></td></tr><tr><td></td><td></td></tr><tr><td></td><td></td></tr><tr><td></td><td></td></tr><tr><td></td><td></td></tr><tr><td></td><td></td></tr><tr><td></td><td></td></tr><tr><td></td><td></td></tr><tr><td></td><td></td></tr></table> </FONT></P>
<P><FONT SIZE=2 FACE="Arial">It seems like the tables are created for the 23 items that are selected but not diplayed at all. Instead I get this as the output on the page:</FONT></P>
<P><FONT FACE="Arial">23 rows selected.<BR>
<BR>
</FONT>
<BR><B><FONT FACE="Arial">date</FONT></B> <B> <FONT FACE="Arial">coe_release</FONT></B>
</P>
<P><FONT SIZE=2 FACE="Arial">The connection is made to the database and the correct results are selected (confirmed by the mysql console) but the results are not displayed on the page. What am I missing or where did I go wrong?</FONT></P>
<P><FONT SIZE=2 FACE="Arial">Thanks,</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Eric Partington</FONT>
</P>
<BR>
<pre>_______________________________________________________________________
This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations.
Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized.
If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately.
Ce courrier électronique est confidentiel et protégé. L'expéditeur ne renonce pas aux droits et obligations qui s'y rapportent.
Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) désigné(s) est interdite.
Si vous recevez ce courrier électronique par erreur, veuillez m'en aviser immédiatement, par retour de courrier électronique ou par un autre moyen.</pre></BODY>
</HTML>