Sam,
Do you want to display results via browser in HTML form?
I believe you have to escape tags, amps, etc to get valid HTML in your
result string. For example:
<pre>
<a>aaaaa</a>
</pre>
Ivan
On Wed, Mar 24, 2010 at 9:24 PM, Sam Jones <sam.jo...@myedu.com> wrote:
> Hello folks,
>
> Drat. I mean Nikolay Zavaritsky's PHP API by way of my inability to
> cross reference columns in a table.
>
> The PHP code is very short:
>
> sedna_connect('localhost','auction','samjones','password');
> sedna_execute(<<<EOM
> for \$p in document("auction")/site/people/person
> let \$l := for \$i in
> document("auction")/site/open_auctions/open_auction/initial
> where \$p/profile/@income > (5000 * \$i/text())
> return \$i
> where \$p/profile/@income > 50000
> return <person>
> <name>{\$p/name/text()}</name>
> <items>{\$l}</items>
> </person>
> EOM
> );
> print "<pre>\n"; var_dump(sedna_result_array());
>
> And to recap, what I want is a more structured response -- XML or nested
> arrays.
>
> -Sam
>
> > Hi Sam,
> >
> >
> > Do you mean Alexander's Delphi API?
> >
> > Please, post there also an example of code you run.
> >
> > Ivan Shcheklein,
> > Sedna Team
> >
> > On Wed, Mar 24, 2010 at 8:05 PM, Sam Jones <sam.jo...@myedu.com>
> > wrote:
> > Hello Everyone,
> >
> > I'm new to Sedna and new to Xquery, so I'll have to ask some
> > patience.
> > I'm using Alexander Kardailsky's PHP API for Sedna. I'm
> > executing
> > commands that se_terms return as multi-level XML, but the API
> > returns an
> > indexed array of strings.
> >
> > Here's an example which is a slightly modified version of
> > sample07.xquery on the auction database shipped with the Sedna
> > binary:
> >
> > for $p in document("auction")/site/people/person
> > let $l := for $i in
> > document("auction")/site/open_auctions/open_auction/initial
> > where $p/profile/@income > (5000 * $i/text())
> > return $i
> > where $p/profile/@income > 50000
> > return <items>{attribute person {$p/name/text()},
> > count($l)}</items>
> >
> > In se_term, this query returns this XML:
> >
> > <person>
> > <name>Huei Demke</name>
> > <items>
> > <initial>9.88</initial>
> > <initial>4.12</initial>
> > </items>
> > </person>
> > <person>
> > <name>Jarkko Nozawa</name>
> > <items>
> > <initial>9.88</initial>
> > <initial>4.12</initial>
> > </items>
> > </person>
> > <person>
> > <name>Laurian Grass</name>
> > <items>
> > <initial>9.88</initial>
> > <initial>4.12</initial>
> > </items>
> > </person>
> >
> > Here's the PHP results of the same query.
> >
> > array(3) {
> > [0]=>
> > string(121) "
> > Huei Demke
> >
> > 9.88
> > 4.12
> >
> > "
> > [1]=>
> > string(125) "
> >
> > Jarkko Nozawa
> >
> > 9.88
> > 4.12
> >
> > "
> > [2]=>
> > string(125) "
> >
> > Laurian Grass
> >
> > 9.88
> > 4.12
> >
> > "
> > }
> >
> > It seems that a lot of the structure is lost in the
> > translation. Is
> > there a way I can get the XML result set in PHP? Does the C
> > API do the
> > same thing? Is this even the right place to ask? I thought
> > some
> > version of the query produced a nested array, which would be a
> > good
> > alternative.
> >
> > -Sam
> >
> >
> >
> ------------------------------------------------------------------------------
> > Download Intel® Parallel Studio Eval
> > Try the new software tools for yourself. Speed compiling, find
> > bugs
> > proactively, and fine-tune applications for parallel
> > performance.
> > See why Intel Parallel Studio got high marks during beta.
> > http://p.sf.net/sfu/intel-sw-dev
> > _______________________________________________
> > Sedna-discussion mailing list
> > Sedna-discussion@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/sedna-discussion
> >
>
>
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
