Dynamic Column names

  1. #1

    Dynamic Column names

    hey guys
    i'm running a query that sets column names at run time, and i'm kinda at a loss as to how to setup the columns,
    here's a section of my query
    SELECT 
      district.`name`,
      (SELECT 
        COUNT(NETWORK) 
      FROM
        ACTHIST AS table3
        INNER JOIN abc_development.`stores` AS table1 
          ON CONVERT( table1.`cellsell_id` USING utf8 ) = CONVERT (table3.`STORE_ID` USING utf8) 
        INNER JOIN abc_development.`districts` AS table2
          ON table2.`id` = table1.`district_id` 
      WHERE table3.NETWORK IN ('V24', 'VU24', 'VIPNEW', 'VIPUP') 
        AND table3.ACT_DT BETWEEN '2011-09-1' 
        AND '2011-09-30' AND table2.name = district.name) AS '" +month1name+"'",
    since month1name is being set at runtime, how do i set it up in the aspx section ...Any help will be greatly Appreciated. Thanks
    Last edited by Daniil; Nov 11, 2011 at 9:40 AM. Reason: Please use [CODE] tags
  2. #2
    Hi,

    Do you need to change a column's header on the fly?
  3. #3
    Yes i do.........
  4. #4
    On server or client side?
  5. #5
    on the server side, but i will like to know how to do it on the client side too thanks.
  6. #6
    1. Server. Please see the "Change header" button.
    https://examples1.ext.net/#/GridPane...Configuration/

    2. Client. Please see:
    http://docs.sencha.com/ext-js/3-4/#!...etColumnHeader
  7. #7
    Thanks Daniil

Similar Threads

  1. Data Export Excel Column Names
    By BLOZZY in forum 1.x Help
    Replies: 0
    Last Post: Feb 02, 2012, 2:02 PM
  2. Column Names not vissble while exporting
    By emon in forum 1.x Help
    Replies: 3
    Last Post: Apr 14, 2011, 4:31 PM
  3. Replies: 0
    Last Post: Apr 05, 2011, 4:18 AM
  4. simple gridpanel autogenerating column names
    By lordofthexings in forum Examples and Extras
    Replies: 0
    Last Post: Apr 22, 2010, 1:39 PM
  5. Gridpanel not showing column names
    By unaltro2 in forum 1.x Help
    Replies: 3
    Last Post: Feb 16, 2010, 1:54 PM

Posting Permissions