This is the full error:

Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'Band = ''A Perfect Circle'''.
/results.asp, line 20

I tried to fix this using a previous post about this error, but can't figure it out. Here's the code that Dreamweaver creates:

Set results = Server.CreateObject("ADODB.Recordset")
results.ActiveConnection = MM_shnlist_STRING
results.Source = "SELECT * FROM Bands WHERE Band = '" + Replace(results__MMColParam, "'", "''") + "'"
results.CursorType = 0
results.CursorLocation = 2
results.LockType = 1
results.Open()

Thanks