SQL Error

[Chuck Neal]

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.

-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


Ivan Smahin wrote:
> Hello Chuck,
> 
> Tuesday, November 22, 2005, 12:06:21 AM, you wrote:
> 
> CN> I am probably doing something obvious here but does anyone see anything
> CN> wrong with this.
> 
> CN> INSERT INTO class (name,text,ID) VALUES (:1 ,:2 ,:3 )
> CN> This is the data - ["Test Class", "This is a test of this class", 
> CN> "I2G8L5-11O3VGE-FRP6HU-1"]
> 
> CN> This comes up with this error...
> CN> ERROR: 462848
> 
> CN> I could not find that error in the list of error codes.  I also tried
> CN> inserting it directly in the SQL and got the same results.
> 
> 
> You should convert it to the hex.
> It would be 71000 - ERR_SQL_PARSER_ERROR.
> 
> 'text' seems to be a keyword.
> The best solution is to avoid using such an identifiers.
> 
> 
>