Spry DynamicTable doesn't show data

"Joris van Lier" <whizzrd@hotmail.com> wrote in message
news:fap8lb$km$1@forums.macromedia.com...
> Hi all, I was trying to supply a Spry DynamicTable (spry_p1_5_051707) with
> XML Data from PHP,
> applying the spry code seemed straight-forward enough but I can't get the
> table to show the data,
> it seems the data is being loaded and when I add a column for the @id
> attribute these show up and can be sorted,
> but I don't see my data.....
>
> Here's a link to the page: http://www.artronics.nl/temp/SpryDataSet2.php
> and this is the data loaded by the page:
> http://www.artronics.nl/temp/SpryDataSet2.php?XMLDataSet=Recordset1
>
> So what am I doing wrong?

I found the error of my ways, the ADODB library used by PHAkt defaults to
converting field names to UPPERCASE, thus the node names are uppercase and
spry won't find them, you have to explicitly specify you don't want it to do
that by providing false as the first argument of the GetRowAssoc methiod.
I.e.: $Recordset1->GetRowAssoc(false);// do not uppercase field names

Since ADODB_ASSOC_CASE_NATIVE isn't supported by all adodb database drivers,
I'm curious if spry can be configured to be non-case sensitive with regard
to node names.

Joris