Todd Vance

Todd Vance

  • NA
  • 60
  • 131.6k

Standard INSERT statement is not working in Express Web Developer?

Jun 4 2007 4:50 PM
Hey Everyone,

I am going through a beginning tutorial on making a sql database with asp -- the article to right click on the dbase and add New Query - then select from the dbase, etc. etc.  those all worked fine.

HOWEVER, it then tells me to insert a row -- it all looks standard and should work (here is what it says):
Try running an INSERT query to insert a new row in the quotes table:

INSERT (Author, Quote) INTO Quotes  VALUES ('Me', 'Life is good!')

But I get an error that reads:

SQL Execution error
Error Sourse .NetSql Data Provider
Error Message:  Incorrect Syntax near '('.

Any help on this one?

Answers (1)