Figured it out ...DB didn't like "option" .. I changed it to boatOption and it worked ... go figure..

Paul Giesenhagen
QuillDesign
417-885-1375
http://www.quilldesign.com

  ----- Original Message -----
  From: Paul Giesenhagen
  To: CF-Talk
  Sent: Friday, August 13, 2004 8:09 PM
  Subject: OT: Blown Away Query

  Ok, this blows me away .. here is the query:

  INSERT INTO boatOptions (boatID,option) VALUES(13,'x')

  Simple enough?  Well I am getting Syntax Errors with it..

  BoatID = Int
  option = VarChar (75)

  Am I missing something here ...?

  Paul Giesenhagen
  QuillDesign
  417-885-1375
  http://www.quilldesign.com
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to