Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

INSERT statement not working

Status
Not open for further replies.
thysonj

thysonj

Programmer
Jul 6, 2001
240
US
Code: 
INSERT INTO editlog (user, ipnum, tablename, recordnum, referlink, logtime, logdate, loghost) VALUES ('pmhs', '10.0.0.102', 'CaseStudy', '1', '/hal/ute_form.asp', '3:29:22 PM', '2/6/2004', '10.0.0.102')

I get a syntax error in the insert into statement error.

Any ideas?
 
Sort by date Sort by votes
The statement works perfectly fine when I execute it in a query. When I execute through my web page(ASP) it errors out.
 
Upvote 0 Downvote
What's the error?

Have you turned on Friendly HTTP error messages in Internet Explorer?
Tools > Internet Options > Advanced > Uncheck "Show friendly HTTP error messages.

Also, this seems like it might belong more to the ASP forum than Access forms?

AB
 
Upvote 0 Downvote
stupid 'user' is a rserved word! needed [user]...real question is why it works on a different machine the 'wrong' way??!!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kennelbloke
  • Locked
  • Solved
Subform not updating in parent form
Replies
10
Views
962
Kennelbloke
Kennelbloke
TrekBiker
  • Locked
  • Question
Form Data Not Updating
Replies
6
Views
762
dhookom
dhookom
applestoapples
  • Locked
  • Question
Make Table Query sort not working 1
Replies
2
Views
337
Andrzejek
Andrzejek
TrekBiker
  • Locked
  • Question
Subform not updating 1
Replies
12
Views
935
TrekBiker
TrekBiker
bosk0
  • Locked
  • Question
Getting a syntax error in INSERT INTO statement 1
Replies
5
Views
363
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top