Re: [sqlite] Shell doesn't do

[Kit]

2011/8/10 Simon Slavin <slav...@bigfraud.org>:
> However, the tags the shell tool generates are upper case.  There are two 
> possible fixes:
> a) change the tool to generate lower-case tags.
> b) change the documentation to say that the tags are HTML, not XHTML.
> Simon.

OK, here is the patch.
-- 
Kit

diff --git a/src/shell.c b/src/shell.c
index a54c922..337f35a 100644
--- a/src/shell.c
+++ b/src/shell.c
@@ -746,22 +746,22 @@ static int shell_callback(void *pArg, int nArg,
char **azArg, char **azCol, int
     }
     case MODE_Html: {
       if( p->cnt++==0 && p->showHeader ){
-        fprintf(p->out,"<TR>");
+        fprintf(p->out,"<tr>");
         for(i=0; i<nArg; i++){
-          fprintf(p->out,"<TH>");
+          fprintf(p->out,"<th>");
           output_html_string(p->out, azCol[i]);
-          fprintf(p->out,"</TH>\n");
+          fprintf(p->out,"</th>\n");
         }
-        fprintf(p->out,"</TR>\n");
+        fprintf(p->out,"</tr>\n");
       }
       if( azArg==0 ) break;
-      fprintf(p->out,"<TR>");
+      fprintf(p->out,"<tr>");
       for(i=0; i<nArg; i++){
-        fprintf(p->out,"<TD>");
+        fprintf(p->out,"<td>");
         output_html_string(p->out, azArg[i] ? azArg[i] : p->nullvalue);
-        fprintf(p->out,"</TD>\n");
+        fprintf(p->out,"</td>\n");
       }
-      fprintf(p->out,"</TR>\n");
+      fprintf(p->out,"</tr>\n");
       break;
     }
     case MODE_Tcl: {
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users