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