There are a few predefined characters that can confuse XML. A good article to peruse is at:
http://articles.techrepublic.com.com/5100-22-5032714.html '-' and '/' aren't listed. --- In [email protected], Michael Wills <[EMAIL PROTECTED]> wrote: > > 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 [email protected] > > <mailto:flexcoders%40yahoogroups.com>, "valdhor" <stevedepp@> 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? > > > > >
