MDB Arrays

Results 1 to 2 of 2

Thread: MDB Arrays

  1. #1
    Join Date
    Dec 1969

    Default MDB Arrays

    I have a multiple list box and need to return values from a mdb field that is also an array e.g<BR><BR>Request("ListBox") is "Corner, Square, Triangle"<BR><BR>MDB field in rec 1 contains "Corner,Block,House"<BR>MDB field in rec 2 contains "Square,Block,House"<BR><BR>The idea is to return both records<BR><BR>Using &#039;IN&#039; & REPLACE on Request("ListBox") works fine, but only if the mdb field is not an array<BR><BR>Does any one know how I can search a mdb field that is an array. Any help greatly appreciated<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: MDB Arrays

    change the db design. It&#039;s really bad practice to have multiple values in one field

Posting Permissions

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