I can't seem to figure out what's wrong
The error sez:<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error '80040e14' <BR><BR>[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Artist = BlueTonicWorld AND Title = A Child's Story'. <BR><BR>/updatedb.asp, line 25 <BR><BR><BR>this here is line 25:<BR>recordSet.Open "SELECT * FROM Songs WHERE Artist = '" & objID3.GetTrackArtist & "' AND Title = '" & objID3.GetTrackName & "'",sysConn,1,2<BR><BR>and i can't figure out whats wrong... help?
There seems to be an apostrophe in the search value A Child's Story. <BR><BR>For that to work in SQL you need to quote the apostrophe with another apostrophe. <BR><BR>recordSet.Open _<BR>"SELECT * FROM Songs " & _<BR> "WHERE Artist = '" & objID3.GetTrackArtist & "' " & _<BR> " AND Title = '" & replace(objID3.GetTrackName,"'","'' ") & _<BR> "'",sysConn,1,2<BR><BR>
I'd bet the olives in the martini you haven