Jump to content

SQL - Using parameters

- - - - -

  • Please log in to reply
No replies to this topic

#1
reachpradeep

reachpradeep

    Learning Programmer

  • Members
  • PipPipPip
  • 41 posts
Hi all, I know I could do something like this in SQL:


select customers.name
from customers
where customers.name = request.form("txtname")


but my question is, can I have a user pick the operator (such as =,>,<,>=,<=) from a dropdown box and pass it the the sql statement as a parameter such as:

select customers.name
from customers
where customers.name request.form("txtoperator") request.form("txtname")

Please help!




1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users