Home > SQL Development > multiple selections from a listbox into a query?

multiple selections from a listbox into a query?



<i><b>Originally posted by : geniene (geniene_c@hotmail.com)</b></i><br />I have two list boxes that I have populated and two text boxes. The user has the option to select from both list boxes and enter two dates to query a sql database and display a resultset on another asp page.<br /><br />It works as-is, but I want to offer the capability to make more than one selection in the list box. I have the list box multiple property set, but can't figure out how to formulate the code to grasp more than one selection.<br /><br />Any help would be greatly appreciated, this is a college project and it's due today.

    
Guest


<i><b>Originally posted by : sharjeel imtiaz (sharjeel_ii@hotmail)</b></i><br />check the property of listbox to multiple<br />check it .<br />cn.open<br /><br />then <br />open a recordset "tablename",cn,cursortype,lockingtype <br /><%<br />rs.open "select date from table where fieldname= '"& request.field("fieldname")&"'",cursotype,lockingtype<br />%><br /><form mehtod=post><br />take inputfield hidden <inputfield value="<%rs.field("date")%>"<br /></form><br /><%<br />rs.close<br />set rs=nothing<br />cn.close<br />set cn=nothing<br /><br /><br />------------<br />geniene at 5/29/2002 11:15:25 AM<br /><br />I have two list boxes that I have populated and two text boxes. The user has the option to select from both list boxes and enter two dates to query a sql database and display a resultset on another asp page.<br /><br />It works as-is, but I want to offer the capability to make more than one selection in the list box. I have the list box multiple property set, but can't figure out how to formulate the code to grasp more than one selection.<br /><br />Any help would be greatly appreciated, this is a college project and it's due today.

Was this answer helpful ? Yes No   
Guest
 
 
Home - About Infoqu - Contact - Privacy Statement - Link to Infoqu - Bookmark Infoqu

Copyright 2007-2008 by Infoqu. All rights reserved