Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2009

    Unanswered: Updating varchar column

    I have a front end application which has 4 checkboxes . Each checkbox corresponds to a column in the database . A selection of a particular checkbox would be a 1 in the database . If unselected it is a 0 in the database . There is an additional column which captures all the columns which have a 1 in their column for their corresponding rows . So 1 row can have more than 1 selection of checkboxes . How do I accomplish this using a stored procedure . Using a stored procedure I have been able to capture only 1 value in the G column and not multiple values . G is a varchar column .

    Ex: 1 row . A B C D G
    ABC 1 0 0 0 A
    DEF 0 0 0 1 D,E,F
    GHF 1 1 0 0 A,B,F
    Responses are appreciated .

  2. #2
    Join Date
    May 2009
    Provided Answers: 1
    metro17, Can you give a different explanation and/or a better example? I almost think I see what you want but the example is nothing like what I think you are asking for.

  3. #3
    Join Date
    Feb 2004
    One Flump in One Place
    Yeah - your example looks wrong. Also, instead of A B C D etc could you give the real column names please?
    pootle flump
    ur codings are working excelent.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts