RecordSets with "where clauses"

Results 1 to 2 of 2

Thread: RecordSets with "where clauses"

  1. #1
    Bobby C Guest

    Default RecordSets with "where clauses"

    How could i use a record set with an SQL Select statement with a where clause, using user input from the form as part of the where clause?

  2. #2
    Join Date
    Dec 1969

    Default RE: RecordSets with

    You just put the request object in the SQL statement. For example if someone enters a value for a state you would write the statement as<BR><BR>"Select * From tablename where state =&#039" & Request("State") & "&#039"<BR><BR>Hope this helps<BR><BR>Dennis Branson<BR><BR>P.S. The syntax is different depending on what type of variable you are calling and whether it is a SQL or an Access database. The above will work with a text field but not with a numberic field.

Posting Permissions

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