Witango-Talk: MySQL mystery...

[Dale Graham]

We have a MySQL database on a remote server. If we develop for it 
locally, SOME of the queries work, but others have the following error 
(a show stopper). I have never seen this sort of error before (with 
Oracle, local or remote or with MySQL, local only). Anyone out there 
have a clue about what is going on?

This query works from the Witango server locally POINTING to the remote 
MySQL database, but gives this error on the Witango server located on 
the same server as the MySQL database.

What in the heck does "Resultset is from UPDATE" mean? (We have no 
action called UPDATE in the TAF, BTW, so I assume that this is a 
generic UPDATE message from the MySQL database.)

[Search Action] [255] GetLinks
[Query] [255] SELECT
h1.htmlunitpageid,h1.htmlunitlinkid,h1.hreftext,h1.avoidflag FROM
htmlunitlinks h1,htmlunitpages h2 WHERE (h2.sessionid=1) AND
((h2.htmlunitpageid=h1.htmlunitpageid)) ORDER BY 3 ASC
[Error] [257] ResultSet is from UPDATE. No Data S1000
[ActionResults] [257]
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf