Results 1 to 2 of 2

Thread: access2000,

  1. #1
    Join Date
    Dec 1969

    Default access2000,

    hi all... i was wondring why the SQL statement below isn&#039;t working in ASP. it always generates an "INSERT INTO statment" error. i tried running this query on Access and it worked just fine! anyone?<BR><BR>INSERT INTO article (body,title,summary,keywords,dateposted,section,au thor,imagefile) VALUES ("asdasdf","asdf","sadf","sadf","3/26/2001","news","andrei","ad.asp") <BR>

  2. #2
    Lurker Guest

    Default RE: access2000,

    Try using # marks around the date field<BR><BR>INSERT INTO article (body,title,summary,keywords,dateposted,section,au thor,imagefile) VALUES ("asdasdf","asdf","sadf","sadf",#3/26/2001#,"news","andrei","ad.asp") <BR>

Posting Permissions

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