Microsoft ODBC Microsoft Access Driver Syntax error

[mmchenney]

Help me I'm getting an error:

Microsoft ODBC Microsoft Access Driver Syntax error in string Query expression 'regions='

<%@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 HHSC_VoiceInventory 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,

 

[rajeessh]

Print the query
in Ie
using Response.Write and Response.End
Check the query by running directly in accessMDB

May be session may have null value or any misspelled column