Recordsets with comma delimiters

Results 1 to 3 of 3

Thread: Recordsets with comma delimiters

  1. #1
    Join Date
    Dec 1969

    Default Recordsets with comma delimiters

    My application requires retrieving values from the database.But the entries are stored in one field separated by comma delimiters instead of being a separate record.<BR>Also while adding new record, the values need to go in same field separated by delimiters.<BR>What could be the best solution?

  2. #2
    Join Date
    Dec 1969

    Default Redesign the Database.

    That would be the bset bet.

  3. #3
    Join Date
    Dec 1969

    Default Depends on what you..

    .. need to do with the values. You could start with an array, using the VBS function, Split().<BR><BR>First off, whoever designed the database should be beaten with a spoon. Putting multiple values into a single field is a terrible idea.

Posting Permissions

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