var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Syntax error (missing operator) in query expression
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
And here is the code 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
It says the error is on the last line "results.Open()"
How do I fix this?
dreamweaver sucks at creating and maintaining database connections...try running the query in the database itself, then compare the database query with the query dreamweaver created.
I copied and pasted what you wrote to an editor:
'Band = ''A Perfect Circle'''
And I noticed that all the quotes are single quotes. I.e. even what looks like a double quote is really two single quotes.