Thank you. I'll give this a try...

Yes that is what I want. In my world:

A list of all active courses in department 10 only.

There are 10 departments which have courses listed in the database. ...

Since I've been away for awhile, I need a refresher. This is what I currently have [neither of which not work]:

In my "dir.asp" file:

 

<%...

I don't want ALL active courses. Courses are stored by departments. I want all active courses in department 10 only. Department 10 also has inactive courses.

I don't...

for one of my files, I have the following code. Where would the "WHERE" part of this code fit in.

 

<% Set r = createobject...

Im' new at this and have actually taken over someone else's code so I'm not familiar with the Query analyser. I have two files that is a part of...

Thanks all...I'll give it a try and report back.

I gave an example of what's in the LEDef_Cd field in my post of 6/6/03 at 12:06. The LEDef_ActiveInd field has either a 1 (for true) or a 0...

That's correct. I want ALL active courses AND ALL active courses that starts with the number 10. Using AND does not generate any errors, it just doesn't return...

I want to do both not either or...

In addition to pulling all courses that are active, I would also like to pull all courses from the LEDef_Cd field that begins with the number 10.

I did some Response.Writes and got the following:

Trim(Request('qu')): customer





===================================================================



Request.QueryString: qu=customer&Search.x=27&Search.y=10



replace %A0 strRQS: qu=customer&Search.x=27&Search.y=10



qu=customer&Search.x=27&Search.y=10



replace %26nbsp%3B strRQS: qu=customer&Search.x=27&Search.y=10



strL: qu=



strR: customer&Search.x=27&Search.y=10



strL & @all+ & strR: qu=@all+customer&Search.x=27&Search.y=10



 

Which string do you want me to do a Response.Write on?

I'm not getting an error message, it's just not returning the correct results. This is the code from my search page:

<%



'FOLLOWING SESSION VARIABLES OBTAINED FROM...

I've already tried this but I tried it again and it didn't work:

r.open "SELECT LEDef_PK FROM LEDef WHERE LEDef_ActiveInd = 1 AND LEDef_Cd LIKE '10-%'"