Getting SQL statement to work: <> [multiple ids] 1

[snowboardr]

strSQL = &quot;SELECT * FROM quiz WHERE quizID=&quot; & QuizID & &quot; AND qID <> (3, 4) ORDER BY Rand() LIMIT 0,1&quot;

I can't seem to get it to elimitated multiple ids:
qID <> (3, 4)

Any ideas?

- Jason
www.vzio.com
ASP WEB DEVELOPMENT

 

[sleipnir214]

That's because the &quot;not equals&quot; operator doesn't work the way you think it does. The right-hand side of &quot;<>&quot; must be a single value.

You should either do:

qID <> 3 AND qID <> 4


or

qID not in (3,4) ______________________________________________________________________
TANSTAAFL!

 

[snowboardr]

Thanks sleipnir214, the second one worked perfect, I tried it like that, but I guess it was slightly different, cause it wasn't working.

Thanks

Jason www.vzio.com
ASP WEB DEVELOPMENT