Jag får syntax-error med denna sträng. Har testat med olika fnuttar. Någon som har en teori???
rsTravelDates.Source = "SELECT resedatum.reselinkid, events.eventID,
events.eventTitle FROM events RIGHT JOIN resedatum ON events.eventID =
resedatum.reselinkid WHERE resedatum.eventresedatum BETWEEN #" +
Replace(rsTravelDates__MMColFrom, "'", "''") + "# AND #" +
Replace(rsTravelDates__MMColTo, "'", "''") + "# AND
((resedatum.eventresedatum >= CURRENT_DATE)) GROUP BY
resedatum.reselinkid, events.eventID, events.eventTitle ORDER BY
events.eventTitle"
Felmeddelande: Microsoft OLE DB Provider for ODBC Drivers error '80040e09'
[MySQL][ODBC 3.51 Driver][mysqld-5.1.50]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
/search.asp, line 38