| | |
| |
Active Server Pages help tutorial how to ASP Help ASP Tutorials ASP Programming ASP Code - ASP Free CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
I would really appreciate some help with 80040e14 error |
|
From: |
Jim McMahon |
|
Date: |
4/12/2000 1:51:14 PM |
|
IP: |
209.109.8.100 |
Can anyone please tell me, why do I keep getting an error when I do a search using SQL SELECT statement of an Access database? Thanks very much, --Jim
**Error message i keep getting**
Microsoft JET Database Engine error 80040e14
Syntax error in FROM clause.
**My code**
<% Option Explicit%>
<HTML>
<HEAD>
<meta http-equiv="content-type" content="text/html;charset=iso-8859-1">
<TITLE>Fine Arts Image Database Search Code</TITLE>
</HEAD>
<BODY bgcolor="#ffffff">
<TABLE>
<%
Dim varCAT1, varCAT2, varCAT3, varCAT4, varCAT5, varCAT6
varCAT1 = Request.Form("CAT1")
varCAT2 = Request.Form("CAT2")
varCAT3 = Request.Form("CAT3")
varCAT4 = Request.Form("CAT4")
varCAT5 = Request.Form("CAT5")
varCAT6 = Request.Form("CAT6")
Dim adOpenForwardOnly, adLockReadOnly, adCmdTable
adOpenForwardOnly = 0
adLockReadOnly = 1
adCmdTable = 2
Dim objConn, objRS, objCommand, strSQL
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source=C:/ArtHistory/FineArts/ImageSearch/FineArtsDB.mdb; " & _
"Persist Security Info=False"
Set objRS = Server.CreateObject("ADODB.RecordSet")
strSQL = "SELECT * FROM Fineart "
When I use this: [strSQL = "Fineart"] it works fine
objRS.Open strSQL, objConn, adOpenForwardOnly, adLockReadOnly, adCmdTable
While Not objRS.EOF
|
Follow Up - Re: I would really appreciate some help with 80040e14 error - Pradeep 4/14/2000 3:51:56 AM
Follow Up - Re: I would really appreciate some help with 80040e14 error - Shailesh Lolam 4/14/2000 9:49:22 AM
|
|
|
|
|
|
