SELECT count(*) as

[Pete]

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 <baleareninsel at 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 at 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>