ASP problem

[tasneem]

Hi
Please visit http://deeni.des-us.com/audiolist.asp with username = temp and password = temp
I get the error like this :
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'Audiolist.CategoryNameFROM Audiolist WHERE ((category)= [Madeh] )'

I am attaching the code file

I would also invite your suggestions/comments/inputs on the website.
Thanks ;)

[tasneem]

Hi
Thanks for the reply. I'll try it out.

As for your questions, well, that page has restriced access, to some audio clips. So category is the different types of those audio clips, and madeh is one type of that clip. So, when someone chooses madeh from the dropdown list, the page is supposed to show all the audio clips in that category in the form of a table.

Hope this answers your questions.

bye and thanks again.

[tasneem]

Hi
Thanks for clearing that up. CategoryName is the field in the database, where Madeh is one type of CategoryName. Now category is the string variable defined in the first part of the code, which is called in the sql statement in the second part of the code. Meaning, when someone chooses a CategoryName from the dropdown list (the first part, which is working OK), that choice is stored in the variable category. Then it called in the sql statement WHERE (this part is not working ).
Secondly, CategoryName is called from one table which contains only categories, the second table contains the actual audio clips, with CategoryName as one of the fields. So I have 2 tables in the same database, and the recordset query for the first table is working and the second table recordset query is not working.

Hope this is not as confusing as it looks to me. ;)

[tasneem]

hi
thanks