Database Discussion - Newbie Help -

Print Page | Close Window

Newbie Help -

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=319
Printed Date: 28 March 2026 at 6:02am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Newbie Help -

Posted By: jdumayas
Subject: Newbie Help -
Date Posted: 19 February 2003 at 4:04pm

I'm using the guest book tutorial to test a database that I have created. I'm stuck on the deleting records tutorial. I've run into this error.

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '(offeringID=Pa_RaM000 AND title=Pa_RaM001 AND server=Pa_RaM002 AND permission_for_use=Pa_RaM003 AND date_of_prod=Pa_RaM004 AND typeID=Pa_RaM005 AND duration=Pa_RaM006 AND levelID=Pa_RaM007 AND require_cleanup=Pa_RaM008 AND copyright_added=Pa_RaM009 AND any_e'.
/ecomm/delete_entry.asp, line 32

I've checked my code with the one used in the guestbook tutorial, and everything matches as far as I can see. I had to change the db name and such, but I keep getting this error. Any assistance would be greatly appreciated. Thanks, Jeremy

Replies:

Posted By: michael
Date Posted: 19 February 2003 at 10:07pm

You complete SQL string seems pretty much messed up there. If you say you got the syntax from the turial right then it could be the form because the values that seems to be submitted (this PA_RaM00x stuff) does not seem to have anything to do with a Guestboo entry or the database is wrong. Give some details of the code and what you entered in the form....

Posted By: jdumayas
Date Posted: 20 February 2003 at 10:38am

Thanks for your help micheal. Something is coded incorrectly I just need to do a bit more research. To troubleshoot I renamed my tables and columns the same as they are in guestbook, and the transactions came out normal. I've been staring at code for hours and I can't find what the error would be. So I will keep looking at the syntax. Thanks for your help.

P.S. Would you happen to know of where I can find "join table" examples for ASP pages.

Thanks, Jeremy

Posted By: MorningZ
Date Posted: 20 February 2003 at 1:32pm

jdumayas wrote:

P.S. Would you happen to know of where I can find "join table" examples for ASP pages.�

Thanks, Jeremy

http://www.w3schools.com/sql/sql_join.asp - http://www.w3schools.com/sql/sql_join.asp

-------------
Contribute to the working anarchy we fondly call the Internet

Posted By: MorningZ
Date Posted: 20 February 2003 at 1:34pm

and btw, at the very end of the error code given in the first post here..

" AND any_e'"

uhh, that's not a valid clause (no operator and comparison value, hence the error: Syntax error (missing operator) in query expression)

One thing you will definitely learn as you go along is that Microsoft for the most part did an excellent job with reporting errors, its always right on the money

-------------
Contribute to the working anarchy we fondly call the Internet