i have test SQL with a) (sql( (SELECT COUNT(site_id) as number FROM aiki_sites || [-[number]-] ) )sql) b) (sql( (SELECT COUNT(site_id) as 'number' FROM aiki_sites || [-[number]-] ) )sql) c) (sql( (SELECT COUNT(site_id) as number FROM aiki_sites || [-[number]-] ) )sql) (with a break line)
and it work.. can you detail which SQL are you using? -- You received this bug notification because you are a member of Aiki Framework Developers, 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-devel Post to : [email protected] Unsubscribe : https://launchpad.net/~aikiframework-devel More help : https://help.launchpad.net/ListHelp
