Updated: 08/06/2000

Multiple Form Selection

Allowing multiple choices of data elements enables people to customize views of your data and adds value to your applications. In this sample code, user inputted choice(s) are added to the basic sql statement to draw them from the db. Since the input from the dropdown menu comes through comma delimited it is simply written into the statement without modification. Two simple for next loops determine which elements are part of the record set and displays them accordingly.

• Categories
  • ASP →
  • Tips and Tutorials →
  • Database-related
• Tags
  • basic sql statement,
  • dropdown,
  • from sql statement,
  • in sql statement,
  • in statement in sql,
  • in statement sql,
  • into sql statement,
  • loops in sql,
  • menu dropdown,
  • set value sql,
  • simple dropdown menu,
  • sql and statement,
  • sql comma,
  • sql comma delimited,
  • sql data,
  • sql for statement,
  • sql loops,
  • sql record set,
  • sql set statement,
  • sql views,
  • views sql
  • ...
• Platforms
  • Linux
• Licenses
  • Freeware