Home » SQL & PL/SQL » SQL & PL/SQL » MS OLE DB Provider for ODBC Drivers error 80040e14 Getting Syntax error with this code: Can you hel
MS OLE DB Provider for ODBC Drivers error 80040e14 Getting Syntax error with this code: Can you hel [message #1302] Thu, 18 April 2002 13:34 Go to next message
Molly M. McHenney
Messages: 1
Registered: April 2002
Junior Member
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="VBSCRIPT"%>
<!--#include virtual="/regions/Connections/regional_personnel1.asp" -->
<%
Dim Recordset1__MMColParam
Recordset1__MMColParam = "1"
if (Request.QueryString("Select") <> "") then Recordset1__MMColParam =
Request.QueryString("Select")
%>
<%
set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_regional_personnel1_STRING
Recordset1.Source = "SELECT * FROM PBX WHERE region = " & Session("region")&
" ORDER BY city ASC"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open()
Recordset1_numRows = 0
%>
<%
Thanks,

Molly

Report message to a moderator

Re: MS OLE DB Provider for ODBC Drivers error 80040e14 Getting Syntax error with this code: Can you [message #1784 is a reply to message #1302] Wed, 29 May 2002 12:36 Go to previous message
Alina dos Passos
Messages: 1
Registered: May 2002
Junior Member
My problem is:

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

[[Microsoft]][[ODBC Microsoft Access Driver]] Missing semicolon (;) at end of SQL statement.

/livraria 2002/confCompra.asp, line 27

set regCompra=conn.Execute(" insert into compras(login,dataCompra,valor,formapgto) "&_
" values('"&session("login")&"', "&_
" '"&session("data")&"', "&_
" '"&request("txtTotal")&"', "&_
" '"&request("selFormaPgto")&"') "&_
" where login='"&session("login")&"' ")

Report message to a moderator

Previous Topic: SQL Query
Next Topic: PL/SQL prompting?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 19:45:14 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.