SQL Error

[Chuck Neal]

The quotes did not seem to work but I will try brackets.  I might need 
to talk to the client and see if we can work out a translation between 
the 2 apps so I can safely change the names as this looks like it will 
be e repeat problem.

-Chuck
--------------------------
Chuck Neal
CEO, MediaMacros, Inc.
chuck at mediamacros.com
http://www.mediamacros.com
--------------------------
Check out the Developers Mall
Your one stop shop for all your Director Xtra Needs
http://www.mediamacros.net/customer


Ruslan Zasukhin wrote:
> On 11/22/05 12:27 AM, "Chuck Neal" <chuck at mediamacros.com> wrote:
> 
> 
>>Unfortunately I do not have the luxury of changing it since its an
>>existing project.  Any work arounds other than using the API syntax?  I
>>really prefer to stick with SQL for now since this will be paralleling
>>another app that uses the same structure.
> 
> 
> You can try double quotes:
> 
>     INSERT INTO class (name,"text",ID)
> 
> Or [] 
> 
>     INSERT INTO class (name,[text],ID)
> 
> 
> Usually this is used when identifier have spaces.
> 
> 
>