Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Microsoft ODBC Micro Access Driver Syntax error

Status
Not open for further replies.

mmchenney

Technical User
May 16, 2001
16
0
0
US
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,

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top