Option keyword problem 2

[Chuck Neal]

Actually scratch that.  Double quotes did work, its just that Studio 
does not clear out the error log so it looked as if it was repeating the 
same error.

-Chuck
--------------------------
Chuck Neal
CEO, MediaMacros, Inc.
chuck at mediamacros.com
http://www.mediamacros.com
http://www.mediamacros.net


Chuck Neal wrote:
> I managed to fix my code that had a database named "option" but now I am 
> having a similar problem on a table that has a field named option.  Here 
> is the insert query I am trying to use...
> 
> INSERT INTO Technique_Option (technique,dataField,parameter, option,ID) 
> VALUES ('S546GA-12384UO-5UUP6M-R', 'I2G8L5-11Q5GIK-T47Q0I-2T', 
> 'S546GA-1280JFG-2DJK2H-2', 'J2I5NG-12ALET9-2NJMT-7', 
> 'S546GA-12EB5HB-4JJ5VF-1' )
> 
> I have tried option in single quotes, double quotes, back ticks, even 
> with the table name in front and everything errors the same way.
> 
> Error: line 1:1: unexpected token: option
> 
> 
> Is there any way to escape this so that it will allow the field name? 
> Changing all of my databases is just not an option at this point, so I 
> need to find a way to work around the data name issue.  Thanks.
> 
> -Chuck
> --------------------------
> Chuck Neal
> CEO, MediaMacros, Inc.
> chuck at mediamacros.com
> http://www.mediamacros.com
> http://www.mediamacros.net
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>