Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Newbie Help -
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Newbie Help -
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
jdumayas View Drop Down
Newbie
Newbie
Avatar

Joined: 19 February 2003
Status: Offline
Points: 16 		Post Options Post Options   Thanks (0) Thanks(0)   Quote jdumayas Quote  Post ReplyReply Direct Link To This Post Topic: Newbie Help -
    Posted: 19 February 2003 at 4:04pm

Hi

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
Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670 		Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post 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....
Back to Top
jdumayas View Drop Down
Newbie
Newbie
Avatar

Joined: 19 February 2003
Status: Offline
Points: 16 		Post Options Post Options   Thanks (0) Thanks(0)   Quote jdumayas Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
MorningZ View Drop Down
Senior Member
Senior Member
Avatar

Joined: 06 May 2002
Location: United States
Status: Offline
Points: 1793 		Post Options Post Options   Thanks (0) Thanks(0)   Quote MorningZ Quote  Post ReplyReply Direct Link To This Post Posted: 20 February 2003 at 1:32pm
Originally posted by jdumayas 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
Contribute to the working anarchy we fondly call the Internet
Back to Top
MorningZ View Drop Down
Senior Member
Senior Member
Avatar

Joined: 06 May 2002
Location: United States
Status: Offline
Points: 1793 		Post Options Post Options   Thanks (0) Thanks(0)   Quote MorningZ Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.