#013877: incorrect Case required for ezcGraph::KEY and ezcGraph::VALUE

Description:

for some reason when you set ezcGraph::KEY and ezcGraph::VALUE you must set them to lowercase regardless of how it is returned from the database.

The result of this is that you end up getting a ezcGraphDatabaseMissingColumnException error.

This shouldn't happen. It's quite valid to say 'SELECT col1 AS MyCol FROM mytable'

You would then expect to have to set ezcGraph::KEY or ezcGraph::VALUE to 'MyCol' not 'mycol'.

It may be acceptable to be able to set ezcGraph::VALUE = 'MyCol' and lowercase the string in the setter in the code source.


Environment:

Operating System: Windows
PHP Version: (please be specific, like '4.4.3' or '5.1.5')
Database and version: SQL Server 2000
Browser (and version):


- Attachments

No attachments for this issue.


- Comments

Since there is no way to check the current PDO::ATTR_CASE setting from the statement this just has been documented in revision #9291.

Automatic lowercasing of column names is actually done by PDO by default.

#258944 by Kore Nordmann on November 7th, 2008 [Permanent Link]

- History
Properties
Type Bug
Priority Medium
Component Components
Affects 2008.1RC1 - eZ components 2008.1RC1
Fix Version 2008.2alpha1 - eZ components 2008.2alpha1
Reporter Matt Haddon
Responsible Kore Nordmann
Status 0 Closed
Resolution Fixed
Created November 3rd, 2008
Updated November 7th, 2008
Resolved November 7th, 2008
 
Navigation [Permanent Link]
Previous Issue
Back to Issues List
Next Issue: #015537
  Graph shows to small and truncated rotated axis labels