Link to home
Start Free TrialLog in
Avatar of GegH
GegHFlag for New Zealand

asked on

Syntax error in WHERE clause

i seem to be getting this error message on my intranet page
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in WHERE clause.
/TelHMY.asp, line 24

The WHERE clause in question seems to be
<%
var HMYTel = Server.CreateObject("ADODB.Recordset");
HMYTel.ActiveConnection = MM_UseTelephone_STRING;
HMYTel.Source = "SELECT * FROM UseTelNumbers WHERE Group = '"+ HMYTel__MMColParam.replace(/'/g, "''") + "'";
HMYTel.CursorType = 0;
HMYTel.CursorLocation = 2;
HMYTel.LockType = 1;
HMYTel.Open();
var HMYTel_numRows = 0;
%>

HMYTel.Open(); is line 24.
The page is javascript .asp with a MS access database.
Any ideas
ASKER CERTIFIED SOLUTION
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of GegH

ASKER

I love the simple answers.
You are welcome!

/gustav