pradosoft / prado

framework/Util/TDbParameterModule.php

Upper-Lower-Casing +2 added lines, -2 removed lines

@@ -169,7 +169,7 @@ 
 		
 		$where = ($this->_autoLoadField ? " WHERE {$this->_autoLoadField}={$this->_autoLoadValue}" : '');
 		$cmd = $db->createCommand(
-			"SELECT {$this->_keyField} as keyField, {$this->_valueField}  as valueField FROM {$this->_tableName}{$where}"
+			"select {$this->_keyField} as keyField, {$this->_valueField}  as valueField FROM {$this->_tableName}{$where}"
 		);
 		$results = $cmd->query();
 		
@@ -289,7 +289,7 @@ 
 		}
 		$db = $this->getDbConnection();
 		$cmd = $db->createCommand(
-			"SELECT {$this->_valueField} as valueField FROM {$this->_tableName} WHERE {$this->_keyField}=:key LIMIT 1"
+			"select {$this->_valueField} as valueField FROM {$this->_tableName} WHERE {$this->_keyField}=:key LIMIT 1"
 		);
 		$cmd->bindParameter(":key", $key, PDO::PARAM_STR);
 		$results = $cmd->queryRow();