Newbie help

Results 1 to 2 of 2

Thread: Newbie help

  1. #1
    Join Date
    Dec 1969

    Default Newbie help

    Somebody help ?<BR><BR>I have created a news posting database for my compines intranet but I&#039;m having problems getting my posts to date stamp automaticlly when posted, I get the following error:<BR><BR>Error Type:<BR>Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)<BR>[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.<BR>/PAGES/J&P News/html/add_news.asp, line 90<BR><BR><BR>Browser Type:<BR>Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0) <BR><BR>Page:<BR>POST 145 bytes to /PAGES/J&P News/html/add_news.asp<BR><BR>POST Data:<BR>NS_AUTHOR_ADD=&SEL_LOC=Perth&NS_DATE_ADD= Tuesday%2C+January+15%2C+2002&NS_SUB_ADD=date+test &NS_BODY_ADD=date+test&NS_DB_ADD=Submit&MM_insert= true<BR><BR>Line 90 contains this:<BR><BR>MM_editCmd.Execute<BR><BR>Any ideas ?<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Newbie help

    The error is in your Sql-query. One tip is too Response.Write your query in an html-comment so you can check it for errors....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts