comma seperated records

Results 1 to 2 of 2

Thread: comma seperated records

  1. #1
    Join Date
    Dec 1969

    Default comma seperated records

    I need to pull values from a database and fill a drop down box. <BR>In one field is 5 different values all comma seperated. <BR>I know how to fill the drop down I am just not sure how to query the values and remove the comma. Any help would be appreciated. <BR>Thanks!

  2. #2
    Join Date
    Dec 1969

    Default RE: comma seperated records

    Not totaly sure what your getting at here. BUT if you want to seperate the words and remove comma&#039;s then use the split() function.<BR><BR>theArray = Split(recordsetOrString)<BR>For Each word In theArray<BR>response.write(word)<BR>response.write ("&#060;br")<BR>next<BR><BR>Hope that gives you and idea<BR><BR>regards<BR>greg<BR>

Posting Permissions

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