From 1c49f700c0d056e057a5af2936edb623b61e8735 Mon Sep 17 00:00:00 2001
From: ioguix <ioguix>
Date: Wed, 18 Apr 2007 13:30:58 +0000
Subject: [PATCH] fix a bug when browsing a field with case-sensitive name

---
 tblproperties.php  | 4 ++--
 viewproperties.php | 4 ++--
 2 files changed, 4 insertions(+), 4 deletions(-)

diff --git a/tblproperties.php b/tblproperties.php
index bf61385f..60d3a50a 100644
--- a/tblproperties.php
+++ b/tblproperties.php
@@ -3,7 +3,7 @@
 	/**
 	 * List tables in a database
 	 *
-	 * $Id: tblproperties.php,v 1.75 2007/03/24 02:33:59 xzilla Exp $
+	 * $Id: tblproperties.php,v 1.76 2007/04/18 13:30:58 ioguix Exp $
 	 */
 
 	// Include application functions
@@ -569,7 +569,7 @@
 									'table'		=> $_REQUEST['table'],
 									'column'	=> field('attname'),
 									'query'		=> replace(
-														"SELECT %column%, count(*) AS \"count\" FROM %table% GROUP BY %column% ORDER BY %column%", 
+														'SELECT "%column%", count(*) AS "count" FROM %table% GROUP BY "%column%" ORDER BY "%column%"', 
 														array (
 															'%column%' => field('attname'),
 															'%table%' => $_REQUEST['table']
diff --git a/viewproperties.php b/viewproperties.php
index 1497775f..9cf021a2 100755
--- a/viewproperties.php
+++ b/viewproperties.php
@@ -3,7 +3,7 @@
 	/**
 	 * List views in a database
 	 *
-	 * $Id: viewproperties.php,v 1.24 2007/03/24 02:33:59 xzilla Exp $
+	 * $Id: viewproperties.php,v 1.25 2007/04/18 13:30:58 ioguix Exp $
 	 */
 
 	// Include application functions
@@ -265,7 +265,7 @@
 								'view'     => $_REQUEST['view'],
 								'column'    => field('attname'),
 								'query'     => replace(
-									"SELECT %column%, count(*) AS \"count\" FROM %view% GROUP BY %column% ORDER BY %column%",
+									'SELECT "%column%", count(*) AS "count" FROM %view% GROUP BY "%column%" ORDER BY "%column%"',
 									array (
 										'%column%' => field('attname'),
 										'%view%' => $_REQUEST['view']
-- 
2.39.5