FinanceFerret/2.0/sql/qryCbx Accts

From Woozle Writes Code
< FinanceFerret‎ | 2.0‎ | sql
Revision as of 22:56, 30 August 2009 by htyp>Woozle (decided to leave out calculation of parent text; app code can do more stuff with that (links))
Jump to navigation Jump to search

About

  • Purpose: dataset for drop-down boxes
  • Fields:
    • ID: The way this is generated is a bit of a kluge so that each line's "value" will be unique, even though some lines may have "aliases". The HTML drop-down list control seems to reject duplicate values. Appending the ID of the "alias" to the ID we actually want used gives a unique value per line which can easily be converted to the proper value by taking only the integer part.
  • History:
    • 2009-08-30 Created for web interface version

SQL

<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCbx_Accts AS SELECT 

 CONCAT_WS('.',ID_Alias,ID) AS ID,
 Name

FROM Accounts ORDER BY Name;</mysql> <section end=sql />

Retrieved from "https://wooz.dev/mw/index.php?title=FinanceFerret/2.0/sql/qryCbx_Accts&oldid=416"