troubleshooting Question

SQL query to filter numbers

Avatar of d_melnyk
d_melnykFlag for Canada asked on
2 Comments1 Solution1106 ViewsLast Modified:
I'm new to SQL and am trying to create a query in a CF form.  The database records contain information about various meeting rooms, including the size of the room, i.e., number of people it can accommodate.  That d/b field is called Capacity and has a number in each record (i.e., not a range of numbers).  When the user fills in the form, they have the option of typing a number into the Capacity field and they want the search results to show every room that will accomodate that number of people.  How do I structure the query so it will return all the records where the number entered by the user is equal to or less than the number in the database?


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros