Results 1 to 2 of 2

Thread: WHERE clause...HELP PLEASE

  1. #1
    Laurie M Guest

    Default WHERE clause...HELP PLEASE

    I&#039;ve played around with the following code, with no success. The form on page one has menu populated with various dog breeds, which posts to page two. This is the code that I use on page two is:<BR><BR>if not isempty(Request.Form("SearchByBreed")) then<BR>set RSRescue = objConn.Execute("select * from Rescues where " _<BR>& "DogBreeds = &#039;" & Request.Form("DogBreed") & "&#039;" & "order by OrganizationName")<BR><BR>However, I recently added a STATUS column to the database, and I want to read from the DogBreeds column as well as the Status column, so when a dog breed is chosen, only those groups with "approved" (vs. pending) will show. How can I write this code? Every combination I&#039;ve tried gives me either an error message, or the form will post but will be empty, and not show any clubs/organizations. Thanks in advance from a newbie, muddling along in ASP!<BR>

  2. #2
    Forum Police Guest

    Default Crosspost!

    http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=110<BR><BR>Please read the rules of this messageboard.

Posting Permissions

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