list box parameters?

Results 1 to 3 of 3

Thread: list box parameters?

  1. #1
    hops Guest

    Default list box parameters?

    Does anybody know how to pass multiple parameters from a list box so that a database may do search against selected items. Any psuedo code, snipplets or known tutorials are appreciated.<BR>Example:ListBox Values(ZipCodes)<BR>21212<BR>21213<BR>21214<BR><BR >If more then one item is selected how do I pass selected values of ListBox to [(@ZipCode)] <BR><BR>SQL WHERE Clause:<BR>WHERE PropRecordset.ZipCode = [(@ZipCode)] AND<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: list box parameters?

    When you request the multi-line listbox it should give you the result in a list separated by commas i.e.<BR>21212,21213,21214<BR>Then you should be able to use SQL<BR>WHERE PropRecordset.ZipCode IN(" & Request.Form("ziplistbox") & ") AND ....<BR>Any use?

  3. #3
    hops Guest

    Default RE: list box parameters?

    lots of help Thanx I&#039;ll give it a try!

Posting Permissions

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