I have a database that has several 'Courses' with 'Descriptions'. The classes are to be grouped by 'Category', using a 'CatalogID' as distinct separators. I have the coding to query the database and pull the 'Category' and place it in a drop down menu. But, the 'Courses' and 'Descriptions' are not being pulled onto the page, so somewhere I don't have my query right. I think I've stared at it too long and just can't see where I have the coding wrong. Hopefully someone can look at it and point out my error.

The <form> tag:

<form method="POST" action="select.asp?post=yes" querystring="y">

The drop down list:

<select name="Category" LANGUAGE="javascript" onchange="this.form.submit()">

<% Set rs = Server.CreateObject("adodb.recordset")
cmd = "SELECT distinct CatalogID, Category from Catalog"
rs.open cmd, conn

while not rs.eof
%>

<option value="<% = rs("CatalogID") %>"><%=rs("Category")%></option>

<% rs.movenext
wend
rs.close
%>
</select><noscript><INPUT type="submit" value="Go" name=submit></noscript>

The listing of the 'Courses' with 'Descriptions' on the page:

<% if request.querystring("POST") = "y" Then
Set rs = Server.CreateObject("adodb.recordset")
cmd = "SELECT * FROM Catalog WHERE (Category LIKE '" & request("CatalogID") & "') order by Title"

rs.open cmd, conn

While not rs.eof %>

And the 'Course' listing:

<p><b><% = rs("Title")%></b></p>

<p><%=Rs("Description")%></p>

And, finally, the closing of the loop:

<% rs.movenext
Wend
rs.close
end if
Set rs = nothing
%>

Any help would be appreciated.

Update:

I narrowed the problem down by changing the line:

cmd = "SELECT * FROM Catalog WHERE (Category LIKE '" & request("CatalogID") & "') order by Title"

To:

cmd = "SELECT * FROM Catalog order by Title"

And get the full list of 'Titles' and 'Descriptions', though not in their respective 'Categories'. (of course)

So, my problem appeared to lie in:

WHERE (Category LIKE '" & request("CatalogID") & "')

So I had to ask myself, "Is my logic right in my WHERE statment?" And my answer was "Of course not." I had my WHERE statement backwards. It should read:

WHERE (CatalogID LIKE '" & request("Category") & "')

Works like a charm.

OK. It works. I just don't know why you are using LIKE.... Wouldn't the CategoryID actually equal (=) the CategoryID you're trying to pull?

I'm using LIKE because I'm a beginner and that was the example I had to go by. But I do know I can't use = because the values in CatalogID are different from Category, that they are not =.

I did not know that my beginner status would offend so much, and would warrant such an out-of-patience answer. I'm sorry and will stay out of these forums until I have a better handle on the programming.

I think jackiew has to chill out. I didn't think the reply from rstelma was offensive in the least and had a valid point. It was just a question after all.