multiple select

Results 1 to 3 of 3

Thread: multiple select

  1. #1
    Join Date
    Dec 1969

    Default multiple select

    ok.. i have a multiple select box with some text values in it. When a user selects 2 items from the multiple select. in the the next page request.form i get values as for e.g aaa,bbb <BR>I need to execute a sql query <BR><BR>select * from columnname in(&#039aaa&#039,&#039bbb&#039)<BR>how do i get those 2 single quotes. Sql doesnt execute the query without those. Anyhelp <BR><BR>thnxx in advance<BR><BR>brij

  2. #2
    karl Guest

    Default RE: multiple select

    This is a real hack job:<BR><BR>Dim frmVar<BR><BR>frmVar = "&#039" & frmVar & "&#039" <BR>frmVar = replace(frmVar, ",", "&#039,&#039")<BR><BR>Karl<BR>

  3. #3
    karl Guest

    Default RE: multiple select

    DOH!<BR><BR>you gotta frmVar = request.form("whatever")<BR><BR>after you declare it and before you start mucking around with it.<BR>I&#039m sure you would have figured that..but hey...<BR><BR>k

Posting Permissions

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