#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2000
    Location
    British Columbia
    Posts
    11
    Rep Power
    0
    Is there a way to retrieve the numerical value stored in a SET column rather than the string of elements the number refers to? I want to write a routine to be able to add an element _in the middle_ of a list of set elements. This means that I will have to do some bit-shifting so that elements later in the SET definition will still be flagged properly. I've written up a blurb I can e-mail anyone interested in SETs. I'm hoping someone might have some experience they'd care to share.
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2000
    Posts
    6
    Rep Power
    0
    Why would you want to do this?
    The only reasons I can think of are:
    1) Alphabetizing the list
    2) Relying on the bit-positions for some binary code calls.

    My reply to the above would be:
    1) Not worth the effort. Have the function which gets the list to begin with sort it.
    2) Not portable between architectures



    ------------------
    -Erik


    [This message has been edited by Erik Lindsley (edited March 24, 2000).]
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2000
    Location
    British Columbia
    Posts
    11
    Rep Power
    0
    I'm leaning towards `not worth it`. The idea was to use the memory economy of a SET (one or two bytes rather than one byte per character) while still allowing customization of the list by the user. Customization by alphabetization or whatever. The input would come from a group of checkboxes or a < select multiple> I do have sites where I a droplist is generated from a database table, and the user can add to and rearrange the order of items in the list. I'm trying to implement the same flexibility in displaying the output. Perhaps the way to go is the parse the output string and then arrange the bits...

Similar Threads

  1. help with set operations union,difference
    By reap76 in forum Delphi Programming
    Replies: 0
    Last Post: November 18th, 2003, 08:41 AM
  2. dynamically generate data report using vb 6.0
    By chandra mohan d in forum Visual Basic Programming
    Replies: 1
    Last Post: November 18th, 2003, 04:39 AM
  3. How to check which form fields are set?
    By rob howells in forum PHP Development
    Replies: 6
    Last Post: November 4th, 2003, 06:14 AM
  4. trying to set up own my dns
    By kubicon in forum DNS
    Replies: 0
    Last Post: October 19th, 2003, 05:27 PM
  5. to set a flag (value) to a column
    By chandu in forum PHP Development
    Replies: 3
    Last Post: September 3rd, 2002, 10:11 AM

IMN logo majestic logo threadwatch logo seochat tools logo