i check it again and it works.

The only problem is:  if widget have a normal_select that doesn't return
any record,  the (sql( will be no executed. But it's not a bug: if
widget behavior.

** Changed in: aikiframework
       Status: Confirmed => Fix Released

-- 
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:
  Fix Released

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     : aikiframework-devel@lists.launchpad.net
Unsubscribe : https://launchpad.net/~aikiframework-devel
More help   : https://help.launchpad.net/ListHelp

Reply via email to