|
 |
asp_databases thread: Microsoft JET Database Engine error '80040e14'
Message #1 by "Bob" <bobage24@a...> on Sun, 17 Sep 2000 21:09:31 +0100
|
|
Hello,
I am trying to create a connection to a database and I am getting the
following error:
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'ID ='.
/BegASP/item.asp, line 30
Here is the code that is generating the error:
strSQL = "SELECT * FROM Gym WHERE ID = " & Request("Gym") & ";"
rsItem.Open strSQL, objConn, adOpenForwardOnly, adLockOptimistic,
adCmdText
End If
Thanks,
Bob
Message #2 by Imar Spaanjaars <Imar@S...> on Mon, 18 Sep 2000 09:02:11 +0200
|
|
Well, sounds like the Request("Gym") is empty.
Write out the strSQL with a Response.Write(strSQL) before you open your
recordset, and you'll see what the problem is.
Imar
At 08:03 AM 9/18/2000 -0700, you wrote:
>Hello,
>I am trying to create a connection to a database and I am getting the
>following error:
>Microsoft JET Database Engine error '80040e14'
>
>Syntax error (missing operator) in query expression 'ID ='.
>
>/BegASP/item.asp, line 30
>
>Here is the code that is generating the error:
>
>strSQL = "SELECT * FROM Gym WHERE ID = " & Request("Gym") & ";"
> rsItem.Open strSQL, objConn, adOpenForwardOnly, adLockOptimistic,
>adCmdText
> End If
>
>Thanks,
>Bob
>
>---
>You are currently subscribed to asp_databases
Message #3 by "Piotrowski, Sebastian" <Sebastian.Piotrowski@a...> on Mon, 18 Sep 2000 18:03:21 +1000
|
|
try dropping the ";" after SQL statment
and if request("Gym") is a string enclose it in "'" (single quotes)
ie. strSQL = "SELECT * FROM Gym WHERE ID = '" & Request("Gym") & "'"
make sure that request("Gym") actually contains a valid value
sebastian
-----Original Message-----
From: Bob [mailto:bobage24@a...]
Sent: Tuesday, 19 September 2000 01:04
To: ASP Databases
Subject: [asp_databases] Microsoft JET Database Engine error '80040e14'
Hello,
I am trying to create a connection to a database and I am getting the
following error:
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'ID ='.
/BegASP/item.asp, line 30
Here is the code that is generating the error:
strSQL = "SELECT * FROM Gym WHERE ID = " & Request("Gym") & ";"
rsItem.Open strSQL, objConn, adOpenForwardOnly, adLockOptimistic,
adCmdText
End If
Thanks,
Bob
---
You are currently subscribed to asp_databases
Message #4 by "Asmadi Ahmad" <chloro@e...> on Mon, 18 Sep 2000 15:27:53 +0800
|
|
I think your Request("Gym") should be request.form("Gym") assuming Gym is
your textbox / whatever 's name.
asmadi
www.effitech.com
----- Original Message -----
From: Bob <bobage24@a...>
To: ASP Databases <asp_databases@p...>
Sent: Monday, 18 September, 2000 11:03 PM
Subject: [asp_databases] Microsoft JET Database Engine error '80040e14'
> Hello,
> I am trying to create a connection to a database and I am getting the
> following error:
> Microsoft JET Database Engine error '80040e14'
>
> Syntax error (missing operator) in query expression 'ID ='.
>
> /BegASP/item.asp, line 30
>
> Here is the code that is generating the error:
>
> strSQL = "SELECT * FROM Gym WHERE ID = " & Request("Gym") & ";"
> rsItem.Open strSQL, objConn, adOpenForwardOnly, adLockOptimistic,
> adCmdText
> End If
>
> Thanks,
> Bob
>
> ---
> You are currently subscribed to asp_databases
$subst('Email.Unsub')
>
Message #5 by =?iso-8859-1?Q?Gonzalo_Ruiz_de_Villa_Su=E1rez?= <gonzalo.ruizdevilla@a...> on Mon, 18 Sep 2000 10:07:06 +0200
|
|
Try this and watch your sql sentence
strSQL = "SELECT * FROM Gym WHERE ID = " & Request("Gym") & ";"
Response.Write strSQL
rsItem.Open strSQL, objConn, adOpenForwardOnly, adLockOptimistic,
adCmdText
End If
-----Mensaje original-----
De: Bob [mailto:bobage24@a...]
Enviado el: lunes, 18 de septiembre de 2000 17:04
Para: ASP Databases
Asunto: [asp_databases] Microsoft JET Database Engine error '80040e14'
Hello,
I am trying to create a connection to a database and I am getting the
following error:
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'ID ='.
/BegASP/item.asp, line 30
Here is the code that is generating the error:
strSQL = "SELECT * FROM Gym WHERE ID = " & Request("Gym") & ";"
rsItem.Open strSQL, objConn, adOpenForwardOnly, adLockOptimistic,
adCmdText
End If
Thanks,
Bob
---
You are currently subscribed to asp_databases
|
|
|
View Cart
