RE: [binarycloud-dev] sql + QueryExample

[Andreas A. <a.a...@th...>]

Hi Alex,

>
> So it worked, the data is there.
>
> I run the page and get:
>
> Module:
> NewsId    News
>
> which I assume means that there are no results to display.
>
> I look below, and find:
>
>
>
>
> QueryManager: Database setup complete
> QueryManager: Added query with id 20fd8766d8ae63f7eb407ffe7617de6e to
> querylist
> QueryManager: About to execute: 20fd8766d8ae63f7eb407ffe7617de6e
> QueryManager: Handle is: 1
> QueryManager: Query is: SELECT newsid, news FROM news
> QueryManager: Sucsessfully executed query
>
>
> then:
>
> = Variables
> ==========================================================================
>
> QueryManager: Result columnames: Array
> (
>     [NEWSID] => 0
>     [NEWS] => 1
> )
>
> ...............................................................
> QueryManager: Resultbuffer: Array
> (
> )
>
> ...............................................................
>
>
> I'll look into this tomorrow, anywhere you can point me?
Hmm. I think thats a problem with the column naming. They are mixed case in
MySQL and also retured in mixed case with the result meta data while they
seem to be upper case in oracle.
I'm not experienced with oracle so I'm not comfortable with the differences.
But I guess thats the prob.

Note/Assumtion:
So the changes you made to the schmema will work with oracle but not with
mysql. MySQL assumes that the column newsId in the SELECT statement
represents exactly the fieldname "newsId" in the table. So SELECT newsid and
SELECT newsId are acutually addressing two different fields in MySQL.

But back to the prob: Try the following:

Look at QueryManager line 636:
and uncomment this line:

$_buffer[$row][strtoupper($field)] = $value;

and comment out the following:

$_buffer[$row][$field] = $value;

Then in the output method of the query_example the asoc array should be
changed to macht the uppercase indices.


Andi