Syntax Error Help!

[mmchenney]

Getting Syntax error with this code: Can you help!

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in
query expression 'region ='.

/regions/webpages/HHSC_Voice_Consolidation/UpdateDelete.asp, line 11


<%@LANGUAGE=&quot;VBSCRIPT&quot;%>
<!--#include virtual=&quot;/regions/Connections/regional_personnel1.asp&quot; -->
<%
Dim Recordset1__MMColParam
Recordset1__MMColParam = &quot;1&quot;
if (Request.QueryString(&quot;Select&quot <> &quot;&quot then Recordset1__MMColParam =
Request.QueryString(&quot;Select&quot
%>
<%
set Recordset1 = Server.CreateObject(&quot;ADODB.Recordset&quot
Recordset1.ActiveConnection = MM_regional_personnel1_STRING
Recordset1.Source = &quot;SELECT * FROM PBX WHERE region = &quot; & Session(&quot;region&quot&
&quot; ORDER BY city ASC&quot;
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open()
Recordset1_numRows = 0
%>
<%
Thanks,

Molly

 

[derren]

Is region a text field? Because if it is the value needs to be enclosed in single quotes:

Recordset1.Source = "SELECT * FROM PBX WHERE region ='" & Session("region")& "' ORDER BY city ASC"

Hopefully that should fix it Derren
[Mediocre talent - spread really thin]