#1
  1. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Oct 2009
    Posts
    6
    Rep Power
    0

    Format of table columns


    I'm working on a site that's going to query the server every 1-2 seconds, my question is about the format of the tables.

    Lets say I have 7 variables all int with the max number of 40. Would it be best to have all 7 variables inside 1 column (as an array), or have them spread out 7 colums? These variables change pretty often. I'm making a flash chat thingy to be exact.

    Thanks
  2. #2
  3. Contributing User
    ASP Skiller (1500 - 1999 posts)

    Join Date
    Aug 2008
    Location
    USA
    Posts
    1,606
    Rep Power
    347
    not able to get exactly can u plz clear it again or give an example
    if you found this post is useful click Give Rep button (bottom side on this reply ) and agree

    Jquery Shake Effect ,
    Andriod KitKat


    Thank You,
    KiranK
  4. #3
  5. Senior Water Wizard
    ASP Mastermind (5000+ posts)

    Join Date
    Aug 2004
    Location
    Cape Town, RSA
    Posts
    10,233
    Rep Power
    862
    I would suggest you split them into 7 separate columns, otherwise you will have to use split/array functions in the code to reference the values instead of just referencing the column

    Comments on this post

    • shockelite agrees
    Look! Its a ShemZilla


  6. #4
  7. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Oct 2009
    Posts
    6
    Rep Power
    0
    To markWilson:
    What format would be best?
    7 Columns
    ___________________________________________
    | ID | VAR1 | VAR2 | VAR3 | VAR4 | VAR5 | VAR6 |

    2 Columns
    ____________________________________
    | ID | VAR1,VAR2,VAR3,VAR4,VAR5,VAR6 |


    Thanks nofriends I think you're right.
  8. #5
  9. Contributing User
    ASP Skiller (1500 - 1999 posts)

    Join Date
    Aug 2008
    Location
    USA
    Posts
    1,606
    Rep Power
    347
    yes you can use array for same and split it using (|) and group then into one

Similar Threads

  1. Format problem on linked table
    By 1RandyG in forum Microsoft Access Help
    Replies: 2
    Last Post: July 19th, 2006, 12:46 PM
  2. Saving table in html format to Data Base
    By buzyonok in forum Programming Help
    Replies: 1
    Last Post: September 9th, 2005, 12:35 AM
  3. Replies: 0
    Last Post: July 5th, 2005, 05:40 AM
  4. Linking two columns in a second Table
    By The Architect in forum Microsoft Access Help
    Replies: 12
    Last Post: January 12th, 2004, 03:37 AM
  5. Adding Table Columns, Detecting Existing Structure
    By DigitalSkyline in forum ASP Development
    Replies: 3
    Last Post: October 8th, 2003, 12:52 AM

IMN logo majestic logo threadwatch logo seochat tools logo