Going back over this conversation, perhaps you could use a pastebin to post the code chunks? I have seen http://pastebin.org/ but I haven't used it before. I am curious about the invalid characters though because the only thing I have seen in the docs so far is that you have to use two single quotes, i.e. '' to get a single quote ' inserted. So "Adobe's" would have to be "Adobe''s". But '-' and '/' aren't mentioned.
http://sqlite.org/faq.html#q14 bredwards358 wrote: > > --- In flexcoders@yahoogroups.com > <mailto:flexcoders%40yahoogroups.com>, "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? > >
