how is this? -- You received this bug notification because you are a member of Aiki Framework Admins, which is subscribed to aikiframework. https://bugs.launchpad.net/bugs/760414
Title: SQL COUNT doesn't display if called inside a widget Status in Aiki Framework: Confirmed Bug description: Say I need to display the number of a certain batch of records that have been returned from within an inner-widget sql. I would type something like: (sql( (SELECT COUNT(some_field) as 'number' FROM some_table || [-[number]-] ) )sql) The sql appears to execute, but I can't get the number to output to display on a webpage. I've also tried to use the global variable [records_num] within the inner-SQL & that also fails to display. The same SQL statement, if inserted in the Aiki Query section (and [-[number]-] is switched to ((number)) ), will execute as expected. To manage notifications about this bug go to: https://bugs.launchpad.net/aikiframework/+bug/760414/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~aikiframework.admins Post to : [email protected] Unsubscribe : https://launchpad.net/~aikiframework.admins More help : https://help.launchpad.net/ListHelp
