[flexcoders] Re: Need help finding and fixing SQL Error in AIR App

[bredwards358]

Here's the Insert statement snippet since it got cut off due to length:

private function insertData(node:XMLNode):void
             {//Quite possibly the biggest SQL statement I've ever done
thus far
                 var sqlText:String = "INSERT INTO Avery(Original,
Product_Code, Cross_Reference, Sequence, Unique_Product_ID, " +
                         "Trademark, Patent_Pending,
Avery_Product_Category, Product_Description, Priority_SKU, Product_Type,
" +
                         "Coated_Stock, Photo_Quality, Full_Bleed,
Mirror_Image_Required, Printer_Type, Corresponding_A4_SKU, " +
                         "Template_Family, Page_Size, Orientation,
Number_of_Lbls_Cards_per_Sheet, Label_Height, Label_Width, " +
                         "Corner_Radius, Number_Sections_Across,
Number_Sections_Down, Top_Margin, Bottom_Margin, Left_Margin, " +
                         "Right_Margin, Horiz_Pitch, Vertical_Pitch,
Sheet_Width, Sheet_Depth, Unique_Product_Code)" +
                 "VALUES(:Original, :Product_Code, :Cross_Reference,
:Sequence, :Unique_Product_ID, :Trademark, :Patent_Pending, " +
                 ":Avery_Product_Category, :Product_Description,
:Priority_SKU, :Product_Type, :Coated_Stock, :Photo_Quality, " +
                 ":Full_Bleed, :Mirror_Image_Required, :Printer_Type,
:Corresponding_A4_SKU, :Template_Family, :Page_Size, " +
                 ":Orientation, :Number_of_Lbls_Cards_per_Sheet,
:Label_Height, :Label_Width, :Corner_Radius, " +
                 ":Number_Sections_Across, :Number_Sections_Down,
:Top_Margin, :Bottom_Margin, :Left_Margin, :Right_Margin, " +
                 ":Horiz_Pitch, :Vertical_Pitch, :Sheet_Width,
:Sheet_Depth :Unique_Product_Code)";

                 insertStatement = new SQLStatement();
                 insertStatement.sqlConnection = conn;
                 insertStatement.addEventListener(SQLEvent.RESULT,
insertResult);
                 insertStatement.addEventListener(SQLErrorEvent.ERROR,
errorHandler);
                 insertStatement.text = sqlText;

                 insertStatement.parameters[":Original"] =
node.attributes.Original;
                 insertStatement.parameters[":Product_Code"] =
node.attributes.Product_Code;
                 insertStatement.parameters[":Cross_Reference"] =
node.attributes.Cross_Reference;
                 insertStatement.parameters[":Sequence"] =
node.attributes.Sequence;
                 insertStatement.parameters[":Unique_Product_ID"] =
node.attributes.Unique_Product_ID;
                 insertStatement.parameters[":Trademark"] =
node.attributes.Trademark;
                 insertStatement.parameters[":Patent_Pending"] =
node.attributes.Patent_Pending;
                 insertStatement.parameters[":Avery_Product_Category"] =
node.attributes.Avery_Product_Category;
                 insertStatement.parameters[":Product_Description"] =
node.attributes.Product_Description;
                 insertStatement.parameters[":Priority_SKU"] =
node.attributes.Priority_SKU;
                 insertStatement.parameters[":Product_Type"] =
node.attributes.Product_Type;
                 insertStatement.parameters[":Coated_Stock"] =
node.attributes.Coated_Stock;
                 insertStatement.parameters[":Photo_Quality"] =
node.attributes.PhotoQuality;
                 insertStatement.parameters[":Full_Bleed"] =
node.attributes.Full_Bleed;
                 insertStatement.parameters[":Mirror_Image_Required"] =
node.attributes.Mirror_Image_Required;
                 insertStatement.parameters[":Printer_Type"] =
node.attributes.Printer_Type;
                 insertStatement.parameters[":Corresponding_A4_SKU"] =
node.attributes.Corresponding_A4_SKU;
                 insertStatement.parameters[":Template_Family"] =
node.attributes.Template_Family;
                 insertStatement.parameters[":Page_Size"] =
node.attributes.Page_Size;
                 insertStatement.parameters[":Orientation"] =
node.attributes.Orientation;
                
insertStatement.parameters[":Number_of_Lbls_Cards_per_Sheet"] =
node.attributes.Number_of_Lbls_Cards_per_Sheet;
                 insertStatement.parameters[":Label_Height"] =
node.attributes.Label_Height;
                 insertStatement.parameters[":Label_Width"] =
node.attributes.Label_Width;
                 insertStatement.parameters[":Corner_Radius"] =
node.attributes.Corner_Radius;
                 insertStatement.parameters[":Number_Sections_Across"] =
node.attributes.Number_Sections_Across;
                 insertStatement.parameters[":Number_Sections_Down"] =
node.attributes.Number_Sections_Down;
                 insertStatement.parameters[":Top_Margin"] =
node.attributes.Top_Margin;
                 insertStatement.parameters[":Bottom_Margin"] =
node.attributes.Bottom_Margin;
                 insertStatement.parameters[":Left_Margin"] =
node.attributes.Left_Margin;
                 insertStatement.parameters[":Right_Margin"] =
node.attributes.Right_Margin;
                 insertStatement.parameters[":Horiz_Pitch"] =
node.attributes.Horiz_Pitch;
                 insertStatement.parameters[":Vertical_Pitch"] =
node.attributes.Vertical_Pitch;
                 insertStatement.parameters[":Sheet_Width"] =
node.attributes.Sheet_Width;
                 insertStatement.parameters[":Sheet_Depth"] =
node.attributes.Sheet_Depth;
                 insertStatement.parameters[":Unique_Product_Code"] =
node.attributes.Unique_Product_Code;

                 insertStatement.execute();
             }