www.webdeveloper.com
Results 1 to 2 of 2

Thread: SQL INSERT statement error...

  1. #1
    Join Date
    Apr 2006
    Posts
    4

    SQL INSERT statement error...

    This statement:
    'declare SQL statement that will query the database
    sSQL= "INSERT INTO CQCurrAssess (Fleet, DutyPosition, TrainingDate) VALUES ('" & Request.form("fleettype") &"', '" & Request.form("position") &"', '" & Request.form("trainingdate") & "')"

    Is generating this error:
    Error Type:
    Microsoft VBScript compilation (0x800A0401)
    Expected end of statement
    /flightcrew/hazcomm/CQTest.asp, line 14, column 779

    This is just an ASP file trying to write to a database. Appreciate the help if you can see where this is flawed.
    thanks,
    acc

  2. #2
    Join Date
    Mar 2006
    Posts
    591
    Could it be that your SQL statement is whitin an if statement or a for loop or something?

    Because the sql statement seems to be fine to me

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles