question about EOF

Results 1 to 2 of 2

Thread: question about EOF

  1. #1
    Join Date
    Dec 1969

    Default question about EOF

    I have a db (access) with 11 different questions in it. Each question has three fields quiz id, question id and questions. Right now to list all eleven questions I am using Do While Not rsQuestions.EOF. If I wanted to add eleven more questions, but have the quiz id as 2 instead of one how would I write my do statement to only write quiz id 1 (questions 1-11 on quiz id 1) or quiz id 2 (the next 11 questions)? Any help would be greatly appreciated. Thanks.

  2. #2
    Reggie2 Guest

    Default RE: question about EOF

    You can use an if statement or just change your SQL Query<BR><BR>Using the if<BR>&#060;%<BR>Do While NOT rsQuestions.EOF<BR>if QuizID=1 then<BR>Response.write rsQuestions("question")<BR>end if<BR>%&#062;<BR><BR>or<BR>SQL Query<BR>&#060;%<BR>SQL_query = "SELECT * FROM TableName WHERE QuizID=1"<BR>%&#062;

Posting Permissions

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