Yes, just before I recieved your message I figured that one out :)

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

  ----- Original Message -----
  From: S. Isaac Dealey
  To: CF-Talk
  Sent: Friday, August 13, 2004 9:44 PM
  Subject: Re: Blown Away Query

  did you not get my reply? ... :)

  that was my first guess -- option is a reserved word. :)

  > 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