Devil's Angel — Tue, 23 Sep 2003 18:17:42 +0000

My database has a topics table and a table called survey. In survey i have fields called Topic, Topic2, Topic3, Topic4 and Topic5. These fields are linked to the TopicID and the topic name. Displayed in the Survey table is the topic name so those who report will see the name of the topic and not just a number.

druagord — Tue, 23 Sep 2003 17:50:18 +0000

Usually i design those relations with an intermediate table wich link users to topics. anyway for the error you get now could you ask for a print the sql statement to make sure you have the topicid inserted in it.

Devil's Angel — Tue, 23 Sep 2003 12:10:09 +0000

I get the following error for both:

Error Type:
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/News_Events/NSCC_Experts/qry_by_topic.asp, line 38

What I'm trying to set up is on one page a listing of "topics"; when you click on the topic it will give you a list of people who belong to that topic. I want to allow any given person to belong to a max of 5 topics and them to be listed accordingly.

Right now the topics listing works. If I only allow for one topic per person the whole thing works but I need to allow for them to possibly be under 5 categories.

It's probably something really simple I'm not doing right. I wonder if it's something in my database...

Mark Hensler — Mon, 22 Sep 2003 19:20:24 +0000

The extended OR join should be fine... maybe inclose it in parenthesis?

table_name ON (long OR stuff)

druagord — Mon, 22 Sep 2003 15:42:53 +0000

i would try to put it in the where clause

sql = "SELECT Survey.Topic, Survey.ExpertId, Survey.[Last Name], Survey.[First Name] FROM Survey WHERE (TopicTable.TopicID = [Survey].Topic OR TopicTable.TopicID = [Survey].Topic2 OR TopicTable.TopicID = [Survey].Topic3 OR TopicTable.TopicID = [Survey].Topic4 OR TopicTable.TopicID = [Survey].Topic5) AND (((TopicTable.TopicID)=" & Request.QueryString("TopicID") & ")) "