Re: [Exist-open] sql:result changed

[Adam R. <ad...@ex...>]

I dont have much time right now, but will try and take a look over the
weekend. Something from what you are saying does not sound right...

Cheers Adam.

2009/6/18 Andrew Hart CEMS Staff <And...@uw...>:
> Adam (or anyone)
> On our old 1.1.2 server we had some code cut down to this:
>
> declare namespace sql ="http://exist-db.org/xquery/sql";
> let $connection := sql:get-connection("com.mysql.jdbc.Driver",
> "jdbc:mysql://web00.cems.uwe.ac.uk/software", "reader", "password")
> let $sql :=  concat("SELECT * FROM sw_packages WHERE sw_packages.name
> like  '%","micro","%';")
> let $result := sql:execute($connection, $sql, fn:true())
> return $result/sql:result/sql:row
>
> which would return (not important but included for clarity) :
> <sql:row xmlns:sql="http://exist-db.org/xquery/sql"
> index="1"><package_id xmlns:xs="http://www.w3.org/2001/XMLSchema"
> sql:type="INTEGER" ...
>
> On a newer version the query returns nothing BUT
>
> $result/* returns similar data:
> <sql:row xmlns:sql="http://exist-db.org/xquery/sql"
> index="1"><sql:package_id xmlns:xs="http://www.w3.org/2001/XMLSchema"
> sql:type="INTEGER" ...
>
> so package_id becomes sql:package_id, this seems sensible.  What I don't
> understand is why there is a difference in 'depth' if that is the right
> word?
>
> return $result/* returns something beginning with <sql:result... on the
> old version
>
> Do I have to do if ($existversion == 1.1.2) do x else do y to get it to
> work on both?
>
>
>
>
> This email was independently scanned for viruses by McAfee anti-virus software and none were found
> ------------------------------------------------------------------------------
> Crystal Reports - New Free Runtime and 30 Day Trial
> Check out the new simplified licensing option that enables unlimited
> royalty-free distribution of the report engine for externally facing
> server and web deployment.
> http://p.sf.net/sfu/businessobjects
> _______________________________________________
> Exist-open mailing list
> Exi...@li...
> https://lists.sourceforge.net/lists/listinfo/exist-open
>



-- 
Adam Retter

eXist Developer
{ United Kingdom }
ad...@ex...
irc://irc.freenode.net/existdb