--- In [email protected], "valdhor" <[EMAIL PROTECTED]> wrote:
>
> Nope - nothing to do with the XML.
> 
> You have a comma missing between :Sheet_Depth and :Unique_Product_Code
> in your sqlText variable in your insertData function.
> 
Cool, thanks for pointing that out as well. I've figured a few things
out myself. As a workaround, I decided to export the table I wanted as
a CVS document and import it into SQL Lite using a browser I
downloaded. One of the things I've noticed is that SQL Lite does not
like special characters such as "-" or "/" in what you're importing,
so after changing a few things, I got the table imported and all is well.

However, I think that along with that missing comma you pointed out,
my problem may also have something to do with trying to write these
forbidden special characters into the table. It would explain the
sheer number of errors. Thanks for everything though, to all those who
responded, I appreciate it. Another question though, just out or
curiosity, is it possible to use some sort of escape character(s) to
get those "-"'s and "/"'s into the table?

Reply via email to