Syntax error (missing operator) in query
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: General Discussion
Forum Description: General discussion and chat on any topic.
URL: https://forums.webwiz.net/forum_posts.asp?TID=15009
Printed Date: 31 March 2026 at 9:33pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Syntax error (missing operator) in query
Posted By: t4p67b96
Subject: Syntax error (missing operator) in query
Date Posted: 10 May 2005 at 10:36am
|
I have an asp page that I just want to add 3 other input forms. Those 3 forms go into an access database. This page I just want to display the totals. I declared all variables, and I CALL THOSE UP LATER IN TABLE CELLS IN ACCORDANCE WITH THE OTHER 3 ASP FORMS. Anyway I get this message.
Syntax error (missing operator) in query expression '* dcprov'. /plants/planttotal.asp, line 33 Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Provider = "Microsoft.Jet.OLEDB.4.0" Conn.ConnectionString = "Data Source=" & " file://\\test\test_data\plants\dcprov.mdb - \\test\test_data\plants\dcprov.mdb " Conn.Open Set rst = Server.CreateObject("ADODB.Recordset") rst.Open "Select * dcprov", Conn, 1, 1 What exactly is it looking for? I'm am fairly new to all of this asp.
Thanks in advance to any response.
 t4p67b96
|
Replies:
Posted By: dj air
Date Posted: 10 May 2005 at 10:40am
|
is the table called dcprov if so the query (Select * dcprov) should be Select dcprov.* FROM dcprov |
Posted By: t4p67b96
Date Posted: 10 May 2005 at 11:24am
|
Thank you very much. That worked.
t4p67b96
 |