"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
1
Reply
AdChoices