RevQueryDatabase returns a cursor not the result of the SELECT. If you use revDataFromQuery instead, you'll get the result of the SELECT, eg:
put revDatafromQuery(,,DB_ID, "SELECT count(*) as anzahl from MYFILE where something = '"&yxz&"' and something_else = 'false'") into counted Probably don't need the "as anzahl" using that method Pete On Tue, Nov 22, 2011 at 10:19 AM, Inselfan <balearenin...@gmx.net> wrote: > Hola, > > using this: > > put revQueryDatabase (DB_ID, "SELECT count(*) as anzahl from MYFILE where > something = '"&yxz&"' and something_else = 'false'") into counted > > shows me wrong results in counted. Does one of you will be so kind to tell > me my fold? > > thanks > > -- > View this message in context: > http://runtime-revolution.278305.n4.nabble.com/SELECT-count-as-tp4096794p4096794.html > Sent from the Revolution - User mailing list archive at Nabble.com. > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > > -- Pete Molly's Revenge <http://www.mollysrevenge.com> _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
